NEW
Font size
WorksheetsExcel Chapter 3
Total questions: 10
Worksheet time: 5mins
Which symbol represents that a cell is an absolute cell reference in a function or formula?
%
&
$
*
Use a(n) ________ if you want the reference in a formula to change when you copy the formula
data marker
relative cell reference
legend
absolute cell reference
A ________ in a pie chart identifies the pie slices
data series
data label
data marker
data point
Which of the following is not one of the three spatial dimensions of a 3-D image?
Depth
Length
Width
Height
A chart and all of its elements is known as the ________.
chart sheet
chart area
plot area
axis
________ is an Excel tool that finds the input needed to arrive at a desired result.
Goal Seek
Formula AutoComplete
A gradient fill
A bevel
If cell B4 contains the formula =$F$5 and you copy and paste the contents of cell B4 into cell D8, what will the formula be in cell D8?
=$F$9
=$F$5
=$H$9
=$H$5
The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as ________.
enterprise fund analysis
what-if analysis
general fund analysis
a relative cell reference
Which of the following is the second order of operations in an Excel formula?
Multiplication
Addition
Expressions within parentheses
Exponentiation
AutoFill can fill a series when you establish a pattern ________.
with two or more cells
with a minimum of three cells
through the use of a formula
through the use of a function
