Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Microsoft Excel 1.08
Test Description: Excel 2016
Instructions: Answer all questions to get your test result.
1) How is an exact copy of a worksheet created within the same workbook?
A
While pointing to the sheet tab, choose Copy from the Shortcut Menu
B
While pointing to the Select All button, choose Move or Copy from the Shortcut Menu
C
Choose Move or Copy from the Quick Access Toolbar
D
Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
2) What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?
A
Thread
B
Text
C
String
D
Key
3) Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?
A
Split
B
Hide
C
Page Break
D
Freeze
4) John would like to change the order of the worksheets in his workbook. Which option would he choose?
A
Move
B
Insert
C
Delete
D
Copy
5) Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?
A
Move
B
Insert
C
Rename
D
Tab Color
6) Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting?
A
Format Cell
B
Find Select
C
Font
D
Cell Styles
7) John would like to remove a worksheet from his workbook. Which option would he choose?
A
Insert
B
Delete
C
Move
D
Copy
8) What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?
A
Select
B
Freeze Panes
C
Rotate
D
Zoom
9) Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose?
A
Tab Color
B
Rename
C
Move
D
Insert
10) Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose?
A
Move
B
Insert
C
Rename
D
Tab Color
11) How would sheet tabs be moved to a new position in the workbook?
A
Choose Move on the Insert Ribbon
B
Choose Relocate on the Quick Access Toolbar
C
Click and drag the sheet tab to the new location
D
Choose Move on the Home Ribbon
12) Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?
A
Header
B
Scale
C
Hide
D
Freeze
13) David wants to change all occurrences of 'North Carolina' to 'NC' in his spreadsheet. What command should he use to complete this task?
A
Find and Replace
B
Sort
C
AutoFill
D
Filter
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?