Excel ch 2 review

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

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

to display only certain records.

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

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

a view that allows you to move and delete page breaks and redefine the print area.

a row you can display below a table to calculate data in the columns above using a function you choose

a type of equation (such as B625) that returns a value, such as TRUE or FALSE. Excel uses expressions to identify cells to include in certain formulas as IF and SUMIF

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