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 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.
Comments
Post a Comment