Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
MS Excel Honors #7
Test Description: Review
Instructions: Answer all questions to get your test result.
1) John wants to change the chart style on his Pivot table. Which Pivot Table chart tools tab would he choose?
A
Analyze
B
Layout
C
Design
D
Format
2) John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use?
A
Layout
B
Format
C
Analyze
D
Design
3) John wants to identify the exact value that each column in his chart represents. Which option should he choose?
A
Pictures
B
Labels
C
Gridlines
D
Arrows
4) What ribbon contains the commands used to create a chart in Excel?
A
Data
B
Insert
C
Formulas
D
Home
5) What is typically included in the range of data selected to create a chart?
A
Numeric data and Totals only
B
Numeric data and titles
C
Numeric data, totals, and titles
D
Titles only
6) What term refers to an Excel Chart with offset pieces for emphasis?
A
Shattered
B
Exploded
C
Detached
D
Separated
7) What ribbon contains the commands for creating charts in Microsoft Excel?
A
Data
B
Insert
C
Home
D
Page Layout
8) Which is a tiny chart that provides a visual representation of data in a worksheet cell?
A
Dateline
B
Trendline
C
Flashpoint
D
Sparkline
9) Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
A
Format
B
Design
C
Style
D
Layout
10) What graphically represents trends in plotted data and predicts future values?
A
Charline
B
Sparkline
C
Error Bar
D
Trendline
11) Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart?
A
Layout
B
Design
C
Format
D
Style
12) On a PivotTable, what is a field with values not entered as data but determined by a computation involving data in other fields called?
A
Total Field
B
Autosum
C
Analyzed Field
D
Calculated Field
13) What can you use to easily filter pivot tables and cube functions interactively in a worksheet?
A
Slicer
B
Cutter
C
Sliver
D
Division
14) Which is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories for grouping?
A
RotateTable
B
PivotTable
C
PivotDate
D
PivotChart
15) Which is the name of an interactive graphical representation of data that allows a user to change the groupings?
A
RotateTable
B
PivotDate
C
PivotTable
D
PivotChart
16) What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts?
A
Partials
B
Slicers
C
Movers
D
Slivers
17) When creating a PivotTable, which are drawn in columns in the worksheet data?
A
Cells
B
Fields
C
Ranges
D
Records
18) What is the process of viewing a PivotTable report for a subset that meets the criterion only?
A
Positioning
B
Filtering
C
Arranging
D
Sorting
19) Which ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable?
A
Layout
B
Design
C
Format
D
Options
20) Which is the default method for summarizing data in a PivotTable?
A
Average
B
Max
C
Count
D
Sum
*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?