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 As
B
Backup
C
AutoRecover
D
Save
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
Evaluate Formula
C
Autosum
D
Calculate Options
3) Changes become part of the change history only when the user:
A
saves the workbook
B
exits Excel
C
turns off track changes
D
shares the workbook
4) Where is the command to apply a fill color to a cell or range of cells in a worksheet?
A
Page Layout Ribbon
B
View Ribbon
C
Insert 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
Paragraph
B
Number
C
Font
D
Format Cells
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
AutoFit
B
Subscript Formatting
C
Special Formattig
D
Merge
7) Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
A
Orientation
B
Wrap Text
C
Center
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
Wrap Text
C
Center
D
Merge and Center
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
Date
C
Currency
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
Date
C
Text
D
Currency
11) Trey would like to outline the cell range A1:F20. Which formatting style should he select?
A
Borders
B
Conditional Formatting
C
Format as Table
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
Format as Table
B
Conditional Formatting
C
Borders
D
Cell Style
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
Fill Color
B
Conditional Formatting
C
Cell Style
D
Format as Table
14) Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?
A
Size
B
Alignment
C
Font
D
Effects
15) What defines the color of the characters in a Microsoft Excel worksheet?
A
Font size
B
Background
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
Font Style drop-down list
B
Font drop-down list
C
Cell Styles drop-down list
D
Font Size drop-down list
17) On the Home Ribbon, what can be used to change the text color of characters in a cell?
A
Font Size drop-down list
B
Fill Color drop-down list
C
Font Color drop-down list
D
Cell Styles 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
Group cells
B
Wrap text
C
Merge and Center
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
Merge and Center
B
Wrap Text
C
Orientation
D
Font
*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?