Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

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

Total questions: 11

Worksheet time: 6mins

Name
Class
Date
1.

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

2.

Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?

a)

Alignment

b)

Font

c)

Size

d)

Effects

3.

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

a)

Hyperlink

b)

Web link

c)

Linkup

d)

Text link

4.

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 Styles

b)

Conditional Formatting

c)

Fill Color

d)

Format as Table

5.

Which quick-number style button formats numbers to display as currency in the worksheet?

a)

Percent

b)

Comma

c)

Accounting

d)

Dollar

6.

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 & Center

7.

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

a)

Format as Table

b)

Form

c)

Conditional Formatting

d)

Cell Style

8.

What defines the color of the characters in a Microsoft Excel worksheet?

a)

Font size

b)

Font color

c)

Cell color

d)

Background

9.

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

10.

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

11.

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 Formatting

c)

Subscript Formatting

d)

Merge