Font size
S
M
L
XL
WorksheetsModule 2 Questions
Total questions: 24
Worksheet time: 12mins
Name
Class
Date
1.
Which of these methods can you use to insert a new row in a worksheet? Select all that apply.
a)
Right-click or access the context menu for a row number, select Insert
b)
Right-click or access the context menu for a column header, select Insert
c)
Right-click or access the context menu for a cell, select Insert Entire Row
d)
Home, Cells group, Insert > Insert Sheet Rows
2.
Which is the correct shortcut to copy a worksheet to another sheet in the same workbook?
a)
Select the sheet to copy, then use Ctrl, drag and drop
b)
Select the sheet to copy, then use drag and drop
c)
Select the sheet to copy, then use Shift, drag and drop
d)
Select the sheet to copy, then use Alt, drag and drop
3.
Which of the following processes can you use to rename a worksheet? Select all that apply.
a)
Right-click in any blank cell and select Rename Sheet.
b)
Right-click on the sheet tab and select Rename.
c)
Select Format in the Cells group and select Edit Sheet Name.
d)
Select Format in the Cells group and select Rename Sheet.
4.
Which of these methods can you use to set the width of a row in a worksheet? Select all that apply.
a)
Select Format in the Cells group and select AutoFit Row Height
b)
Right-click on a row header and select Column Height
c)
Double-click between a column divider to make it AutoFit
d)
Right-click on a row header and select Row Height
5.
Which of these methods can you use to set the width of a column in a worksheet?
a)
Double-click between a column divider to make it AutoFit
b)
Select the divider between 2 rows and drag up or down
c)
Right-click or access the context menu on a column header and select Row Height
d)
Select Format in the Cells group and select Row Height
6.
When you select all the columns in your worksheet and double-click on a column divider, that is known as ______________________________.
a)
Autofit
b)
Autocorrect
c)
Autodrive
d)
Autowidth
7.
To delete a column in a worksheet, you can select the column header and use which of the following keyboard shortcuts:
a)
Ctrl+Plus sign (+)
b)
Ctrl+Slash (/)
c)
Ctrl+Hyphen (-)
d)
Ctrl+Asterisk (*)
8.
To insert a row into a worksheet, you can select the row header, and use which of the following keyboard shortcuts?
a)
Ctrl+Plus sign (+)
b)
Ctrl+Hyphen (-)
c)
Ctrl+Asterisk (*)
d)
Ctrl+Slash (/)
9.
What is the keyboard shortcut to cut data from a cell?
Select the correct option.
a)
Ctrl+C
b)
Ctrl+D
c)
Ctrl+X
d)
Ctrl+Z
10.
Ctrl+C is the keyboard shortcut to ______________________ data.
a)
cut
b)
copy
c)
paste
d)
remove
11.
To paste copied data from horizontal to vertical, which option would you use from Paste Special?
a)
Values
b)
Formulas
c)
Transpose
d)
Formatting only
12.
The keyboard shortcut to access the Paste Special dialog box is:
a)
Ctrl+Alt+A
b)
Ctrl+V
c)
Ctrl+Alt+V
d)
Ctrl+Shift+P
13.
When you’ve copied data, which of the following is a correct method to paste it somewhere else? Select all that apply.
a)
Select where you want to paste the data, and then select enter on your keyboard.
b)
Right-click or access the context menu for where you want to paste the data, and select Paste.
c)
Select where to paste, and then select Ctrl+V.
d)
Right-click or access the context menu for where you want to paste the data, and then select Paste here.
14.
The option that allows you to copy data that is vertical and paste it horizontally is known as _____________________ .
a)
move
b)
special
c)
transpose
d)
copy
15.
Which statement is true? Select all that apply.
a)
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.
b)
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.
c)
When you’ve copied data, you can access Paste Special using Ctrl+Alt+V.
d)
The Paste Special button can be found on the Paste drop-down arrow on the Home tab.
16.
When you cut data from a cell, Excel adds it to the ______________________________.
a)
special board
b)
file
c)
cloud
d)
clipboard
17.
The Quick Access Toolbar has which commands by default? Check all that apply.
a)
AutoSave
b)
Save As
c)
Undo
d)
Redo
18.
You can customize the Quick Access Toolbar via which method? Select all that apply.
a)
Right-click or access the context menu of a button on the ribbon and add it
b)
Right-click or access the context menu on the ribbon and select Customize Quick Access Toolbar
c)
On the File tab, select Options, and then select the Quick Access Toolbar.
d)
Right-click or access the context menu on top of a button on the Quick Access Toolbar and remove it
19.
You can find Freeze panes on the ___________ tab.
a)
the View tab
b)
the Insert tab
c)
the Diagram tab
d)
the Format tab
20.
Which of the following commands does not belong to the Windows group on the View tab?
a)
Hide
b)
Split
c)
Zoom
d)
Arrange All
21.
Which of the following statements are true?
a)
The Quick Access Toolbar can be moved to beneath the ribbon
b)
The Quick Access Toolbar cannot be reset to default settings
c)
The Quick Access Toolbar cannot be moved beneath the ribbon
d)
The Quick Access Toolbar cannot be hidden from view
22.
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.
a)
Review
b)
Reset
c)
Remove
d)
Redo
23.
In the bottom left corner of the Excel interface which of the following screen views are not available.
a)
Print preview
b)
Page break preview
c)
Page layout
d)
Normal
24.
To display more than one workbook on the screen at the same time, you would use __________ command.
a)
Rearrange
b)
Remove
c)
Reset
d)
Arrange all
Reset
