Microsoft Excel - Domain 2

Front

Which of these methods can you use to insert a new row in a worksheet? Options: 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

Back

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

Front

Which of these methods can you use to set the width of a column in a worksheet? Options: 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

Back

Double-click between a column divider to make it AutoFit

Front

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

Back

Ctrl+Hyphen (-)

Front

Which is the correct shortcut to copy a worksheet to another sheet in the same workbook? Options: 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.

Back

Right click the worksheet tab, then choose Move or Copy

Front

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.

Back

Select Format in the Cells group and select Rename Sheet.

Front

Which of these methods can you use to set the width of a row in a worksheet? Options: 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

Back

Select Format in the Cells group and select AutoFit Row Height

Front

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

Back

Ctrl + X

Front

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

Back

Transpose

Front

Which of the following will allow you to access the Paste Special menu? Options: 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.

Back

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

Front

When you’ve copied data, which of the following IS NOT a correct method to paste it somewhere else? Options: 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.

Back

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