To Format a Range So That All Values Greater Than

question 57

Multiple Choice

To format a range so that all values greater than $500 appear in red,which of the following can you use?

• A) conditional formatting
• B) cell formatting
• C) cell styles
• D) Quick Access toolbar

---

Definitions:

Interior Support Frame

A structural element within objects or buildings that provides stability and support to the overall form.

Truthful

Corresponding to fact or reality; honest and accurate representation without deceit or falsification.

Photographs Lie

A statement reflecting the belief that photographs cannot always be trusted to represent reality accurately, as they can be manipulated or taken out of context.

Cathedral

A bishop’s church. The word derives from cathedra, referring to the bishop’s chair.