wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Lesson 4 Worksheet Formatting

Total questions: 10

Worksheet time: 4mins

Name
Class
Date
1.

You manually format data by selecting cells and then clicking options on the ______ tab.

a)

Home

b)

View

c)

Review

d)

Design

2.

A style that vertically aligns dollar signs ($), thousands separators (,) and decimal point (.).

a)

Comma format

b)

Accounting format

c)

Currency format

3.

A color that fills a cell, appearing behind the data.

(a)  

4.

The typeface or design of the text.

a)

Font

b)

Font size

c)

Theme

5.

A format that controls how numerical data is displayed, including the use of commas, dollar signs, and the number of decimal places.

a)

Percent format

b)

line preview

c)

Number format

d)

Currency format

6.

to center a label across several columns, use the _____button.

a)

Merge

b)

Center

c)

Merge & Center

7.

When you change font size, Excel, automatically adjusts the row height but does not adjust the column width.

a)

True

b)

False

8.

A collection of coordinated fonts, colors, and effects for graphic elements, such as charts and images that can be quickly applied to all sheets in a workbook.

(a)  

9.

The currency format is similar to Accounting format, except that the dollar sign is placed just to the left of the data, rather than left-aligned in the cell.

a)

True

b)

False

10.

The measurement of the typeface in points.

a)

1 point

b)

2 points

c)

3 points