Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel - Part 10
Test Description: 2nd 50
Instructions: Answer all questions to get your test result.
1) What is an organized collection of data called?
A
Database or list
B
Table or database
C
Table or field
D
Table or list
2) Which is the name of an interactive graphical representation of data that allows a user to change the groupings?
A
PivotDate
B
PivotTable
C
PivotChart
D
RotateTable
3) Which is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories in which to group the data?
A
RotateTable
B
PivotChart
C
PivotTable
D
PivotDate
4) Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or table?
A
Remove
B
Format as Table
C
Delete
D
Format
5) What can you use to easily filter pivot tables and cube functions interactively in a worksheet?
A
Division
B
Cutter
C
Sliver
D
Slicer
6) In a chart, what is data that appears along the horizontal scale of the chart called?
A
Y-axis data
B
Vertical data
C
X-axis data
D
Horizontal data
7) In a chart, what is data that appears along the vertical scale of the chart called?
A
Y-axis data
B
Horizontal data
C
X-axis data
D
Vertical data
8) What type of chart would be used to show proportions of a part to the whole?
A
Pie
B
Radar
C
Line
D
Column
9) Which is a tiny chart that provides a visual representation of data in a worksheet cell?
A
Dataline
B
Sparkline
C
FlashPoint
D
Trendline
10) Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
A
Design
B
Layout
C
Format
D
Style
*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?