Chapter 6_V2

Vocab 1.2

100

individual data items that make up a record 

Fields

200

any items deselected from the filter menu

Filter criterion

300

used more often because most tables are vertical 

VLookup Function

400

left column values in a table array. Must be in sequence from lowest to highest

Table arguments:

Vocab 2.2

100

allows you to choose to display data that meets specified criteria such as color, number or text

Filter commands

200

data related to each person or item

Record

300

uses some combination of the table name, the column and any named or special rows rather than the usual column letter and row number references

Structured Reference

400

AKA Database – an organized collection of data

Table

Vocab 3.2

100

include plus and minus signs for showing and hiding portions of the spreadsheet, as well as brackets identifying the groups

Outline Symbols

200

the answer you want to appear as a result of the VLOOKUP function

Return value

300

the sum of a subset of data 

Subtotal

400

sums the values in the last column of the table if the values are numeric. If the values are textual, then Excel counts the number of records and puts that number in it’s place.

Total Row