Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel 2010 Lesson 10
Test Description: Excel 2010 Lesson 10
Instructions: Answer all questions to get your test result.
1) A(n) __________ is a graphical representation of data.
A
data series
B
axis
C
legend
D
chart
2) 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
3) A chart's title, legend, and plot areas are all examples of chart _________.
A
elements
B
data series
C
borders
D
type
4) You can change a chart's fill color by clicking the chart area and then clicking _______ on the Format tab.
A
Format Selection
B
Format Layout
C
Chart Layout
D
Chart Selection
5) What tab would you click if you wanted to change the color of the font used on a chart's vertical axis?
A
Home
B
Layout
C
Design
D
Format
6) What must be true in order for the Chart Tools to be visible?
A
The Layout tab must be selected
B
A chart must be selected
C
The Format tab must be selected
D
The Design tab must be selected
7) 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
data series
C
border
D
wall
8) You can create one of the common _________ types by clicking its image on the Insert tab.
A
worksheet
B
grid
C
chart
D
picture
9) You can create most ___________, such as column and bar charts, from data that you have arranged in rows or columns in a worksheet.
A
charts
B
formats
C
visual presentations
D
pictures
10) 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
right-pane
B
subtitles
C
Name box
D
left-pane
11) 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
Data labels
C
Legend
D
Title
12) The __________ is the area bounded by the axes.
A
graph area
B
none of the above
C
plot area
D
chart area
13) When you create a chart, the chart tools become available and the __________ tab(s) are added to the Ribbon.
A
all of the above
B
Design
C
Format
D
Layout
14) A __________ displays the chart type name when you rest the mouse pointer over a chart type or chart subtype.
A
QuickTip
B
none of the above
C
KeyTip
D
ScreenTip
15) ___________ charts compare values across categories.
A
Stacked bar
B
Clustered bar
C
Pie bar
D
Line bar
16) A PivotTable report is especially designed for:
A
all of the above.
B
expanding and collapsing levels of data to filter results
C
querying large amoutns of data in many different ways.
D
moving rows to columns or columns to pivot rows to examine different summaries of the data.
17) _____________ makes it easy to show a data trend.
A
PivotCharts
B
Sparklines
C
ChartStyles
D
none of the above
18) Like a PivotTable report, a PivotChart report is ____________.
A
unresponsive
B
interactive
C
inactive
D
unchangeable
19) Related data markers in a chart are called a __________.
A
data source
B
data series
C
data scene
D
data score
20) 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
line chart
B
sparkline
C
slicer
D
chart
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?