Excel 2010 Formulas And Functions

Front 1

IF function

Back 1

used to test for more than one value.

Front 2

CountIF function

Back 2

used to count items, for example, to count how many students have an A grade.

Front 3

Conditional formatting

Back 3

used to change the appearance of a cell, depending on certain conditions, for example, color coding student averages.

Front 4

SumIF function

Back 4

is like CountIF in range of cells to search and criteria to look for, but adds one more argument called Sum_range to search a new range of cells.

Front 5

data table in Excel

Back 5

a table used to see different results by altering an input cell in your formula.

Front 6

absolute cell reference

Back 6

has a dollar sign in front of the column letter and the row number, so that when you copy a formula that contains an absolute cell reference, the reference does not change.

Front 7

relative cell reference

Back 7

is expressed as just the column letter and row number, so that when you copy a formula that contains a relative cell reference, the row number and column letter is adjusted to reflect the location to which you copied the formula.

Front 8

a named range

Back 8

a way to describe your formulas by replacing the cell references between the round brackets with a descriptive name.

Front 9

a custom name

Back 9

a name used as a constant, so that you do not have to type out long formulas.

Front 10

pivot table

Back 10

a table used to present information in report format.

Front 11

LOOKUP function

Back 11

used to search one column of data and find data in the corresponding row.

Front 12

VLOOKUP function

Back 12

used to search the first column of your spreadsheet for a value.