Features of MS Excel
Graphical user interface
Excel is a software based on the GUI (Graphical user Interface) principle, that means information is exchanged between the user and the software through images, so that the software can be easily worked on.
Automatic Recalculation
If changes are made to the value of a formula in a table created in Excel, Excel automatically recalculates and updates the result.
Use of Functions
Excel has a number of pre-built programs to perform many functions which when used in calculation avoids the lengthy process of calculating the user and soon results are obtained in various types of functions - mathematical, numerical, Financial, logical etc.
Formatting
Excel provides formatting to attract workbook. Excel also allows to insert text in various formats along with Numbers, date, time etc.
Database
The data available in Excel can be stored and controlled properly, the user can create reports according to the user according to the Sort, filter.
Creating Graph
In order to display the data effectively in Excel, the data can be displayed as a graph so that they can be analyzed properly. Charts make data easy to read and understand Excel has many types of charts like - Column, Bar, Line, Pie, XY Scatter, Doughnut, Surface, Bubble, Stock etc.
Editing
Once the data is typed in an Excel worksheet, improvements can be made under the correction to type new data, delete old data or make changes to it.
Saving and Printing
All worksheets created in Excel can be stored as files in secondary storage for future and hard copy of worksheet can also be obtained by printer.
Data editing in worksheet
The data interchanged in MS Excel can be changed as required, in which the data can be changed in four ways.
- During entry (while entering)
- After Entry (After Entry)
- Change Entry (Change Entry)
- Delete Entry
During entry
When we enter a cell, it is displayed in the formula, so when the entry is miss-typed, we can delete it again with the help of Backspace and make the correct entry again.
After Entry
If we have entered once and if we need to change it, we first click on the cell to be modified, after that the old entry can be changed by pressing the F2 key or by double clicking on the cell with the mouse. Older entries can be converted to cells.
Change Entry
If we have made a wrong entry in a cell, then this entire entry can be changed for this by moving the cell pointer to that cell - typing new entry from the board deletes the old one.
Delete Entry
If the entry of a cell is to be deleted, move the pointer to that cell, press the Del Key, or right mouse click on the cell and click on Clear content or delete.
This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.
ConversionConversion EmoticonEmoticon