Excel Vocab 1 "Basic Navigations"

Match the Key Borad shortcut to its action

• Select adjacent columns, row, or cells

• Shift Click

• Select non-adjacent columns, row, or cells

• Ctrl + C

• Copy

• Ctrl + F4

• Undo

• Ctrl + Z

• Closes Excel

• Ctrl Click

To change Margins you need to go to ​ ​ (a)   -> ​ (b)  

• Page Layout
• Custom Margins
• View
• Format
• Home
• Print Are
• Print Area
• IDK

What does the shortcut Ctrl + V do?

• Copy

• Undo

• Paste

• All of the Above

What does the shortcut Ctrl + A do?

To set the Print Area you need to choose ​ (a)   ribbon -> ​ (b)   command. To set the Print Titles you need to choose​ the Page Layout ribbon -> ​ (c)   command. To change your margins you should choose the ​page layout ribbon -> ​ (d)   command. In order to freeze ONLY the top row of a spreadsheet, you choose the ​ (e)   ribbon -> Freeze Paynes then choose freeze top row.

• Page Layout
• Print Area
• Print Titles
• Custom Margin
• View

Which Ribbon, Group and Command is used to copy a worksheet between workbooks?

• Data, Outline, Group

• Home, Cells, Format

• Page Layout, Page Setup, Orientation

• Review, Comments, New Comment

Which Ribbon, Group and Command is used to set margins to narrow?

• Home, Alignment, Merge & Center dropdown, Merge cells

• Home, Cells, Format, Autofit Cells

• Page Layout, Page Setup, Margin Dropdown Custom Margin

• Page Layout, Page Setup, Margin Dropdown, Narrow

Which Ribbon, Group and Command is used to set row height or colum widths?

• Data, Outline, Group

• Home, Cells, Format

• Page Layout, Page Setup, Orientation

• Review, Comments, New Comment

Match the following.

• Redo

• CTRL + P

• Autosum

• CTRL + S

• Save

• Windows +Shift + S

• Print

• CTRL + Y

• Screen Clip

• ALT + PLUS