MS Excel Honors #4 Question Preview (ID: 54113)


Review. TEACHERS: click here for quick copy question ID numbers.

Which Excel command allows Susan to automatically save her workbook every 15 minutes?
a) Save
b) AutoRecover
c) Save As
d) Backup

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) Calculate Now
c) Calculate Options
d) Evaluate Formula

Changes become part of the change history only when the user:
a) exits Excel
b) saves the workbook
c) turns off track changes
d) shares the workbook

Where is the command to apply a fill color to a cell or range of cells in a worksheet?
a) Home Ribbon
b) Insert Ribbon
c) Page Layout Ribbon
d) View Ribbon

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) Paragraph
d) Format Cells

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) Special Formattig
c) Subscript Formatting
d) Merge

Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
a) Center
b) Merge and Center
c) Orientation
d) Wrap Text

Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select?
a) Center
b) Merge and Center
c) Orientation
d) Wrap Text

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) Date
c) Number
d) Text

Column D in a spreadsheet contains employee ID Numbers. Which formatting would be most appropriate for the data in column D?
a) Currency
b) Date
c) Number
d) Text

Trey would like to outline the cell range A1:F20. Which formatting style should he select?
a) Borders
b) Cell Style
c) Conditional Formatting
d) Format as Table

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) Borders
b) Cell Style
c) Conditional Formatting
d) Format as Table

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) Conditional Formatting
c) Fill Color
d) Format as Table

Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?
a) Alignment
b) Font
c) Size
d) Effects

What defines the color of the characters in a Microsoft Excel worksheet?
a) Font size
b) Font color
c) Cell color
d) Background

On the Home Ribbon, what is used to change the font size of characters in a cell?
a) Font drop-down list
b) Font Size drop-down list
c) Font Style drop-down list
d) Cell Styles drop-down list

On the Home Ribbon, what can be used to change the text color of characters in a cell?
a) Font Color drop-down list
b) Font Size drop-down list
c) Fill Color drop-down list
d) Cell Styles drop-down list

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

Which quick-number style button formats numbers to display as currency in the worksheet?
a) Percent
b) Accounting
c) Comma
d) Dollar

Which command on the Home Ribbon can be used to rotate text to a vertical or diagonal angle in a worksheet?
a) Font
b) Orientation
c) Wrap Text
d) Merge and Center

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 54113 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links