Excel Shortcuts and Formatting Quiz

Which keyboard shortcut enters the same data into multiple cells?

• Ctrl + Enter

• Ctrl + C

• Ctrl + V

What is the best way to format a cell to display currency?

• Use font color

• Apply number formatting

• Add borders

What is the purpose of data validation?

• Change font styles

• Restrict the type of data entered

• Sort data in ascending order

How do you quickly select an entire column in Excel?

• Click the column header

• Press Ctrl + A

• Double-click in any cell

What does freezing panes help you achieve?

• Lock specific rows or columns in place

• Add conditional formatting

• Merge cells

Which feature allows you to highlight duplicate values in a dataset?

• Conditional Formatting

• Data Validation

• Freeze Panes

If you want to auto-fill the next date in a series, what should you do?

• Type each date manually

• Drag the fill handle

• Use a formula

Which of the following aligns text to the center?

• Ctrl + Alt

• Ctrl + Shift + C

• Use the alignment buttons in the ribbon

What is the keyboard shortcut for undo?

• Ctrl + Z

• Ctrl + Y

• Ctrl + X

Which formatting option makes headers stand out?

• Changing text color

• Freezing panes

• Filtering data