Module 2 Questions

Which of these methods can you use to insert a new row in a worksheet? Select all that apply.

• Right-click or access the context menu for a row number, select Insert
• Right-click or access the context menu for a column header, select Insert
• Right-click or access the context menu for a cell, select Insert Entire Row
• Home, Cells group, Insert > Insert Sheet Rows

Which is the correct shortcut to copy a worksheet to another sheet in the same workbook?

• Select the sheet to copy, then use Ctrl, drag and drop
• Select the sheet to copy, then use drag and drop
• Select the sheet to copy, then use Shift, drag and drop
• Select the sheet to copy, then use Alt, drag and drop

Which of the following processes can you use to rename a worksheet? Select all that apply.

• Right-click in any blank cell and select Rename Sheet.
• Right-click on the sheet tab and select Rename.
• Select Format in the Cells group and select Edit Sheet Name.
• Select Format in the Cells group and select Rename Sheet.

Which of these methods can you use to set the width of a row in a worksheet? Select all that apply.

• Select Format in the Cells group and select AutoFit Row Height
• Right-click on a row header and select Column Height
• Double-click between a column divider to make it AutoFit
• Right-click on a row header and select Row Height

Which of these methods can you use to set the width of a column in a worksheet?

• Double-click between a column divider to make it AutoFit
• Select the divider between 2 rows and drag up or down
• Right-click or access the context menu on a column header and select Row Height
• Select Format in the Cells group and select Row Height

When you select all the columns in your worksheet and double-click on a column divider, that is known as ______________________________.

• Autofit
• Autocorrect
• Autodrive
• Autowidth

To delete a column in a worksheet, you can select the column header and use which of the following keyboard shortcuts:

• Ctrl+Plus sign (+)
• Ctrl+Slash (/)
• Ctrl+Hyphen (-)
• Ctrl+Asterisk (*)

To insert a row into a worksheet, you can select the row header, and use which of the following keyboard shortcuts?

• Ctrl+Plus sign (+)
• Ctrl+Hyphen (-)
• Ctrl+Asterisk (*)
• Ctrl+Slash (/)

What is the keyboard shortcut to cut data from a cell? Select the correct option.

• Ctrl+C
• Ctrl+D
• Ctrl+X
• Ctrl+Z

Ctrl+C is the keyboard shortcut to ______________________ data.

• cut
• copy
• paste
• remove