Question

1. What is
2. Define sorting. How the data can be sorted in Microsoft Excel?
3. What is data filtering? Explain the way to extract data using Custom AutoFilter.
4. What is data validation? How is it used to enter valid cell values?
5. What are the benefits of using conditional formatting?​

Answer 1

Explanation:

2) Sorting in excel is nothing but arranging data stored in excel according to your requirement. It can be done by depending on the value type stored in cells.

To sort a range:

Select the cell range you want to sort. ...

Select the Data tab on the Ribbon, then click the Sort command.

The Sort dialog box will appear. ...

Decide the sorting order (either ascending or descending). ...

Once you're satisfied with your selection, click OK.

The cell range will be sorted by the selected column.

2)Data filtering is the task of reducing the content of noise or errors from measured process data. It is an important task because measurement noise masks the important features in the data and limits their usefulness in practice. Select the field that you want to use for your custom AutoFilter.

Turn on excel filter

Select the field where you want to use it

Describe Auto filter operations

Describe Auto filters criteria

Click Ok

3)Data validation is a feature in Excel used to control what a user can enter into a cell. For example, you could use data validation to make sure a value is a number between 1 and 6, make sure a date occurs in the next 30 days, or make sure a text entry is less than 25 characters.

4)The spreadsheet will have the ability to format itself as you are working on it in real time. This means that anything you do within the spreadsheet will be brought to your attention quicker if the cells were to change their format.