Excel - Chapters 14-16
Which symbol represents that a cell is an absolute cell reference in a function or formula?
$
________ performs calculations by using specific values that you insert in a particular order or structure.
A function
The type of cell reference that refers to cells by their fixed position in a worksheet is:
absolute
A municipal government fund that reports income and expenditures related to municipal services for which a fee is charged in exchange for goods or services is:
an enterprise fund
A shaded bar that provides a visual cue about the value of a cell relative to other cells is a:
data bar
A pie slice is an example of:
data marker
A(n) ________ is prewritten in Excel to look at one or more values, perform an operation, and then return a value.
function
The default format that Excel applies to numbers is the:
general format
A chart type that displays trends over time is a:
line chart
In Excel, row headings are identified by ________.
numbers
The symbols with which you can specify the type of calculation you want to perform in an Excel formula are:
operators
A value that originates in a worksheet cell and that is represented in a chart by a data marker is a data:
point
Related data points represented by data markers are referred to as the data:
series
Tiny charts embedded in a cell that give a visual trend summary alongside your data are:
sparklines
The data that displays in the Formula Bar is referred to as the:
underlying value