Chapter 3 Quiz, 18/20
A workbook sheet that contains only a chart.
Chart sheet
A value that originates in a worksheet cell and that is represented in a chart by a data marker.
Data point
A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell.
Goal Seek
________ 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
When you print a chart sheet, how is it automatically formatted?
It is centered on the page.
A chart element that identifies patterns or colors that are assigned to the categories in the chart.
Legend
A type of chart that displays trends over time.
Line
The command that moves a chart to a worksheet that contains only a chart and no other worksheet data.
Move Chart
A type of chart that shows the relationship of each part to a whole.
Pie
The area bounded by the axes of a chart, include all the data series.
Plot area
In a line chart, which of the following resides along the bottom of the chart?
The x-axis
The order of data in the worksheet determines how the pie slices are ordered in a pie chart.
True
The plot area of a chart is bounded by the axes, including all the data series.
True
Wrong---> A chart sheet contains only a chart and the data used to generate that chart.
True So, it will be false
The numerical scale on the left side of a chart that shows the range of numbers for the data points.
Value axis
Wrong -----> The Paste option used to paste calculated values that result from the calculation of formulas along with the formatting applied to the copied cells.
Values & Data Formatting
A chart and all of its elements is known as the ________.
chart area
You must select ________ on a worksheet to create a pie chart.
two ranges
Which symbol represents that a cell is an absolute cell reference in a function or formula?
$