Excel Mod 5

To combine data on multiple worksheets and display the result on another worksheet.

• consolidate

• delimiter

• link

• returns

The exclamation point (!) used in a formula to indicate that a referenced cell is outside the active sheet.

• sated condtions

• logical formula

• external reference indicator

• logical test

In a named cell or range, the worksheet(s) in which the name can be used.

• 3-D refernce

• link

• range

• scope

An Excel feature that automatically fills in column or row data based on calculations you enter.

• consolidate

• delimiter

• link

• Flash Fill

The dynamic referencing of data in the same or in other workbooks, so that when data in the other location is changed, the references in the current location are automatically updated.

• scope

• link

• merge

• 3-D reference

A separator such as a space, comma, or semicolon between elements in imported data.

• scope

• space

• delimiter

• range

In a function, to display a result.

• stated condition

• logical test

• 3-D reference

• returns

The first part of an IF function; if true, then the second part of the function is applied; if false, then the third part of the function is applied.

• if function

• stated condtions

• logical test

• retruns

In a logical formula, criteria you create.

• stated conditions

• reference

• absolute reference

• logical test

A formula with calculations that are based on stated conditions.

• logical formula

• external reference

• conditional formula

• 3-D formula