Introduction to FP&A: Conditional Formatting Quiz

What tab in Excel contains the "Conditional Formatting" command?

• Insert

• Data

• Home

• View

Which type of formatting adds visual symbols like arrows or check marks?

• Data Bars

• Color Scales

• Icon Sets

• Text Highlight

Where can you find the option to create a custom conditional formatting rule?

• Developer Tab

• Conditional Formatting → New Rule

• Review Tab

• Insert → Symbols

Which icon set would best represent performance (positive, neutral, negative)?

• Stars

• Traffic lights

• Color scales

• Data bars

What should you always do after applying a conditional formatting rule?

• Save and close

• Double-check results and adjust if necessary

• Refresh formulas

• Print worksheet

What happens when you copy a cell with conditional formatting?

• The format is lost

• Only values are copied

• Conditional formatting is copied too

• Charts are created

What does the “Clear Rules” option do in Excel?

• Deletes cells

• Removes formatting rules

• Erases data

• Refreshes formulas

Can conditional formatting be applied to entire rows?

• No

• Yes, using formulas

Which is NOT a type of conditional formatting rule?

• Icon Set

• Color Scale

• Line Graph

• Data Bar

What tool lets you check for duplicate conditional rules?

• Rule Manager

• Format Painter

• Developer Tab

• Chart Wizard