Question

1) Mr. Abeer wanted to put the sum of 3 cells in a 4th cell. If the sum is greater than 10, he would like the some to be coloured red. If the sum is less than 10, he would like the sum to be coloured blue. Is this possible? If yes, then mention the steps.

2) You have an Excel spreadsheet and you would like to filter more than one type of criteria from a single column. How can we filter a single column based on one or more criteria?

3) You are trying to put some data in an alphabetical order. There are 4 columns and over 2,000+ rows of information. I need to sort the data in column B In an alphabetical order. Discuss the steps to execute it.​

Answer 1

ye sahi hai n faltu to nahi varna kyaa kr sakte hai ham nahi jante haai

Answer 2

Answer:

1) The concept of conditional formatting is applied.

2)The concept of filter is applied.

3) Sorting concept is applied.

Explanation:

1) If you wish to change the color of the font based on the value in a cell, you will need to apply conditional formatting.

• To do this, select the cell that you wish to apply the formatting to. In this example, we've selected cell B8.
• Under the Format menu, select Conditional Formatting.
• When the Conditional Formatting window appears, enter the first condition. In our example, we've selected when the cell value is greater than 10.
• Next, we need to select what formatting to apply when this condition is met. To do this, click on the Format button.
• When the Format Cells window appears, select the formatting conditions that you wish to apply. We've changed the Color to Red. Then click on the OK button.
• If you wish to apply more than one condition, you will need to click on the Add button.
• We've added three different conditions. When you're done, click on the OK button.
• Now when you return to the spreadsheet, the conditional formatting will be applied. As you can see, the value in cell B8 appears in red.

2. To filter by using the FILTER function in Excel, follow these steps:

1. Type =FILTER( to begin your filter formula
2. Type the address for the range of cells that contains the data that you want to filter, such as B1:C50
3. Type a comma, and then type the condition for the filter, such as C3:C50>3 (To set a condition, first type the address of the "criteria column" such as B1:B, then type an operator symbol such as greater than (>), and then type the criteria, such as the number 3.
4. Type a closing parenthesis and then press enter on the keyboard. Your entire formula will look like this: =FILTER(B1:C50,C1:C50>3)

3) To apply a sort in Excel, highlight the data that you wish to sort. Then select the Data tab from the toolbar at the top of the screen and click on the Sort button in the Sort & Filter group.

When the Sort window appears, select the data that you wish to sort by. In this example, we want to sort by the Product column (column B) in alphabetical order (A to Z). Click on the OK button.

Now when you return to the spreadsheet, the data should be sorted.

Learn more about excel:

• https://brainly.in/question/5659035
• https://brainly.in/question/14564288
• https://brainly.in/question/15557028