Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
MS Excel Honors #3
Test Description: Final Review
Instructions: Answer all questions to get your test result.
1) John would like to change the order of the worksheets in his workbook. Which option would he choose?
A
Delete
B
Insert
C
Copy
D
Move
2) 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
Page Break
B
Freeze
C
Split
D
Hide
3) What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?
A
Freeze Panes
B
Rotate
C
Select
D
Zoom
4) How would sheet tabs be moved to a new position in the workbook?
A
Choose Relocate on the Quick Access Toolbar
B
Click and drag the sheet tab to the new location
C
Choose Move on the Insert Ribbon
D
Choose Move on the Home Ribbon
5) How is an exact copy of a worksheet created within the same workbook?
A
Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
B
Choose Move or Copy from the Quick Access Toolbar
C
While pointing to the sheet tab, choose Copy from the Shortcut Menu
D
While pointing to the Select All button, choose Move or Copy from the Shortcut Menu
6) What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?
A
Key
B
Thread
C
Text
D
String
7) 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
Hide
C
Scale
D
Freeze
8) What command will arrange Microsoft Excel windows so that they appear side-by-side on the screen?
A
Arrange All
B
Freeze Panes
C
Zoom to Selection
D
New Window
9) Where is the spell checker feature located in Microsoft Excel?
A
Page Layout Ribbon
B
View Ribbon
C
Review Ribbon
D
Home Ribbon
10) Which ribbon contains commands to add a comment about a selected cell in a worksheet?
A
Data
B
Home
C
Insert
D
Review
11) What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook?
A
Protect Sheet
B
Share
C
Protect Workbook
D
Protection
12) All of the FBLA officers have access to the spreadsheet of member contact information. Which feature of Excel allows others to view who made changes to the spreadsheet, when the changes were made, and what was changed?
A
Track Changes
B
Names Manager
C
History
D
Change History
13) Lilly is creating a spreadsheet for FBLA and would like all of the advisors at her school to be able to make changes to the spreadsheet at the same time. What command allows her to do this?
A
Export
B
Share Workbook
C
Protect Workbook
D
Tracking Changes
14) Lilly is creating a spreadsheet for FBLA and would like to see the changes advisors have made to the workbook. What command allows her to do this?
A
Tracking Changes
B
Protect Workbook
C
Export
D
Share Workbook
15) Lilly is making changes to a spreadsheet created by her FBLA advisor. She wants to add a note informing her advisor of an incorrect address for a member. What option in the comments group should be used?
A
Show Link
B
Edit Comment
C
New
D
Delete
16) Lilly is making changes to a spreadsheet her FBLA Advisor created. She would like to make a change to the comment she made in the spreadsheet. What option in the comments group should she choose?
A
New
B
Edit Comment
C
Show Link
D
Delete
17) Which file name would be used for an Excel 2019 template?
A
budget.xlt
B
budget.xltx
C
budget.xlsx
D
budget.xlsm
18) Which symbol is required for Excel to recognize one of the four constants that refer to the same general area of a table?
A
#
B
\
C
=
19) Which Excel command allows a user to display hidden ribbon tabs?
A
General
B
Change the Ribbon
C
Quick Access Toolbar
D
Customize the Ribbon
20) Which process allows the user to create a custom template?
A
click Save As and set the file type to .xlsx
B
click Save and set the file type to .xlz
C
click Save As and set the file type to .xls
D
click Save As and set the file type to .xltx
*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?