8
RCMultiple Choice

Use Data Structures — Cumulative exam

Question 8 • Introduction to Information Technology - EL3701

Conditional formatting allows spreadsheet users to

Answer
A
turn cell protection functions on and off.
B
calculate the average number of people at sporting events.
C
highlight test scores of below 90% in a grade book.
D
add additional formatting options to a menu.

Explanation

Conditional formatting changes how cells look when they meet a specified rule. For example, a grade book can automatically highlight test scores below 90%, making them easy to spot. It does not calculate averages or control cell protection.

AI-written and checked against the verified answer.

Previous
Next