36
QuizMultiple Choice
Cumulative Exam
Question 36 of 50 • CHS- TX-Professional Communications (CR)
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?
Answer
A
Click “between” under the equal menu, and then enter 90 in the first field and 100 in the second field.B
Click “greater than” and enter 90. Then apply Condition 2 and click “less than” under the equal menu and enter 100.C
Click “Apply Style”, and enter 90 in the first field and 100 in the second field.D
Click Result 1, apply Condition 2, and click Result 2.