Introduction to FP&A: Conditional Formatting Investigation

How can conditional formatting help identify financial anomalies?

• By summarizing financial statements

• By automatically sorting values

• By highlighting outliers using visual cues

• By deleting invalid data

How does conditional formatting help improve decision-making?

• By filtering data

• By turning formulas into charts

• By making trends and problems visually obvious

• By deleting errors

Which of the following is NOT a type of conditional formatting available in Excel?

• Highlight Cell Rules

• Color Scales

• Icon Sets

• Pie Charts

What is the purpose of “Data Bars” in conditional formatting?

• Add graphs to cells

• Represent values visually within cells

• Highlight errors

• Sort data

Which statement best describes the use of Icon Sets in Excel's conditional formatting?

• Icon Sets replace data with emojis for visual appeal

• Icon Sets allow users to filter data using icons

• Icon Sets visually represent values using symbols like arrows or traffic lights

• Icon Sets are only available in Excel Premium edition

What does a “Color Scale” do in conditional formatting?

• Turns all values one color

• Applies a gradient based on value ranges

• Displays numbers as icons

• Removes cell borders