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
Format
B
Layout
C
Design
D
Analyze
2) John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use?
A
Design
B
Analyze
C
Layout
D
Format
3) John wants to identify the exact value that each column in his chart represents. Which option should he choose?
A
Arrows
B
Pictures
C
Gridlines
D
Labels
4) What ribbon contains the commands used to create a chart in Excel?
A
Formulas
B
Home
C
Insert
D
Data
5) What is typically included in the range of data selected to create a chart?
A
Titles only
B
Numeric data and Totals only
C
Numeric data, totals, and titles
D
Numeric data and titles
6) What term refers to an Excel Chart with offset pieces for emphasis?
A
Separated
B
Shattered
C
Exploded
D
Detached
7) What ribbon contains the commands for creating charts in Microsoft Excel?
A
Home
B
Data
C
Page Layout
D
Insert
8) Which is a tiny chart that provides a visual representation of data in a worksheet cell?
A
Sparkline
B
Dateline
C
Flashpoint
D
Trendline
9) Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
A
Design
B
Format
C
Style
D
Layout
10) What graphically represents trends in plotted data and predicts future values?
A
Charline
B
Error Bar
C
Sparkline
D
Trendline
11) Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart?
A
Design
B
Layout
C
Style
D
Format
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
Calculated Field
B
Total Field
C
Autosum
D
Analyzed Field
13) What can you use to easily filter pivot tables and cube functions interactively in a worksheet?
A
Sliver
B
Slicer
C
Cutter
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
PivotChart
B
RotateTable
C
PivotDate
D
PivotTable
15) Which is the name of an interactive graphical representation of data that allows a user to change the groupings?
A
PivotTable
B
PivotChart
C
RotateTable
D
PivotDate
16) What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts?
A
Movers
B
Slicers
C
Slivers
D
Partials
17) When creating a PivotTable, which are drawn in columns in the worksheet data?
A
Fields
B
Ranges
C
Cells
D
Records
18) What is the process of viewing a PivotTable report for a subset that meets the criterion only?
A
Sorting
B
Filtering
C
Arranging
D
Positioning
19) Which ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable?
A
Format
B
Design
C
Layout
D
Options
20) Which is the default method for summarizing data in a PivotTable?
A
Max
B
Count
C
Average
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?