BIM - Excel Chap 4 Less 35-39

A special column that can be added to a table, in which a single formula is automatically applied to each row in the column

• Criteria range

• Excel table

• Calculated column

• Extract

Area of the worksheet in which you specify the criteria for selecting records from the list or table

• Calculated column

• Criteria range

• Excel table

• Extract

Data arranged in columns and specially formatted with column headers that contain commands that allow you to sort, filter, and perform other functions of the table

• Calculated column

• Criteria range

• Excel table

• Extract

Copy records that match specified criteria to another place in the worksheet where they can be charged, sorted, formatted, printed, and so on

• Extract

• Excel table

• Calculated column

• Criteria range

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

• Filter

• List

• Slicer

• Total Row

An easy-to-use filtering component that contains a set of buttons to enable you to quickly filter data

• Filter

• List

• Total Row

• Slicer

A range of Excel data organized primarily in columns

• Slicer

• List

• Filter

• Total row

Hide non-matching rows in a table or list of data according to the criterion or criteria you specify

• Filter

• List

• Total row

• Slicer

Tiny charts that can be used to show trend patters

• Filter

• Trend

• Sparklines

• Step

Used to calculate a future value. Also the difference between two existing values

• Sparklines

• Step

• Trend

• Filter