Mastering Excel Shortcut Keys

What shortcut key is used to save a workbook in Excel?

• Ctrl + S

• Ctrl + P

• Alt + S

• Shift + S

Which key combination opens the Find and Replace dialog?

• Alt + R (Windows) / Command + R (Mac)

• Ctrl + F (Windows) / Command + F (Mac)

• Shift + H (Windows) / Command + Shift + F (Mac)

• Ctrl + H (Windows) / Command + Option + F (Mac)

What is the shortcut for copying selected cells?

• Ctrl + A

• Ctrl + X

• Ctrl + C

• Ctrl + V

How do you paste copied cells using a shortcut?

• Press Shift+V to paste copied cells.

• Use Ctrl+V (Windows) or Command+V (Mac) to paste copied cells.

• Use Alt+P to paste cells.

• Right-click and select 'Insert' to paste.

Which shortcut key is used to undo the last action?

• Ctrl + Z

• Ctrl + Y

• Alt + Z

• Ctrl + X

What is the shortcut for creating a new workbook?

• Alt + N

• Shift + N

• Ctrl + M

• Ctrl + N (Windows) / Command + N (Mac)

How do you select the entire column in Excel using a shortcut?

• Press 'Ctrl + A' to select the entire column in Excel.

• Use 'Alt + C' to select the entire column in Excel.

• Press 'Shift + Space' to select the entire column in Excel.

• Press 'Ctrl + Space' to select the entire column in Excel.

What shortcut key is used to open the Format Cells dialog?

• Alt + F

• Shift + F10

• Ctrl + Shift + C

• Ctrl + 1

Which key combination allows you to insert a new worksheet?

• Ctrl + N

• Alt + Shift + N

• F12

• Shift + F11

What is the shortcut for printing the current worksheet?

• Ctrl + S (Windows) / Command + S (Mac)

• Alt + F4 (Windows) / Command + Q (Mac)

• Shift + P (Windows) / Shift + P (Mac)

• Ctrl + P (Windows) / Command + P (Mac)