Lesson 2

AVERAGE function

An Excel function that calculates the average value of a collection of numbers.

Best fit

An Excel feature that automatically increases or decreases the width of a column so that the widest entry will fit.

character

A letter, number, symbol, or punctuation mark.

conditional formatting

Special formatting that is applied if cell values meet specified criteria.

debugging

The process of finding and correcting errors in a worksheet.

formatting

The enhancement of how content appears on the screen by changes to its font, size, color, or alignment.

footer

Information that appears at the bottom of each page.

Flash Fill

An Excel feature that looks for patterns in the data and automatically fills or formats data in remaining cells based on those patterns.

header

Information that appears at the top of each page.

MAX function

A function that displays the highest value in a range.

MIN function

A function used to determine the lowest number in a range.

margin

The space between the page content and the edges of the page.

order of operations

The sequence in which operators are applied in a calculation.

Point mode

An Excel mode that lets you select cells to use in a formula by using the pointer.

Page Layout view

The Excel view that shows how the sheet will look when printed.

pixel

Short for picture element, an individual point of color on a display screen or printout.

range

A series of two or more adjacent cells in a column, row, or rectangular group of cells. Example: B5:C10.

Range Finder

Checks which cells are referenced in the formula assigned to the active cell.

relative reference

A cell reference that automatically changes to reflect the new location when the formula is copied or moved.

theme

A predefined, coordinated set of colors, fonts, graphical effects, and other formats that can be applied to give the worksheet a consistent appearance.