Excel Shortcut Keys Quiz

You are working on a budget spreadsheet and want to make sure your changes are stored permanently. What shortcut do you use to save your work?

• Ctrl+S

• Ctrl S

• Ctrl B

• Ctrl S

While organizing a list of products, you decide to copy a column of item names and place them in another sheet. What shortcut allows you to copy the selected column?

• Ctrl C

• Ctrl + P

• Ctrl + C

• Ctrl + I

You've made a mistake and opened the wrong file. Now, you want to open the correct workbook from your folder. Which shortcut will help you do this?

• Ctrl + N

• Ctrl + N

• Ctrl O

• Ctrl+O

After preparing a sales report, your teacher asks for a printout. What shortcut lets you quickly access the print dialog?

• Ctrl P

• Ctrl+P

• Ctrl+S

• Alt

You typed a header in plain text but want to emphasize it by making the font bold. What shortcut would you press?

• Ctrl+I

• Ctrl+U

• Ctrl+B

• Ctrl U

You want to give the title a slightly different style by making it italic. Which shortcut applies italic formatting?

• CtrL+I

• Ctrl + U

• Ctrl+U

• Ctrl+I

A student asks to see the last cell with data in your worksheet. You don't want to scroll manually. What shortcut takes you to the last used cell?

• CtRl+END

• Ctrl END

• Ctrl+END

• Ctrl + END

You want to move a block of student names from one column to another. After selecting and cutting, which shortcut lets you paste the block?

• Ctrl+C

• Ctrl+P

• Ctrl+V

• CTRL V

Your computer crashed earlier, so this time you want to start by creating a new workbook. What is the shortcut for this?

• Ctrl+O

• Ctrl O

• Ctrl + N

• Ctrl+N

You've scrolled down a long sheet. Now you need to return to the beginning of the worksheet. Which shortcut will do this quickly?

• CTRL H

• Ctrl+END

• Ctrl+H

• Ctrl+Home