Term

Definition

3-D reference

A reference that refers to the same cell or range of cells on multiple worksheets in the same workbook

Compare Values

Categories for the lookup table

Default template

The blank workbook called Book1 that opens when you start Excel

Destination file

One of the workbooks in linked files

External reference

A reference to a cell on a sheet in another workbook

HLOOKUP

A function that performs a horizontal lookup for table in which the compare values are placed in the table’s first row

Link

A connection between two files allowing information to be transferred from one file to the other

Lookup functions

Functions that will lookup values in a table

Lookup Table

A table that organizes values that you want to retrieve into different categories

Lookup Value

A table that will be used to match against the compare values

Source file

One of the workbooks in linked files

Template

A workbook that you can open with the labels, formats, and formulas already built into it

VLOOKUP

A function that performs a vertical lookup for tables in which the compare values are placed in the table’s first column

Worksheet Group

A collection of two or more selected worksheets

Workspace

An Excel file that saves information about all the currently opened workbooks, such as their locations, their window sizes, and their screen positions