Excel 2016 - Lesson 6

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

• Font

• Orientation

Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?

• Format Cells

• Number

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

• Borders

• Cell Style

Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?

• Hyperlink

• Web link

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

• Merge and Center

• Wrap Text

Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?

• Currency

• Number

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

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

• Home Ribbon

• Insert Ribbon

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

• Orientation

• Format Cells

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

• Font drop-down list

• Font Size drop-down list