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.

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