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
legend
B
chart
C
data series
D
axis
2) Which of the following chart types is useful for showing relationships among the numeric values in several data series?
A
bar
B
line
C
pie
D
scatter
3) A chart's title, legend, and plot areas are all examples of chart _________.
A
data series
B
type
C
borders
D
elements
4) You can change a chart's fill color by clicking the chart area and then clicking _______ on the Format tab.
A
Chart Layout
B
Chart Selection
C
Format Selection
D
Format Layout
5) What tab would you click if you wanted to change the color of the font used on a chart's vertical axis?
A
Layout
B
Format
C
Home
D
Design
6) What must be true in order for the Chart Tools to be visible?
A
The Layout tab must be selected
B
The Design tab must be selected
C
The Format tab must be selected
D
A chart 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
wall
B
data series
C
border
D
axis
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
formats
B
charts
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
Name box
C
subtitles
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
Title
D
Legend
12) The __________ is the area bounded by the axes.
A
chart area
B
graph area
C
plot area
D
none of the above
13) When you create a chart, the chart tools become available and the __________ tab(s) are added to the Ribbon.
A
Layout
B
all of the above
C
Format
D
Design
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
Clustered bar
B
Stacked bar
C
Line bar
D
Pie bar
16) A PivotTable report is especially designed for:
A
expanding and collapsing levels of data to filter results
B
all of the above.
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
none of the above
B
Sparklines
C
PivotCharts
D
ChartStyles
18) Like a PivotTable report, a PivotChart report is ____________.
A
interactive
B
unresponsive
C
inactive
D
unchangeable
19) Related data markers in a chart are called a __________.
A
data series
B
data score
C
data source
D
data scene
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
sparkline
B
line chart
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?