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
Choose Move or Copy from the Quick Access Toolbar
B
While pointing to the sheet tab, choose Copy from the Shortcut Menu
C
Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
D
While pointing to the Select All button, 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
Text
B
String
C
Thread
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
Copy
B
Move
C
Insert
D
Delete
5) Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?
A
Insert
B
Move
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
Find Select
B
Format Cell
C
Cell Styles
D
Font
7) John would like to remove a worksheet from his workbook. Which option would he choose?
A
Delete
B
Insert
C
Copy
D
Move
8) What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?
A
Freeze Panes
B
Select
C
Rotate
D
Zoom
9) Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose?
A
Tab Color
B
Insert
C
Move
D
Rename
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
Tab Color
D
Rename
11) How would sheet tabs be moved to a new position in the workbook?
A
Choose Move on the Home Ribbon
B
Click and drag the sheet tab to the new location
C
Choose Move on the Insert Ribbon
D
Choose Relocate on the Quick Access Toolbar
12) Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?
A
Scale
B
Hide
C
Freeze
D
Header
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
Sort
B
Filter
C
Find and Replace
D
AutoFill
*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?