Sunday 22 March 2020

MICROSOFT EXCEL AND ITS FEATURE

Definition : 
                    microsoft excel is a spreadsheet software that allows to enter, analyze and manage our data. It provides built in feature and tools such as formulas, functions and data analysis tools to work quickly with large amount of data.

Features of MS excel : 
                                     1. microsoft excel contains workbooks, which store information in                     worksheets.
2. A worksheets consists of 16,384 columns and 10,48,576  rows.
3. Each cell of excel worksheet has a unique name . for example, A3 denoting column A and            row 3.
4. Offers compatibility with various RDBMS software like FoxPro and MS access.
5. Supports graphics and charts.
6. In MS excel, we can easily add,remove,rename,move or copy worksheets.
7. Provide many built in function to automate the work in quick, easy and effective manner.
8. Auto calculation : the data is automatically recalculated in the whole worksheets if any                change is made in a single cell.
9. Fast searching and instant replacing of data.
10. Allows to group and outline data.
11. Contains facilities like auto list, spelling and grammer check, find and replace etc. for      jhj        effective data entry.
12. Allows to sort data on one or more field.
13. Supports what - if analysis.
14. Allows you to link various worksheet in such a manner that the change in one worksheet            effect the result in the other.
15. Allows you to automate your work using macros.
16. MS excel has a powerful support for printing feature.
17. MS excel also has a support for drawing toolbar for drawing various objects.

No comments:

Post a Comment