Excel ch 2 review

Match it! Select the correct answer from the pull down...Good luck!

a feature that speeds up the manual entry of functions. Be sure to double click instead of pressing enter!

to display only certain records.

The values and other inputs that a function uses to calculate the result. You specify the cell or range that holds the value(s) for each argument or input a particular value.

a built-in formula for performing calculations, such as addition, in a table. examples include sum, min, and max

to set a field so that it always remains on-screen, in the left-most position, as you scroll left to right

the name given to a set of adjacent cells. you might name a range in order to make it more convenient to reference that range in a formula or a function, such as VLOOKUP

variable formatting that changes the formatting applied based on the contents of the cells in the formatting range.

if(sum b4:b8 is greater than 50) this is an example of