Excel 2010 Lesson 10 Question Preview (ID: 16516)
Excel 2010 Lesson 10.
TEACHERS: click here for quick copy question ID numbers.
A(n) __________ is a graphical representation of data.
a) chart
b) axis
c) legend
d) data series
Which of the following chart types is useful for showing relationships among the numeric values in several data series?
a) line
b) bar
c) scatter
d) pie
A chart's title, legend, and plot areas are all examples of chart _________.
a) borders
b) type
c) data series
d) elements
You can change a chart's fill color by clicking the chart area and then clicking _______ on the Format tab.
a) Chart Selection
b) Chart Layout
c) Format Selection
d) Format Layout
What tab would you click if you wanted to change the color of the font used on a chart's vertical axis?
a) Design
b) Format
c) Home
d) Layout
What must be true in order for the Chart Tools to be visible?
a) A chart must be selected
b) The Layout tab must be selected
c) The Format tab must be selected
d) The Design tab must be selected
You can add a(n) _______________ to a chart's plot area by selecting the area and then clicking one of the colored outlines under Shape Styles.
a) axis
b) wall
c) border
d) data series
You can create one of the common _________ types by clicking its image on the Insert tab.
a) picture
b) grid
c) chart
d) worksheet
You can create most ___________, such as column and bar charts, from data that you have arranged in rows or columns in a worksheet.
a) pictures
b) charts
c) formats
d) visual presentations
When you click a chart type in the left pane of the dialog box, the first chart of that type is selected in the _________.
a) left-pane
b) Name box
c) right-pane
d) subtitles
The ____________ is a box that identifies the patterns or colors that are assigned to the data series or categories in a chart.
a) Axis
b) Title
c) Data labels
d) Legend
The __________ is the area bounded by the axes.
a) graph area
b) plot area
c) chart area
d) none of the above
When you create a chart, the chart tools become available and the __________ tab(s) are added to the Ribbon.
a) Design
b) Layout
c) Format
d) all of the above
A __________ displays the chart type name when you rest the mouse pointer over a chart type or chart subtype.
a) QuickTip
b) KeyTip
c) ScreenTip
d) none of the above
___________ charts compare values across categories.
a) Clustered bar
b) Stacked bar
c) Line bar
d) Pie bar
A PivotTable report is especially designed for:
a) querying large amoutns of data in many different ways.
b) expanding and collapsing levels of data to filter results
c) moving rows to columns or columns to pivot rows to examine different summaries of the data.
d) all of the above.
_____________ makes it easy to show a data trend.
a) PivotCharts
b) Sparklines
c) ChartStyles
d) none of the above
Like a PivotTable report, a PivotChart report is ____________.
a) unchangeable
b) inactive
c) interactive
d) unresponsive
Related data markers in a chart are called a __________.
a) data score
b) data source
c) data scene
d) data series
Because a _____________ is a tiny chart embedded in a cell, you can enter text in a cell and use a sparkline as its background.
a) chart
b) slicer
c) sparkline
d) line chart
Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 16516 in the upper right hand corner or click here.
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 16516 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register