Excel Expert 2016 lessons 3-4 vocab

Match it! Select the correct answer from the pull down...Good luck!

A term that describes when two tables have a connection between two fields.

A graphical representation of numeric data in a worksheet.

A tool that filters the entire PivotTable, restricting the sums, counts, averages, and so on, to only those fields selected in the slicer or filter field.

A graphical representation of the data in a PivotTable.

A formula in which the result is determined by the presence or absence of a particular condition.

A line bordering the chart plot area used as a frame of reference for measurement.

Data in a table arranged in rows and columns. A table of text, numbers, or values that you use for the formula.

An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook.