what are features of Ms Excel?
Answers
Answered by
16
Answer:
Features of Microsoft Excel
Add Header and Footer. MS Excel allows us to keep the header and footer in our spreadsheet document.Data Sorting. Data sorting is the process of arranging data in some logical order. ...Built-in formulae. ...Create different charts (Pivot Table Report) ...Automatically edits the result.
Explanation:
plz mark me as brainliest
Answered by
18
Basic and important features of MS Excel
1) Pivot Tables
PivotTables 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. The way the data is summarised is flexible but usually the Pivot Table will contain values summed over some or all of the categories.
2) Conditional Formatting
Conditional formatting, as its name suggests, changes the format of a cell dependent on the content of the cell, or a range of cells, or another cell or cells in the workbook. Conditional formatting helps users to quickly focus on important aspects of a spreadsheet or to highlight errors and to identify important patterns in data.
3) Sorting and Filtering
Excel spreadsheets help us make sense of large amounts of data. To make it easier to find what you need, 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.
4) Basic Math
At the heart of any Excel spreadsheet are the numbers within the data. Using basic math functions to manipulate those numbers is one of the features that makes Excel so powerful.
Simple calculations can be entered into the formula bar in Excel just as they would be written on paper. As with all formulae in Excel, start a calculation with the = sign.
5) Mixed Type Charts
Mixed type or combo (combination) charts combine two styles of charts, such as Excel’s column chart and line chart. This format can be helpful for displaying two different types of information or a range of values that varies greatly.
1) Pivot Tables
PivotTables 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. The way the data is summarised is flexible but usually the Pivot Table will contain values summed over some or all of the categories.
2) Conditional Formatting
Conditional formatting, as its name suggests, changes the format of a cell dependent on the content of the cell, or a range of cells, or another cell or cells in the workbook. Conditional formatting helps users to quickly focus on important aspects of a spreadsheet or to highlight errors and to identify important patterns in data.
3) Sorting and Filtering
Excel spreadsheets help us make sense of large amounts of data. To make it easier to find what you need, 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.
4) Basic Math
At the heart of any Excel spreadsheet are the numbers within the data. Using basic math functions to manipulate those numbers is one of the features that makes Excel so powerful.
Simple calculations can be entered into the formula bar in Excel just as they would be written on paper. As with all formulae in Excel, start a calculation with the = sign.
5) Mixed Type Charts
Mixed type or combo (combination) charts combine two styles of charts, such as Excel’s column chart and line chart. This format can be helpful for displaying two different types of information or a range of values that varies greatly.
Similar questions