8
AssignmentMultiple Select

Advanced Spreadsheet Features

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

Which of the following are characteristics of conditional formatting? Choose all that apply.

Answer
A
formatting only applied when a cell meets specific criteria
B
automatically applies formatting to cells that meet specific criteria
C
protects spreadsheet data by requiring a password to make changes
D
generates a graphical representation of spreadsheet data

Explanation

Conditional formatting applies formatting based on whether a cell meets specified criteria. It can also automatically format cells as they meet those criteria. Password protection controls access to changes, and generating a graphical representation is the role of charts, so C and D are not characteristics of conditional formatting.

AI-written and checked against the verified answer.

Previous
Next