Chapter 3
Use the ________ key to select A5:A8 and D5:D8.
Ctrl
Which symbol represents that a cell is an absolute cell reference in a function or formula?
$
Which of the following is the second order of operations?
Exponentiation
Which of the following is the first order of operations?
Expressions within parentheses
________ is an Excel tool that finds the input needed to arrive at a desired result.
Goal Seek
Which of the following is NOT one of the three spatial dimensions of 3-D?
Height
How can you identify the Chart Elements button when you select a chart?
It is a green plus sign.
When you print a chart sheet, how is it automatically formatted?
It is centered on the page.
Which of the following is TRUE about a pie chart?
It shows the relationship of each part to a whole.
Where is the Format Painter button located?
On the mini toolbar and the Home tab
To size a chart proportionately, hold down the ________ key and ________.
Shift; drag a corner sizing handle
In Goal Seek, you enter the specific value that you want to achieve in the ________ box.
To value
To what extent can a pie chart be rotated?
Up to 360 degrees
A(n) ________ refers to a cell by its fixed position in the worksheet.
absolute cell reference
A chart and all of its elements is known as the ________.
chart area
A ________ in a pie chart identifies the pie slices.
data label
In Goal Seek, the ________ box contains the formula that calculates the information you seek.
set cell
If you edit data in a worksheet that is associated with a pie chart ________.
the pie slices will be automatically updated
You must select ________ on a worksheet to create a pie chart.
two ranges
The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as ________.
what-if analysis
AutoFill will fill a series when you establish a pattern ________.
with two or more cells
________ is a group of related data points represented by data markers.
A data series
Which of the following displays trends over time?
A line chart
In a line chart, which of the following resides along the bottom of the chart?
The x-axis
Which of the following resides along the left side of a column chart?
The y-axis
