Excel Lesson 6 Pt. 2

Trey would like to outline the cell range A1:F20. Which formatting style should he select?

• Borders
• Cell Style
• Conditional Formatting
• Format as Table

Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem?

• AutoFit
• Special Formatting
• Subscript Formatting
• Wrap Text

Which command is used to format a cell or selected cells quickly by choosing from a defined list of styles?

• Format as Table
• Cell Style
• Conditional Formatting
• Form

Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?

• Wrap Text
• Group Cells
• Cell Styles
• Merge & Center

Column D in a spreadsheet contains employee ID Numbers. Which formatting would be most appropriate for the data in column D?

• Currency
• Date
• Number
• Text

What type of formatting appears only when the value in a cell meets conditions specified by a user?

• Criterion
• Conditional
• Logical
• Restrictive

Which command on the Home Ribbon can be used to rotate text to a vertical or diagonal angle in a worksheet?

• Font
• Orientation
• Wrap Text
• Merge & Center

Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?

• Center
• Merge and Center
• Orientation
• Wrap Text

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?

• Borders
• Cell Style
• Conditional Formatting
• Format as Table

Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select?

• Center
• Merge and Center
• Orientation
• Wrap Text