Ask Question
19 April, 04:31

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.

+5
Answers (1)
  1. 19 April, 04:41
    0
    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.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “A teacher takes the following steps when beginning to apply conditional formatting to a spreadsheet. Format Conditional Formatting Add 1 ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers