Excel Chapter 3

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