Quiz 8 - Excel Chapter 3
If you edit data in a worksheet that is associated with a pie chart ________.
the pie slices will be automatically updated
In a line chart, which of the following resides along the bottom of the chart?
x-axis
Only one piece of a pie can be exploded.
False
A(n) ________ refers to a cell by its fixed position in the worksheet.
absolute cell reference
A workbook sheet that contains only a chart is a(n) ________.
chart sheet
A ________ in a pie chart identifies the pie slices.
data label
A(n) ________ is a value in a worksheet cell that is represented in a chart by a data marker.
data point
A(n) ________ is a group of related data points represented by data markers.
data series
In a formula, a % sign designates that a cell in a formula is an absolute.
false
When you select the data range for a pie chart, you should be sure to include the total cell on the worksheet.
false
________ is an Excel tool that finds the input needed to arrive at a desired result.
goal seek
Which of the following displays trends over time?
line chart
In Goal Seek, you enter the specific value that you want to achieve in the ________ box.
to value
A pie chart should be considered when you have just one data series to plot.
true
The Chart Elements button allows you to add, remove, or change chart elements.
true
The order of data in the worksheet determines how the pie slices are ordered in a pie chart.
true
To what extent can a pie chart be rotated?
up to 360 degrees
The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as ________.
what-if-analysis
Use the ________ key to select A5:A8 and D5:D8.
Ctrl
Which of the following is the first order of operations?
Expressions within parentheses
Which of the following is TRUE about a pie chart?
IT SHOWS THE RELATIONSHIP OF EACH PART TO A WHOLE.
How can you identify the Chart Elements button when you select a chart?
It is a green plus sign.
Where is the Format Painter button located?
ON THE MINI TOOLBAR AND THE HOME TAB
When you copy a formula to another cell and the cells in the formula change, the cells are known as relative cell references.
True
When you select two ranges on a worksheet to create a pie chart, there must be the same number of cells selected in each of the two ranges.
True