WorksheetsExcel Lesson 8 Quiz
Total questions: 14
Worksheet time: 14mins
Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?
Freeze
Header
Hide
Scale
What command will arrange Microsoft Excel windows so that they appear side-by-side on the screen?
Zoom to Selection
New Window
Arrange All
Freeze Panes
John would like to change the order of the worksheets in his workbook. Which option would he choose?
Insert
Delete
Copy
Move
How is an exact copy of a worksheet created within the same workbook?
While pointing to the sheet tab, choose Copy from the Shortcut Menu
Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
While pointing to the Select All button, choose Move or Copy from the Shortcut Menu
Choose Move or Copy from the Quick Access Toolbar
Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?
Insert
Move
Rename
Tab Color
David wants to change all occurrences of "North Carolina" to "NC" in his spreadsheet. What command should he use to complete this task?
AutoFill
Filter
Find and Replace
Sort
Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting?
Font
Format Cell
Cell Styles
Find & Select
What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?
Text
String
Thread
Key
Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose?
Insert
Move
Rename
Tab Color
How would sheet tabs be moved to a new position in the workbook?
Choose Move on the Home Ribbon
Click and drag the sheet tab to the new location
Choose Move on the Insert Ribbon
Choose Relocate on the Quick Access Toolbar
Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?
Freeze
Split
Page Break
Hide
John would like to remove a worksheet from his workbook. Which option would he choose?
Insert
Delete
Copy
Move
Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose?
Insert
Move
Rename
Tab Color
What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?
Zoom
Select
Freeze Panes
Rotate
