a teacher takes the following steps when beginning to apply conditional formatting to a spreadsheet. format…

a teacher takes the following steps when beginning to apply conditional formatting to a spreadsheet. format → conditional formatting → add → condition 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.

a teacher takes the following steps when beginning to apply conditional formatting to a spreadsheet. format → conditional formatting → add → condition 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

Answer:

A. Click "between" under the equal menu, and then enter 90 in the first field and 100 in the second field.

Explanation:

Step1: Identify the goal

Highlight values 90 < x < 100.

Step2: Analyze option A

"Between" suits the range condition.

Step3: Analyze option B

Separate "greater than" and "less than" steps are not the best - way for this range.

Step4: Analyze option C

There is no "Apply Style" for this range - setting purpose.

Step5: Analyze option D

The described steps don't match range - setting in conditional formatting.