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

Answer:

Click “between” under the equal menu, and then enter 90 in the first field and 100 in the second field

Explanation:

Since the user wants to highlight fields which contains value which are greater than 90 and less than 100, the operation seems to work well with “between” operator or between function. Since there is a start range and the end range it is better to deal with between function.

The other choices will not work because the greater than or less than operator works only on single value. Only the “between operations” works well on range of values.  All the other options are invalid.