Analyzing Data Answers

5 verified answers1 views
146837
Free Preview

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

Answers:
Click the tab on the ribbon and look in the gallery.:Home
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”
146838

Clipboard Alignment Number ✔ Conditional Formatting

A
Clipboard
B
Alignment
C
Number
D
✔ Conditional Formatting
146839

✔ New RuleManage Rule Clear Rule

A
✔ New Rule
B
Manage Rule
C
Clear Rule
146840

“Format only top or bottom” “Format all cells”✔ “Use a formula”

A
“Format only top or bottom”
B
“Format all cells”
C
✔ “Use a formula”

Did you find these answers helpful?