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