Review Game Zone
Games
Test
Preview
Back
Match it!
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
functions
grouping
nesting
total row
expression
page break preview
filter
conditional formatting
to display only certain records.
functions
grouping
nesting
total row
expression
page break preview
filter
conditional formatting
a row you can display below a table to calculate data in the columns above using a function you choose
functions
grouping
nesting
total row
expression
page break preview
filter
conditional formatting
if(sum b4:b8 is greater than 50) this is an example of
functions
grouping
nesting
total row
expression
page break preview
filter
conditional formatting
a view that allows you to move and delete page breaks and redefine the print area.
functions
grouping
nesting
total row
expression
page break preview
filter
conditional formatting
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
functions
grouping
nesting
total row
expression
page break preview
filter
conditional formatting
Worksheet that are selected as a unit; any action performed on this unit will affect all the worksheets in the group.
functions
grouping
nesting
total row
expression
page break preview
filter
conditional formatting
variable formatting that changes the formatting applied based on the contents of the cells in the formatting range.
functions
grouping
nesting
total row
expression
page break preview
filter
conditional formatting
Check it!