Chapter 2 CIS
absolute
$A$10 is a ___ cell reference.
mixed
$A10 is a ___ cell reference.
Absolute
A cell reference that refers to a cell by its fixed position in a worksheet is referred to as being ___.
Pie Chart
A chart that shows the relationship of each part to a whole.
Line Chart
A chart type that displays trends over time is a ___.
Data marker
A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point.
Axis
A line that serves as a frame of reference for measurement and that borders the chart plot area.
Value axis
A numerical scale on the left side of a chart that shows the range of numbers for the data points; also referred to as the y-axis.
Bevel
A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.
Goal seek
A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell.
Chart sheet
A workbook sheet that contains only a chart.
mixed
A$10 is a ___ cell reference.
relative
A10 is a ___ cell reference.
Relative cell reference
In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to.
100
In the formula, =IF(G11>=5,G5*G8,100), the 'false' result of the formula is ___.
G5*G8
In the formula, =IF(G11>=5,G5*G8,100), the 'true' result of the formula is ___.
Series
Related data points represented by data markers are referred to as the data ___.
formula
The cell content that performs computations is ___.
Chart area
The entire chart and all of its elements.
value after increase= base * percent for new value
The formula for calculating the value after an increase by multiplying the original value—the base—by the percent for new value.
=FunctionName(cell:cell)
The general syntax (or structure) of a formula that uses the SUM, AVERAGE, MIN or MAX function is ___.
Rate=amount of increase/base
The mathematical formula to calculate a rate of increase.
order of operation
The mathematical rules for performing multiple calculations within a formula.
What-if-analysis
The process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet.
=SUM(A1:A5)
An example of the correct syntax (or structure) of a formula that uses the SUM function is ___.
=$A$1
Suppose the following formula was located in cell C2: =$A$1. The formula would change to ___ if you Auto Fill/Copy & Paste the formula to cell D3. Hint: First consider the direction(s) you are being asked to Auto Fill (vertically or horizontally) and then the distance (columns and/or rows). Then determine what the formula will change to after Auto Fill.
=$A2
Suppose the following formula was located in cell C2: =$A1. The formula would change to ___ if you Auto Fill/Copy & Paste the formula to cell D3. Hint: First consider the direction(s) you are being asked to Auto Fill (vertically or horizontally) and then the distance (columns and/or rows). Then determine what the formula will change to after Auto Fill.
=B$1
Suppose the following formula was located in cell C2: =A$1. The formula would change to ___ if you Auto Fill/Copy & Paste the formula to cell D3. Hint: First consider the direction(s) you are being asked to Auto Fill (vertically or horizontally) and then the distance (columns and/or rows). Then determine what the formula will change to after Auto Fill.
=B2
Suppose the following formula was located in cell C2: =A1. The formula would change to ___ if you Auto Fill/Copy & Paste the formula to cell D3. Hint: First consider the direction(s) you are being asked to Auto Fill (vertically or horizontally) and then the distance (columns and/or rows). Then determine what the formula will change to after Auto Fill.
Formula Autocomplete
The Excel feature which, after typing = and the first letter of a function, displays a list of function names.
Category axis
The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis.