Q5 Case Cracking Formulas: Vocabulary

KEY VOCABULARY

Autosum: Autosum is a spreadsheet tool that quickly adds a group of numbers for you with one click.

AVERAGE:AVERAGE is a function that finds the mean of a group of numbers.

Equal Sign (=): An equal sign is the symbol that tells the spreadsheet you are creating a formula.

Formula: A formula is a math rule you type into a cell that starts with an equals sign (=).

Function: A function is a built-in formula that does a calculation for you, like SUM or AVERAGE.

MAX: MAX is a function that finds the largest number in a set.

MIN:  MIN is a function that finds the smallest number in a set.

Operators: Operators are symbols used in formulas, like + (add), – (subtract), * (multiply), and / (divide).

Range: A range is a group of selected cells, such as A1:A5.

Sigma (Σ): Sigma is a Greek symbol that means “add everything up.”

SUM: SUM is a function that adds up a group of numbers.