Excel $-$ Chapter $2-$ Working with Formulas and Functions

Matching

Drag the letter from the list on the right to its matching term in the list on the left. When you are finished, click Done.

Formula

AVERAGE

Range name

COUNT

ROUND

Links worksheets

F$2$

AutoSum

Trace Precedents

Evaluate Formula

A Enables the current cell's Edit mode.

$[$B$]$ Button that shows all cells referenced in the active cell's formula

C A built$-$in function that calculates the arithmetic mean of a range of cells

$[$D$]$ This button opens a list of commonly used statistical functions

$[$E$]$ A label assigned to a single cell or group of cells.

F Uses common arithmetic operations to perform calculations

G Tallies the number of cells in a range

$[$H$]3$D cell reference

Button that starts a review of each part of a formula to determine errors

An Excel function that controls $-$how many decimal places display for a value