Excel Module 2 - Formatting a Worksheet

Predefined set of colors, fonts, line and fill effects, etc., that can be applied to give a consistent, professional look to your sheet or chart.

• style

• theme

• WordArt

• SmartArt

The placement of cell contents in relation to a cell's edges; left, centered, right, angled.

• tabbed

• indented

• margin

• alignment

Identify the sheets in a workbook and let you switch between sheets; located below the worksheet grid.

• filename

• sheet tab

• spreadsheet

• worksheet

Feature that automatically adjusts the width of a column or the height of a row to accommodate the widest or tallest entry.

• autofit

• auto resize

• column or line adjuster

• width adjustment

Unit of measurement for font size and row height. One point is equal to 1/72nd of an inch.

• inch

• pixel

• margin

• point

The box containing the column letter on top of the columns in the worksheet.

• cell

• row heading

• column heading

• header

Format applied to values to express numeric concepts, such as currency, date, and percentage.

• format options

• number format

• cell style

• dollar sign

Type of cell formatting that changes based on the cell's value or the outcome of a formula.

• cell style

• range

• currency format

• conditional formatting

Appearance of a cell and its contents; including font, font styles, font color, fill color, borders, and shading.

• format

• conditional formatting

• style

• theme

Format such as bold, italic, and underlining that can be applied to change the way characters look in a worksheet or chart.

• theme

• style

• font style

• font format