Excel Module 2

When you've copied data, which of the following is a correct method to paste it somewhere else?

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.

The keyboard shortcut to access the Paste Special dialog box is:

Ctrl + Alt + V

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

Ctrl + Hyphen (-)

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

Ctrl + Plus sign (+)

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

Ctrl + X

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

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

arrange all

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

autofit

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

clipboard

The Quick Access Toolbar has which commands by default?

1. AutoSave 2. Undo 3. Redo

Which statement is true?

1. 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. 2. When you've copied data, you can access Paste Special using Ctrl+Alt+V. 3. The Paste Special button can be found on the Paste drop-down arrow on the Home tab

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

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

transpose

You can find Freeze panes on the ___________ tab.

view

Which of the following commands does not belong to the Windows group on the View tab?

zoom

Ctrl + C is the keyboard shortcut to _________________ data.

copy

In the bottom left corner of the Excel interface which of the following screen views are not available.

print preview

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

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

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 2.Home, Cells group, Insert > Insert Sheet Rows

You can customize the Quick Access Toolbar via which method?

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

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

1. Select Format in the Cells group and select AutoFit Row Height 2.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?

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

Which of the following statements are true?

The Quick Access Toolbar can be moved to beneath the ribbon

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

Transpose