192218
AssignmentMultiple Dropdowns

Analyzing Data

Question 192218 • 110 CCHS Business Computer Applications - Office 2019

Select the correct navigational path to mark all teachers who have achieved “excellent” on their evaluations a red background.

Answer
Click the tab on the ribbon and look in the gallery.:

Conditional Formatting

Select .:

New Rule

Select and fill in the formula for the IF statement and formatting. Click OK.:

“Use a formula”