+2 votes
in Economics by kratos

Mention different features of MS excel.

1 Answer

+1 vote
by kratos
 
Best answer

The different features of MS excel is as follows;

1. Excel Charts: Excel provides a vast number of chart types and options.

2. Formulas and Functions: Another great feature of Excel is the ability to embed formulas into cells to calculate data. In addition, an impressive list of built-in functions is provided that can be used to summarize data.

3. Cell Formatting: You can customize the formatting of a cell or range of cells. You can apply borders, cell background , font size and , number formatting and much more.

4. Sorting and Filtering: You can reorder the data or pick out just the data you need, based on parameters you set within Excel. Sorting and filtering your data will save you time and make your spreadsheet more effective.

5. Pivot Tables: Summarise large amounts of Excel data from a database that is formatted where the first row contains headings and the other rows contain categories or values.

Other features are:

  • Create and manipulate simple (flat-file) databases
  • Establish relationships between sets of numerical data
  • Apply arithmetic, mathematical or statistical functions to numerical datasets
  • Represent datasets in graphical or chart form
...