5
AssignmentMultiple Choice

Advanced Spreadsheet Features

Question 5 • CHS- TX-Professional Communications (CR)

Which of the following explains why librarians would apply conditional formatting to the library patron’s account spreadsheet?

Answer
A
to quickly locate patrons who have overdue books
B
to make automatic phone calls to patrons with overdue books
C
to display a value equivalent to the number of days the books are overdue
D
to calculate late fees

Explanation

Conditional formatting changes how cells look when they meet a rule, such as highlighting accounts with overdue books. This makes those patrons quick to locate. It does not make phone calls, display a calculated number of overdue days, or calculate late fees; those require other features.

AI-written and checked against the verified answer.