Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
MS Excel Honors #4
Test Description: Review
Instructions: Answer all questions to get your test result.
1) Which Excel command allows Susan to automatically save her workbook every 15 minutes?
A
Backup
B
AutoRecover
C
Save
D
Save As
2) Katie wants to calculate the total dues collected from FBLA members. She notices the total is not being updated as she changes the data. Which option on the Formula tab would allow her to fix this problem?
A
Autosum
B
Evaluate Formula
C
Calculate Options
D
Calculate Now
3) Changes become part of the change history only when the user:
A
saves the workbook
B
shares the workbook
C
turns off track changes
D
exits Excel
4) Where is the command to apply a fill color to a cell or range of cells in a worksheet?
A
Insert Ribbon
B
View Ribbon
C
Page Layout Ribbon
D
Home Ribbon
5) Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?
A
Font
B
Format Cells
C
Number
D
Paragraph
6) Carl notices the last two lines of text in cell B4 are not showing up in his spreadsheet. How could Carl format the cell to correct this problem?
A
Subscript Formatting
B
Special Formattig
C
Merge
D
AutoFit
7) Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
A
Merge and Center
B
Wrap Text
C
Center
D
Orientation
8) Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select?
A
Merge and Center
B
Wrap Text
C
Center
D
Orientation
9) Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?
A
Text
B
Number
C
Date
D
Currency
10) Column D in a spreadsheet contains employee ID Numbers. Which formatting would be most appropriate for the data in column D?
A
Currency
B
Number
C
Text
D
Date
11) Trey would like to outline the cell range A1:F20. Which formatting style should he select?
A
Borders
B
Format as Table
C
Conditional Formatting
D
Cell Style
12) Trey would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select?
A
Cell Style
B
Conditional Formatting
C
Format as Table
D
Borders
13) Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select?
A
Cell Style
B
Format as Table
C
Conditional Formatting
D
Fill Color
14) Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?
A
Effects
B
Font
C
Alignment
D
Size
15) What defines the color of the characters in a Microsoft Excel worksheet?
A
Cell color
B
Font color
C
Background
D
Font size
16) On the Home Ribbon, what is used to change the font size of characters in a cell?
A
Font drop-down list
B
Cell Styles drop-down list
C
Font Size drop-down list
D
Font Style drop-down list
17) On the Home Ribbon, what can be used to change the text color of characters in a cell?
A
Fill Color drop-down list
B
Cell Styles drop-down list
C
Font Size drop-down list
D
Font Color drop-down list
18) Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?
A
Merge and Center
B
Group cells
C
Wrap text
D
Cell Styles
19) Which quick-number style button formats numbers to display as currency in the worksheet?
A
Accounting
B
Percent
C
Comma
D
Dollar
20) Which command on the Home Ribbon can be used to rotate text to a vertical or diagonal angle in a worksheet?
A
Wrap Text
B
Merge and Center
C
Font
D
Orientation
*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?