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
Save
B
Save As
C
AutoRecover
D
Backup
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
Calculate Now
B
Calculate Options
C
Evaluate Formula
D
Autosum
3) Changes become part of the change history only when the user:
A
shares the workbook
B
exits Excel
C
turns off track changes
D
saves the workbook
4) Where is the command to apply a fill color to a cell or range of cells in a worksheet?
A
Insert Ribbon
B
Home Ribbon
C
Page Layout Ribbon
D
View 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
Number
B
Font
C
Format Cells
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
Merge
B
AutoFit
C
Subscript Formatting
D
Special Formattig
7) Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
A
Center
B
Wrap Text
C
Orientation
D
Merge and Center
8) Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select?
A
Orientation
B
Center
C
Merge and Center
D
Wrap Text
9) Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?
A
Currency
B
Text
C
Date
D
Number
10) Column D in a spreadsheet contains employee ID Numbers. Which formatting would be most appropriate for the data in column D?
A
Number
B
Currency
C
Date
D
Text
11) Trey would like to outline the cell range A1:F20. Which formatting style should he select?
A
Format as Table
B
Borders
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
Conditional Formatting
B
Format as Table
C
Cell Style
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
Format as Table
B
Fill Color
C
Conditional Formatting
D
Cell Style
14) Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?
A
Font
B
Alignment
C
Effects
D
Size
15) What defines the color of the characters in a Microsoft Excel worksheet?
A
Background
B
Font size
C
Cell color
D
Font color
16) On the Home Ribbon, what is used to change the font size of characters in a cell?
A
Cell Styles drop-down list
B
Font Style drop-down list
C
Font Size drop-down list
D
Font drop-down list
17) On the Home Ribbon, what can be used to change the text color of characters in a cell?
A
Cell Styles drop-down list
B
Font Size drop-down list
C
Font Color drop-down list
D
Fill 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
Wrap text
B
Group cells
C
Cell Styles
D
Merge and Center
19) Which quick-number style button formats numbers to display as currency in the worksheet?
A
Comma
B
Accounting
C
Dollar
D
Percent
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
Orientation
C
Font
D
Merge and Center
*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?