Question

A teacher takes the following steps when beginning to apply conditional formatting to a spreadsheet. Format Conditional Formatting Add 1 Equal What should her next step be if she is attempting to highlight cells with values greater than 90 but less than 100? Click “between” under the equal menu, and then enter 90 in the first field and 100 in the second field. Click “greater than” and enter 90. Then apply Condition 2 and click “less than” under the equal menu and enter 100. Click “Apply Style”, and enter 90 in the first field and 100 in the second field. Click Result 1, apply Condition 2, and click Result 2.

Answer 1

The teacher should add two conditions in the conditional formatting: one for 'greater than 90' and another for 'less than 100' to highlight cells with values in that range.

Step-by-step explanation:

If the teacher wants to highlight cells with values greater than 90 but less than 100 in a spreadsheet, the correct step to take after selecting 'Format' > 'Conditional Formatting' would be to click on "greater than" and enter 90.

Then, the teacher should apply a second condition by selecting 'Add' again, click on "less than" and enter 100. It is important to ensure both conditions are set in the conditional formatting rules to accurately highlight the cells that meet the criteria of being more than 90 and less than 100.

Answer 2

To do conditional formatting for range of values Between is the right keyword where the starting range and the ending range can be defined. According to the question, the starting range is 90 and the ending range is 100.

So, between under the equal menu in the excel needs to be selected and the first field should contain the number 90 and the second field should hold 100. In the result, it includes field with 90 and 100 too. All the other option does not suit the objective.