Excel Formatting Quiz

Which tab provides quick access to commonly used formatting options in Excel 2007?

• Review

• Insert

• Home

• Page Layout

What is the shortcut to open the Format Cells dialog box in Excel?

• Ctrl+4

• Ctrl+3

• Ctrl+2

• Ctrl+1

Which tab in Excel allows you to apply cell styles for quick formatting?

• View

• Insert

• Data

• Home

What feature on the standard toolbar is used for formatting text in Excel?

• AutoFormat

• Style Painter

• Format Painter

• Font Styler

How can you hide a selected column in Excel?

• Click on the Format tab

• Press Ctrl+H

• Double-click the column header

• Right-click and select Hide

Which tab in Excel allows you to protect and unprotect worksheets?

• View

• Review

• Data

• Home

What does the AutoFormat feature in Excel use to format ranges of cells?

• Custom styles

• Predefined templates

• Table styles

• Conditional formatting

How can you apply a border and color to a selection in Excel using the Format Cells dialog box?

• Select Format -> Cells -> Alignment

• Select Format -> Cells -> Font

• Select Format -> Cells -> Patterns

• Select Format -> Cells -> Border

What does the Alignment tab in the Format Cells dialog box allow you to change?

• Font attributes

• Cell position and alignment

• Background color

• Number formats

Which tab in the Format Cells dialog box allows you to select the data type for formatting?

• Font

• Border

• Alignment

• Number