Microsoft Excel Module 2

1. Which of these methods can you use to insert a new row in a worksheet?

• 1. Right-click or access the context menu for a row number, select Insert

• 1. Right-click or access the context menu for a column header, select Insert

• 1. Right-click or access the context menu for a cell, select Insert Entire Row

• 1. Home, Cells group, Insert > Insert Sheet Rows

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

Select the correct option.

• 1. Double-click between a column divider to make it AutoFit

• 1. Select the divider between 2 rows and drag up or down

• 1. Right-click or access the context menu for a column header and select Row Height

• 1. Select Format in the Cells group and select Row Height

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

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

Select the correct option

• 1. Ctrl+Plus sign (+)

• 1. Ctrl+Slash (/)

• 1. Ctrl+Hyphen (-)

• 1. Ctrl+Asterisk (*)

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

• 1. Select the sheet to copy, then use Ctrl, drag and drop

• 1. Select the sheet to copy, then use drag and drop

• 1. Select the sheet to copy, then use Shift, drag and drop

• 1. Select the sheet to copy, then use Alt, drag and drop

1. Which of the following processes can you use to rename a worksheet?

Select all that apply.

• 1. Right-click in any blank cell and select Rename Sheet.

• 1. Right-click on the sheet tab and select Rename.

• 1. Select Format in the Cells group and select Edit Sheet Name.

• 1. Select Format in the Cells group and select Rename Sheet.

1. Which of these methods can you use to set the width of a row in a worksheet?

Select all that apply.

• 1. Select Format in the Cells group and select AutoFit Row Height

• 1. Right-click on a row header and select Column Height

• 1. Double-click between a column divider to make it AutoFit

• Right-click on a row header and select Row Height

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

Select the correct option.

• 1. Ctrl+Shift+Plus sign (+)

• 1. Ctrl+Hyphen (-)

• 1. Ctrl+Asterisk (*)

• 1. Ctrl+Slash (/)

1. Ctrl+C is the keyboard shortcut to _____ data?

1. What is the keyboard shortcut to cut data from a cell?

Select the correct option.

• 1. Ctrl+C

• 1. Ctrl+D

• 1. Ctrl+X

• 1. Ctrl+Z