Exercise 18, 19, 20 Vocab.

18)

Function- a preprogrammed Excel formula for a complex calculation

Criteria- a value some text, or an expression that defines the type of cells your looking for

Expression- A sort of equation that returns a value

Nesting- using a function as an argument within another function

Argument- A variable used in a function can be a number, Text , or a formula.

19)

Chart- A graphic that allows you to compare and contrast a data file

Embedded chart- A chart placed as an object

Chart Sheet- a chart that occupies its own wkst

plot- to position data points on a graph

Data series- info. in a wkst column

Legend- A key that identifies each of the data series in a chart

X- axis- a horizontal line in a graph

y-axes- vertical line in a graph

Categories- info. in a wkst row

20)

Plot area- defined by the x and y axes

Object- item that is treated separately from the main document

Chart Area- total area occupied by a chart

Tick Marks- lines of measurement along the value and category axes