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)

Comments

Post a Comment

Popular posts from this blog

Question 6- What is conditional formatting?

-
Answer- Conditional formatting means highlighting or emphasizing selected cells on the basis of a criteria or condition. It allows us to set rules on how the cells should be formatted. We can change either the cell color or font color or font style of selected cells on the basis of a condition. We can highlight the cells with a background color to make the data more valuable.
Read more

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.
Read more