BIM Excel Ch. 2 Vocabulary

a feature that performs calculations on a range of cells without the user writing a formula

• function

• function name

• AutoCalculate

• criterion

A predefined formula that performs a specific calculation

• function

• function name

• AutoCalculate

• criterion

the name given to one of Excel’s predefined formulas

• function

• function name

• AutoCalculate

• criterion

a value, some text, or an expression that defines the type of content you want to see

• function

• function name

• AutoCalculate

• criterion

Data arranged in columns and specially formatted with headers, that contain commands

• Excel table

• filter

• sort

• structured references

Hide nonmatching rows in a table or list of data according to the criterion

• Excel table

• filter

• sort

• structured references

Arrange the rows in a table or list of data in a new order

• Excel table

• filter

• sort

• structured references

Using the table name of a table column header in a formula to refer to data in the table/column

• Excel table

• filter

• sort

• structured references

combination of cell color, border, shading applied to a table

• table style

• total row

• range name

• expression

a row you can display below a table to calculate date in the columns above

• table style

• total row

• Range name

• expression