Excel Module 6-Creating, Sorting, and Querying a Table

In Excel, an organized collection of rows and columns of similarly structured data on a worksheet.

• workbook

• table

• worksheet

A collection of data organized in a manner that allows access, retrieval, and use of that data.

• datbase

• spreadsheet

• linked worksheet

In Access and Excel, a row of data in a table, representing a complete set of field values for a specific person, place, object, event, or idea; also called a tuple.

• record

• cell

• row

In an Access or in an Excel table or PivotTable, a column containing a specific property for each record, such as a person, place, object, event, or idea.

• fields

• cell

• row

Rows in a table that are formatted in alternating colors.

• banded row

• banded column

• banded table

In Excel, a table of information in which data is looked up.

• column array

• table array

• row aray

In Excel, a table that stores the data you want to retrieve with a lookup function; also called a table array.

• lookup table

• lookup array

• lookup worksheet

Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array; used when comparison values are located in a row across the top of a table of data.

• HLOOKUP function

• LOOKUP function

• HLOOK function

A function that returns values from a vertical lookup table.

• VLOOKUP function

• LOOKUP function

• VLOOK function

The value that is being looked up in a lookup table.

• lookup tabe

• lookup value

• lookup row