Excel Module 3 Vocab Review

Front

Shows trends and variations in data within a single cell.

Back

Sparkline Chart

Front

Slices of a Pie Chart

Back

Category Names

Front

Assign a value to a cell based on a logical test

Back

If Function

Front

Shows the relationship of parts to a whole

Back

Pie Chart

Front

Both Column and Row References stay the same when copied; $$ on both.

Back

Absolute Cell Reference

Front

A chart on a separate sheet

Back

Chart Sheet

Front

When copied, cell references adjust to the new location without $ on column or row.

Back

Relative Cell Reference

Front

Data that determines the size of slices in a pie chart

Back

Data Series

Front

Function to display current system date and time

Back

Now Function

Front

A pie chart with one or more slices offset.

Back

Exploded Pie Chart