Microsoft Excel - Domain 2

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

• 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

• Click the insert button on the page layout tab

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

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

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

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

• Select Format in the Cells group and select Row Height

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 (*)

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

• Right click the worksheet tab, then choose Move or Copy

• Select the worksheet to copy, then use drag and drop

• Select the worksheet to copy, then use Shift, drag and drop

• click the File tab, then Save As and name the worksheet to your choice.

Which of the following processes can you use to rename a WORKSHEET?

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

• Go to File > Save As and change the neame

• 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 Format in the Cells group and select AutoFit Row Height

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

• Double-click in a cell you want to change and select AutoFit

• Select Format in the Cells group and select AutoFit Column Width

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

• Ctrl + C

• Ctrl + D

• Ctrl + X

• Ctrl + Z

To paste copied data from horizontal to vertical, which option would you use from Paste Special?

• Values

• Formulas

• Transpose

• Formatting Only

Which of the following will allow you to access the Paste Special menu?

• Select the cell you want and click Paste Special on the Format tab.

• Select the cell you want click the View Tab, then choose Paste Special

• Select and right click on the cell you want and select Paste Special.

• Select the cell you want, then choose Paste on the Home tab.

When you’ve copied data, which of the following IS NOT a correct method to paste it somewhere else?

• Select where you want to paste the data, and then select enter on your keyboard.

• Right-click or access the context menu for where you want to paste the data, and select Paste.

• Select where to paste, and then select Ctrl+V.

• Right-click or access the context menu for where you want to paste the data, and then select Paste here.