Module 2

When you cut data from a cell, Excel adds it to the ______________________________

Clipboard

Ctrl+C is the keyboard shortcut to ______________________ data?

Copy

Instead of removing all the commands you added to the Quick Access Toolbar, you can use the _______________________ tool to set it back to only the default commands.

Reset

Which of the following command does not belong to the Windows group on the View tab? 1. Hide 2. Split 3. Zoom 4. Arrange Al

Zoom

Which of these methods can you use to set the width of a column in a worksheet? 1. Double-click between a column divider to make it AutoFit 2. Select the divider between 2 rows and drag up or down 3. Right-click or access the context menu for a column header and select Row Height 4. Select Format in the Cells group and select Row Height

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

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 2. Right-click on a row header and select Column Height 3. Double-click between a column divider to make it AutoFit 4. Right-click on a row header and select Row Height

1. Select Format in the Cells group and select AutoFit Row Height 4. Right-click on a row header and select Row Height

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 2. Select the sheet to copy, then use drag and drop 3. Select the sheet to copy, then use Shift, drag and drop 4. Select the sheet to copy, then use Alt, drag and drop

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

When you've copied data, which of the following is a correct method to paste it somewhere else? SELECT ALL THAT APPLY 1. Select where you want to paste the data, and then select enter on your keyboard 2. Right-click or access the context menu for where you want to paste the data, and select Paste 3. Select where to paste, and then select Ctrl+V 4. Right-click or access the context menu for where you want to paste the data, and then select Paste here.

1. Select where you want to paste the data, and then select enter on your keyboard. 2. Right-click or access the context menu for where you want to paste the data, and select Paste 3. Select where to paste, and then select Ctrl+V

Which of the following statements are true? 1. The Quick Access Toolbar can be moved to beneath the ribbon 2. The Quick Access Toolbar cannot be reset to default settings 3. The Quick Access Toolbar cannot be moved beneath the ribbon 4. The Quick Access Toolbar cannot be hidden from view

1. The Quick Access Toolbar can be moved to beneath the ribbon

The keyboard shortcut to access the Paste Special dialog box is: 1. Ctrl+Alt+A 2. Ctrl+V 3. Ctrl+Alt+V 4. Ctrl+Shift+P

3. Ctrl+Alt+V

You can find Freeze panes on the _______________ tab.

View

The Quick Access Toolbar has which commands by default? SELECT ALL THAT APPLY 1. AutoSave 2. Save As 3. Undo 4. Redo

1. AutoSave 3. Undo 4. Redo

To insert a row into a worksheet, you can select the row header and use which of the following keyboard shortcuts? 1. Ctrl+Plus sign (+) 2. Ctrl+Hyphen (-) 3. Ctrl+Asterisk (*) 4. Ctrl+Slash (/)

1. Ctrl+Plus sign (+)

In the bottom left corner of the Microsoft Excel interface which of the following screen views are not available? 1. Print preview 2. Page break preview 3. Page layout 4. Normal

1. Print preview

You can customize the Quick Access Toolbar via which method? SELECT ALL THAT APPLY 1. Right-click or access the context menu of a button on the ribbon and add it Right-click or access the context menu on the ribbon and select Customize Quick Access Toolbar On the File tab, select Options, and then select the Quick Access Toolbar Right-click or access the context menu on top of a button on the Quick Access Toolbar and remove it

1. Right-click or access the context menu of a button on the ribbon and add it Right-click or access the context menu on the ribbon and select Customize Quick Access Toolbar On the File tab, select Options, and then select the Quick Access Toolbar Right-click or access the context menu on top of a button on the Quick Access Toolbar and remove it

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. 2. Right-click on the sheet tab and select Rename. 3. Select Format in the Cells group and select Edit Sheet Name. 4. Select Format in the Cells group and select Rename Sheet.

2. Right-click on the sheet tab and select Rename. 4. Select Format in the Cells group and select Rename Sheet.

Which statement is true? SELECT ALL THAT APPLY 1. When you've right-clicked or accessed the context menu on a cell where you want to paste data, Paste Special is not available on the context menu. 2. When you've right-clicked or accessed the context menu on a cell where you want to paste data, you can select Paste Special on the context menu. 3. When you've copied data, you can access Paste Special using Ctrl+Alt+V 4. The Paste Special button can be found on the Paste drop-down arrow on the Home tab.

2. When you've right-clicked or accessed the context menu on a cell where you want to paste data, you can select Paste Special on the context menu. 3. When you've copied data, you can access Paste Special using Ctrl+Alt+V 4. The Paste Special button can be found on the Paste drop-down arrow on the Home tab.

To delete a column in a worksheet, you can select the column header and use which of the following keyboard shortcuts: 1. Ctrl+Plus sign (+) 2. Ctrl+Slash (/) 3. Ctrl+Hyphen (-) 4. Ctrl+Asterisk (*)

3. Ctrl+Hyphen (-)

What is the keyboard shortcut to cut data from a cell? 1. Ctrl+C 2. Ctrl+D 3. Ctrl+X 4. Ctrl+Z

3. Ctrl+X

To paste copied data from horizontal to vertical, which option would you use Paste Special? 1. Values 2. Formulas 3. Transpose 4. Formatting only

3. Transpose

To display more than one workbook on the screen at the same time, you would use the ___________________________ command.

Arrange all

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

AutoFit

Which of these methods can you use to insert a new row in a worksheet? SELECT ALL THAT APPLY 1. Right-click or access the context menu for a row number, select Insert 2. Right-click or access the context menu for a column header, select Insert 3. Right-click or access the context menu for a cell, select Insert Entire Row 4. Home, Cells group, Insert > Insert Sheet Rows

Right-click or access the context menu for a row number, select Insert 4. Home, Cells group, Insert > Insert Sheet Rows

The option that allows you to copy data that is vertical and paste it horizontally is known as _____________________

Transpose