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