Mastering Excel Shortcut Keys

What shortcut key is used to save a workbook?

• Ctrl + S

• Shift + S

• Alt + S

• Ctrl + W

Which key combination opens the Find and Replace dialog?

• Ctrl + F

• Ctrl + H

• Alt + H

• Ctrl + R

What is the shortcut for copying selected cells?

• Alt + C

• Ctrl + C

• Ctrl + X

• Ctrl + V

How do you paste copied cells using a shortcut?

• Right-click and select 'Paste' from the menu.

• Use Ctrl+C to paste cells.

• Press Alt+P to paste copied cells.

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

Which shortcut key is used to undo the last action?

• Alt + Z

• Ctrl + Z

• Ctrl + Y

• Shift + Z

What is the shortcut for redoing an action in Excel?

• Shift + Y

• Ctrl+ Y

• Alt + R

• Ctrl + Z

How do you select the entire column in a worksheet?

• Right-click on the worksheet

• Select the row header

• Click on the column header.

• Press Ctrl + Spacebar

What shortcut key allows you to insert a new worksheet?

• Shift + F11

• Ctrl + N

• Alt + Shift + N

• F12

Which key combination is used to open the Format Cells dialog?

• Ctrl + 1

• Shift + F10

• Alt + F

• Ctrl + Shift + C

What is the shortcut for creating a chart from selected data?

• Ctrl + Alt + C (Windows) / Command + Option + C (Mac)

• Alt + D (Windows) / Option + D (Mac)

• F11

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