Lesson 4 Worksheet Formatting

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

• Home

• View

• Review

• Design

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

• Comma format

• Accounting format

• Currency format

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

The typeface or design of the text.

• Font

• Font size

• Theme

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

• Percent format

• line preview

• Number format

• Currency format

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

• Merge

• Center

• Merge & Center

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

• True

• False

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.

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.

• True

• False

The measurement of the typeface in points.

• 1 point

• 2 points

• 3 points