WGU D388 - FUNDAMENTALS OF
SPREADSHEETS AND DATA
PRESENTATIONS
1 of 89
Definition
A row added to a table that automatically displays the sum of values
in a column. Users can format the row to display other functions.
Give this one a try later!
Pane Total row
Header row Time
, Don't know?
2 of 89
Definition
The part of a calculation to which an algorithm is applied example:
revenue
Give this one a try later!
Measure Time
Function Pattern
Don't know?
3 of 89
Definition
A formula that produces a consistent value
Give this one a try later!
Outlier Apipa
, Static Dynamic
Don't know?
4 of 89
Definition
When a category of data in a chart is compared to itself. Example, if
a chart contains blue and orange, vertical columns, the blue
columns can be compared to learn more about the trend of the date
of represented by the blue columns.
Give this one a try later!
Calculated column File
Table filters Intra-category comparison
Don't know?
, 5 of 89
Definition
When one part of the cell reference, either the column or the row, is
fixed (Absolute) and the other part is relative (changes based on
proximity to other cells)
Give this one a try later!
Mixed reference Absolute reference
Relative reference Function
Don't know?
6 of 89
Definition
A consecutive block of cells, arranged in a row, a column, or a
combination of both. For example, A1:B3 is the range of cells that
includes A1, A2, A3, B1, B2, and B3.
Give this one a try later!
Table Range
Row Column
SPREADSHEETS AND DATA
PRESENTATIONS
1 of 89
Definition
A row added to a table that automatically displays the sum of values
in a column. Users can format the row to display other functions.
Give this one a try later!
Pane Total row
Header row Time
, Don't know?
2 of 89
Definition
The part of a calculation to which an algorithm is applied example:
revenue
Give this one a try later!
Measure Time
Function Pattern
Don't know?
3 of 89
Definition
A formula that produces a consistent value
Give this one a try later!
Outlier Apipa
, Static Dynamic
Don't know?
4 of 89
Definition
When a category of data in a chart is compared to itself. Example, if
a chart contains blue and orange, vertical columns, the blue
columns can be compared to learn more about the trend of the date
of represented by the blue columns.
Give this one a try later!
Calculated column File
Table filters Intra-category comparison
Don't know?
, 5 of 89
Definition
When one part of the cell reference, either the column or the row, is
fixed (Absolute) and the other part is relative (changes based on
proximity to other cells)
Give this one a try later!
Mixed reference Absolute reference
Relative reference Function
Don't know?
6 of 89
Definition
A consecutive block of cells, arranged in a row, a column, or a
combination of both. For example, A1:B3 is the range of cells that
includes A1, A2, A3, B1, B2, and B3.
Give this one a try later!
Table Range
Row Column
