Question 5- Name the two options available in MS Excel for filtering data.
Answer- Following are the two options available in MS Excel for filtering data-
(i) Auto Filter ( For simple criteria)
(ii) Advanced Filter ( For more complex criteria)
Question 8- Write the steps to apply sorting to a selected range of cells.
Answer- Follow the given steps to sort data of a selected range of cells- Step 1- Open Excel sheet. Step 2- Select the cell range we want to sort. Step 3- Click on Sort button in the Sort & Filter group on Data tab. Step 4- The Sort dialog box will appear. Choose the column you want to sort by. Step 5- Decide the sorting order (either ascending or descending). Step 6- Once you're satisfied with your selection, click OK. The cell range will be sorted by the selected column.
Comments
Post a Comment