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 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

Question 4- Write the steps to add a new record in database using form.

-
Answer- Adding New  Records Using Form We can add new records in our database using form feature of Ms Excel. To add new records, follow the given steps- Step 1- Select a cell and click on Form button in the Quick Access Toolbar . A dialog box appears on the screen. Step 2- Click on New button to add a new record in our database. Step 3- Here we can type the information for new record. Step 4- Click on Close button to exit from data form. Hence, the new record will be entered in our database.
Read more