Have an account?
Skip to Content
Build your own quiz
.png)
12 questions
Show Answers
See Preview
- 1. Multiple Choice
Which command is used to insert a cut or copied selection to a cell or range of cells?
Paste
Document Properties
Copy
Range
- 2. Multiple Choice
Content that has been cut or copied to the clipboard will have a marching dashed green border around it.
TRUE
FALSE
- 3. Multiple Choice
To select cells that are not adjacent (next to) each other, use which of the following keys while clicking on each cell?
Ctrl
Alt
Shift
Fn
- 4. Drop Down
Look at the picture. If I want to move 'horse' up to blank cell above it, I will need to (a) the cell and (b) cells up. If I want to remove all of the colors but leave the same number of cells, I will need to (c) the contents. Pressing the delete key on the (d) is the same thing as clearing the (e) .
deleteclearkeyboardcontentsshift - 5. Multiple Choice
Which of the following statements describes how to unhide a hidden row or column?
Select a range of cells in the row or column, right-click, and select Unhide.
Use the Page Setup dialog box.
Remove all page breaks.
Select the rows/columns before and after the hidden rows/columns and then right-click and select Unhide.
- 6. Multiple Choice
Which cell would you click to freeze Rows 1-5 and Column A?
A5
B5
A6
B6
- 7. Multiple Choice
In order for you to freeze the first column of a worksheet into a frozen pane:
The entire contents of the column must be visible.
The first row of the column must be non-blank.
Duplicate worksheets must also be able to have their first columns frozen.
You can click Freeze First Column in the Freeze Panes menu.
- 8. Multiple ChoiceHow do you insert a new row?Right-click the row heading where you want to insert the new row and select Insert from the shortcut menuSelect the row heading where you want to insert the new row and select Edit >Row from the menuSelect the row heading where you want to insert the new row and click the Insert Row button on the standard toolbarAll of the above
- 9. Multiple ChoiceHow do you select an entire column?Select Edit > Select > Column from the menuClick the column heading letterHold down the shift key as you click anywhere in the column.Hold down the Ctrl key as you click anywhere in the column
- 10. Multiple ChoiceIn a cell reference, for example A1, what does the letter refer to?The columnThe cellThe row
- 11. Match
Match the paste option with its function.
Paste Values
Paste just the contents of the cells...not the formatting.
Keep Source Formatting
Paste only the format of the cells...not the contents
Paste
The default paste option
Paste Formatting
Keep the formatting of the copied cells
- 12. Multiple Choice
Pressing the delete key on the keyboard will delete the entire cell requiring you to decide how to shift cells to move them into the empty spot.
TRUE
FALSE
- Answer choicesTagsAnswer choicesTags