Worksheet that are selected as a unit; any action performed on this unit will affect all the worksheets in the group.

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

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 row you can display below a table to calculate data in the columns above using a function you choose

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 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

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

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

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

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 view that allows you to move and delete page breaks and redefine the print area.

Teachers: Create FREE classroom games with your questions Click for more info!
©2007-2024 Review Game Zone | About | Privacy | Contact | Terms | Site Map