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 7- What do you mean by data validation?

-
  Answer- Data validation is a feature in MS 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. Data validation can simply display a message to a user telling them what is allowed.Data validation can also stop invalid user input.In addition, data validation can be used to present the user with a predefined choice in a dropdown menu.
Read more