Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)

1
When you want to visually represent the numeric data in a worksheet, Excel helps you create an appropriate:
A)Report.
B)Chart.
C)Timeline.
D)Data layout.
E)Slide.
2
The text label that describes each data series in a chart is called the:
A)Chart object.
B)Field name.
C)Category label.
D)Selectable component.
E)Source label.
3
This chart type displays the frequency of multiple data series relative to a center point with an axis for each category:
A)Round
B)Target
C)Radar
D)Combo
E)Surface
4
In a column chart, the category labels are shown:
A)On the horizontal axis.
B)On the vertical axis.
C)In the chart legend.
D)In the chart title.
E)On both axes.
5
An Excel chart that is displayed on its own sheet in the workbook is called:
A)A standalone.
B)A graphic element.
C)A chart sheet.
D)A diagram.
E)A schematic.
6
When you change the preset group of elements in an Excel chart, you are changing:
A)The diagram.
B)The scheme.
C)The selections.
D)The layout.
E)The orientation.
7
To apply changes to your chart's Shape Fill, Shape Outline, or Shape Effects separately, use:
A)Format tab.
B)Element pane.
C)WordArt.
D)Chart type.
E)Character tab.
8
Chart styles are based on:
A)WordArt.
B)Defaults.
C)Orientation.
D)Number of columns.
E)Workbook themes.
9
The type of chart that shows percentages of a whole and has no axes is:
A)A line graph.
B)A pie chart.
C)A percentage chart.
D)A bar graph.
E)A sheet chart.
10
The Excel feature that displays averages in your data and can be used to forecast data by plotting future approximate averages is the:
A)Legend.
B)Tick mark.
C)Trendline.
D)Gridline.
E)Chart analyzer.
11
The chart feature that allows you to specify which data is shown and which is hidden is the:
A)Filter.
B)Select data source tool.
C)Range detector.
D)Show/Hide button.
E)Data sorter.
12
The background color for a chart element is called the:
A)Shading.
B)Shape Fill.
C)Screen.
D)Background.
E)Design.
13
A variegated blend of colors in a chart element is called a:
A)Shadow.
B)Tint.
C)Gradient.
D)Blended fill.
E)Saturation.
14
A chart that includes two chart types such as a line chart and a column chart is referred to as a:
A)Mixed display.
B)Dual data display.
C)Radar chart.
D)Combination chart.
E)Custom chart.
15
Miniature charts that are displayed in a cell or cell range next to your data to illustrate patterns or trends are called:
A)Sparklines.
B)Forecast points.
C)Predictors.
D)MiniCharts.
E)Conditional charts.





To learn more about the book this website supports, please visit its Information Center.
Copyright (c)2014 McGraw-Hill Education .
Any use is subject to the Terms of Use and Privacy Notice | Report Piracy


Nordell, 1eOnline Learning Center

Home > Excel > Chapter 3 > Ch 3: Multiple Choice Quiz