What are the main features of MS Excel?
Answers
◆ MS Excel provides the feature of spreadsheet through which the user can enter data very easily as each sheet us formatted into rows and columns.
◆ MS Excel provides the feature of representing information graphically in the form of charts.
◆ The excellent feature of MS Excel is "SORTING DATA". The physical rearrangement of data in ascending or descending order is called sorting.
◆ Cell reference is also an important feature of MS Excel because a cell reference identifies the location of a cell or a group of cells in the spreadsheet. Cell reference is generally of three types -
[1] RELATIVE REFERENCE
[2] ABSOLUTE REFERENCE
[3] MIXED REFERENCE
◆ Filtering data.
◆ You can import data in MS Excel 2007. So, importing data in MS Excel is also its feature.
IF YOU LIKE MY ANSWER, PLEASE MARK ME AS BRAINLIEST MATE...............!!!!!!!!
FOLLOW ME FOR MORE SOLUTIONS OF YOUR DOUBTS..........!!!!!!!!
BE BRAINLY........!!!!!!!!
Answer:
1. Add Header and Footer
MS Excel allows us to keep the header and footer in our spreadsheet document.
2. Find and Replace Command
MS Excel allows us to find the needed data (text and numbers) in the workbook and also replace the existing data with a new one.
3. Password Protection
It allows the user to protect their workbooks by using a password from unauthorized access to their information.
4. Data Filtering
Filtering is a quick and easy way to find and work with a subset of data in a range. A filtered range displays only the rows that meet the criteria you specify for a column. MS Excel provides two commands for filtering ranges:
• AutoFilter; which includes filter by selection, for simple criteria
• Advanced Filter; for more complex criteria
5. Data Sorting
Data sorting is the process of arranging data in some logical order. MS Excel allows us to sort data either in ascending or descending order.
6. Built-in formulae
MS Excel has got many built-in formulae for sum, average, minimum, etc. We can use those formulae as per our needs.
7. Create different charts (Pivot Table Report)
MS Excel allows us to create different charts such as bar graph, pie- charts, line graphs, etc. This helps us to analyze and compare data very easily.
8. Automatically edits the result
MS Excel automatically edits the result if any changes are made in any of the cells.
9. Formula Auditing
Using formula auditing we can graphically display or trace the relationships between cells and formulas with blue arrows. We can trace the precedents (the cells that provide data to a specific cell) or the dependents (the cells that depend on the value in a specific cell).