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 3- What do you know about filter feature of MS Excel?

-
Answer- In MS Excel filter feature is used to filter out only a desired data from a larger set of data. It will hide all the unwanted data and only the data specified in the filter will be shown. For example - We have a worksheet containing data about employees . Column A contains name and Column B contains Salary. If you want to see how many employees earn less than 10 thousand you can check the values in filter of column B which are less than 10 thousand . The result will be all the employees earning less than 10 thousand.
Read more

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