2016 EXCEL Lesson 6 Vocats

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

• Center

• Merge and Center

• Orientation

• Wrap Text

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

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

• Alignment

• Column Width

• Decrease Indent

• Orientation

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

• Cell Styles drop-down list

• Font drop-down list

• Font Size drop-down list

• Font Style drop-down list

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

• Home Ribbon

• Insert Ribbon

• Page Layout Ribbon

• View Ribbon

Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select?

• Cell Style

• Conditional Formatting

• Fill Color

• Format as Table

Which dialog box in Microsoft Excel is used to set the rotation of text in a cell to a specific degree?

• Alignment

• Format Cells

• Format Text

• Orientation

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

• Borders & Shading

• Drawing

• Highlight

• Fill Color

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

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?

• Special Formatting

• Subscript Formatting

• Merge

• AutoFit