Excel - Chapter 3: Key Terms and Multiple Choice
Category Axis
A chart element that contains descriptive labels for the data points plotted in a chart.
Bar Chart
A chart that compares categories of data horizontally.
Combo Chart
A chart that contains two chart types, such as column and line, to depict two types of data, such as individual data points and percentages.
Clustered Column Chart
A chart that groups columns side by side to compare data points among categories.
Pie Chart
A chart that shows each data point in proportion to the whole data series.
X Y (scatter) Chart
A chart that shows the relationship between two variables.
Line Chart
A chart that shows trends over time in which the value axis indicates quantities, and the horizontal axis indicates time.
Sizing Handle
A circle that enables you to adjust the height or width of a selected chart.
Chart Area
A container for the entire chart and all of its elements.
Alt Text
A description that displays when a pointer moves over the chart and is used by a screen reader to read the description to the user.
Data Series
A group of related data points that display in row(s) or column(s) in a worksheet.
Gridline
A horizontal or vertical line that extends from the horizontal or vertical axis through the plot area.
Sparkline
A miniature chart contained in a single cell.
Data Point
A numeric value that describes a single value on a chart.
Data Label
An identifier that shows the exact value of a data point in a chart.
You created a worksheet that tracks data for a basketball team. The range B10:F10 contains the difference in final points between your team and the other team. What is the recommended sparkline to create to represent this data? a. Line b. Column c. Win/Loss d. Plus/Minus
c
Which chart element should you display to show exact values for a data series in a bar chart? a. Chart title b. Legend c. Value axis title d. Data labels
d
You want to create a single chart that shows the proportion of yearly sales for five divisions for each year for five years. Which type of chart can accommodate your needs? a. Pie chart b. Surface chart c. Clustered column chart d. 100% stacked column chart
d
What type of chart would display the names of seven city names (such as Jefferson City and Salt Lake City) on a category axis that is the easiest to read? a. Column chart b. Bar chart c. Line chart d. Pie chart
b
Why would you add Alt Text to a combo chart? a. To include the axes titles for the primary and secondary axes b. To adhere to accessibility compliance for screen reader capabilities c. To display data labels that show exact values for each data point in the chart d. To provide an alternative chart title with more information
b
Which of the following is not impacted when you apply a chart style? a. The chart area fill color might change. b. The font size for the chart title changes. c. Chart elements may display or be removed. d. The fill colors for data series change.
c
Value Axis
The chart element that displays incremental numbers to identify approximate values, such as dollars or units, of data points in a chart.
Legend
The key that identifies the color or pattern fill assigned to each data series in a chart.
Axis Title
The label that describes either the category axis or the value axis.
Chart Title
The label that describes the entire chart.
Plot Area
The section of a chart that contains graphical representation of the values in a data series.
A worksheet contains columns listing new movie releases, total production costs, week 1 gross revenue, and week 2 gross revenue. Which of the following would least likely form a data series in a column chart? a. Movie names b. Production costs c. Week 1 gross revenue d. Week 2 gross revenue
a
Currently, a column chart shows values on the value axis, years on the category axis, and state names in the legend. What should you do if you want to organize data with the states on the category axis and the years shown in the legend? a. Switch the rows and columns in the chart. b. Change the chart type to a dual-axis chart. c. Apply a different chart layout and chart style. d. Set chart filters to exclude states in the legend.
a
The value axis currently shows increments such as 50,000 and 100,000. What option would you select to display the values in increments of 50 and 100? a. Show Axis in Thousands b. More Primary Vertical Axis Title Options c. Show Axis in Millions d. Show Right to Left Axis
a
What is an advantage of using the Recommended Charts command? a. The recommended chart includes a custom chart title that reflects the dataset. b. The recommend chart is always the best way to represent the dataset. c. The Insert Chart dialog box displays recommended chart types based on the selected data. d. Using Recommended Charts automatically inserts a chart in an empty range in a worksheet.
b
