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
chart
C
axis
D
legend
2) Which of the following chart types is useful for showing relationships among the numeric values in several data series?
A
scatter
B
pie
C
line
D
bar
3) A chart's title, legend, and plot areas are all examples of chart _________.
A
type
B
data series
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
Format Layout
B
Format Selection
C
Chart Selection
D
Chart 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 Format tab must be selected
B
The Design tab must be selected
C
The Layout 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
border
B
axis
C
wall
D
data series
8) You can create one of the common _________ types by clicking its image on the Insert tab.
A
chart
B
grid
C
worksheet
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
pictures
B
charts
C
formats
D
visual presentations
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
left-pane
B
subtitles
C
right-pane
D
Name box
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
Title
C
Legend
D
Data labels
12) The __________ is the area bounded by the axes.
A
none of the above
B
chart area
C
plot area
D
graph area
13) When you create a chart, the chart tools become available and the __________ tab(s) are added to the Ribbon.
A
Format
B
Layout
C
all of the above
D
Design
14) A __________ displays the chart type name when you rest the mouse pointer over a chart type or chart subtype.
A
ScreenTip
B
none of the above
C
QuickTip
D
KeyTip
15) ___________ charts compare values across categories.
A
Clustered bar
B
Line bar
C
Pie bar
D
Stacked bar
16) A PivotTable report is especially designed for:
A
querying large amoutns of data in many different ways.
B
all of the above.
C
moving rows to columns or columns to pivot rows to examine different summaries of the data.
D
expanding and collapsing levels of data to filter results
17) _____________ makes it easy to show a data trend.
A
ChartStyles
B
Sparklines
C
PivotCharts
D
none of the above
18) Like a PivotTable report, a PivotChart report is ____________.
A
inactive
B
unresponsive
C
unchangeable
D
interactive
19) Related data markers in a chart are called a __________.
A
data source
B
data series
C
data score
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
chart
B
sparkline
C
slicer
D
line 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?