Excel MOAC Lesson 06: Formatting Cells & Ranges (Part 1)

On the Home Ribbon, what can be used to change the text color of characters in a cell?

• Font Color drop-down list

• Font Size drop-down list

• Fill Color drop-down list

• Cell Styles drop-down list

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

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

• Cell Style

• Conditional Formatting

• Borders

• Format as Table

What command is used to apply a background color to cells in a worksheet?

• Drawing

• Fill Color

• Border & Shading

• Highlight

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

Where is the command to apply a fill color to a cell or range of cell in a worksheet?

• Home Ribbon

• Insert Ribbon

• Page Layout Ribbon

• 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?

• Number

• Font

• Paragraph

• Format Cells

Which command is used to to reduce the margin between the border and the text in an indented cell?

• Orientation

• Decrease Indent

• Column Width

• Alignment

On the Home Ribbon, what is used to change the font size of the characters in a cell?

• Font drop-down list

• Font Size drop-down list

• Font Style drop-down list

• Cell Styles drop-down list

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

• Criterion

• Condtional

• Logical

• Restrictive