BCA- Test 3A

To select two different ranges, you use the ____ key.

Ctrl

A data point is represented in a chart by a ______.

Data marker

A value that originates in a worksheet cell.

Data point

Related data points represented by data markers.

Data series

A ______ in a pie chart identifies the pie slices.

Data table

What is the symbol used to make sure the cell reference is a absolute?

$

Reports, income and expenditures related to municipal services for which a fee is charged in exchange for goods or services.

Enterprise fund

If you pull out--________--one or more slices of a pie chart to emphasize a specific slice or slices.

Explode

Feature that applies one format from one cell to another.

Format painter

An Excel feature that, after typing an = and the beginning letter or letters of a function name, displays a list of function names that match the typed letters.

Formula autocomplete

An element in the Excel window that displays the value or formula contained in the active cell; here, you can also enter or edit values or formulas.

Formula bar

A _____ is a sum of money set aside for a specific purpose.

Fund

Money set aside for the normal operating activities of the city, such as police, fire, and administrating the everyday functions of the city.

General fund

One what-if-analysis tool in Excel is ______, which finds the input needed in one cell to arrive at the desired result in another cell.

Goal seek

On a separate new sheet in your workbook, what identifies the pie slices?

Legend

A chart type that displays trends over time; time displays along the bottom axis and the data point values are connected with a line.

Line chart

The mathematical rules for performing multiple.

Order of operations

the percent by which one number increases over another number.

Percentage rate of increase

A ______ shows the relationship of each part to a whole.

Pie chart

The reference to cell C5 is a _______ because when you copy the formula, you want the reference to change relative to its row.

Relative cell reference

When you copy a formula to a different location and the cell formula changes what type of cell reference is that?

Relative cell reference

The process of changing the values in cells to see how those changes affect the outcome of formulas in you worksheet is referred to as _______.

What if analysis

The entire chart and all its elements comprise the _______.

Chart area

A workbook sheet that contains only a chart.

Chart sheet

The ____ of each pie slice is equal to its value compared to the total value of all the slices.

size

Matching:

-Absolute cell reference- Refers to a cell by its fixed position in a worksheet-the cell reference will not change when you copy a formula. -Relative cell reference- When you copy a formula to a different location and the cell formula changes what type of cell reference is that? -Data point- A value that originates in a worksheet cell. -Data marker- A data point is represented in a chart by this. -Data series-Related data points represented by data markers.

Matching:

-Bevel- A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled. -Explode- If you pull out--________--one or more slices of a pie chart to emphasize a specific slice or slices. -3D- Length, Width and Depth -Order or operation- The mathematical rules for performing multiple. -Line chart- A chart type that displays trends over time; time displays along the bottom axis and the data point values are connected with a line.

Matching:

-Data series- Related data points represented by data markers. -Chart sheet- A workbook sheet that contains only a chart. -Chart area- The entire chart and all its elements. -Pie chart- Shows the relationship of each part to a whole. -Legend- On a separate new sheet in your workbook, this identifies the pie slices.

Matching:

-Fund- a sum of money set aside for a specific purpose. -Data series- Related data points represented by data markers -Axis- A line that serves as a frame of reference for measurement and that borders the plot area. -Enterprise fund- Reports, income and expenditures related to municipal services for which a fee is charged in exchange for goods or services. -General fund-Money set aside for the normal operating activities of the city, such as police, fire, and administrating the everyday functions of the city.

Matching:

-Goal seek- One what-if-analysis tool in Excel is ______, which finds the input needed in one cell to arrive at the desired result in another cell. -What if analysis- The process of changing the values in cells to see how those changes affect the outcome of formulas in you worksheet is referred to as _______. -Format painter- Feature that applies one format from one cell to another. -Formula bar- An element in the Excel window that displays the value or formula contained in the active cell; here, you can also enter or edit values or formulas. -Formula auto complete- An Excel feature that, after typing an = and the beginning letter or letters of a function name, displays a list of function names that match the typed letters.

How many ranges do you have to elect to make a pie chart?

2

Length, Width and Depth

3D

Refers to a cell by its fixed position in a worksheet-the cell reference will not change when you copy a formula.

Absolute cell reference

A line that serves as a frame of reference for measurement and that borders the plot area.

Axis

A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.

Bevel