Drag the letter from the list on the right to its matching term in the list on the left. When you are finished, click Done.

Consolidate

Source worksheet

$3$D reference formula

Consolidation by Category

SmartArt

External reference formula

Selection handles

Hyperlink

Screen clipping

Dependent workbook

A In Excel, this refers to a consolidation based on row or column labels

B$]$ A workbook that contains data cells from another workbook

$($C$)$ High$-$quality illustrations which often include text

$($D$)$ Summarize data from multiple worksheets

$[$E$]$ A formula that links a dependent workbook to a source workbook

$[$F$]$ Click on this text string or object and your pointer will jump to another location

G$]$ Existing worksheet containing a range included in a consolidation worksheet

$[$H$]$ Points on the frame of a graphic used to resize it A formula containing a reference that identifies the sheet name and the cell location.

A feature of the Screenshot button that allows you to select a portion of a window