Have an account?
Skip to Content
Build your own quiz
Suggestions for you
16 questions
Show Answers
See Preview
- 1. Multiple Choice
What can you use to easily filter pivot tables interactively in a worksheet?
Slicer
Cutter
Division
Sliver
- 2. Multiple ChoiceJohn wants to create a chart that shows trends of sales for four quarters. What type of chart should he create?Pivot ChartLine ChartEmbedded ChartLinked Chart
- 3. Multiple Choice
What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?
Decrease/Increase
Collapse/Expand
Reduce/Add
Subtract/Add
- 4. Multiple ChoiceJohn wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use?DesignFormatLayoutAnalyze
- 5. Multiple ChoiceJohn has created a Pivot chart and would like to include a guide that would display the names of the series of data included on the chart. Which option would allow him to do this?Report FilterLegend FieldsAxis FieldsValues
- 6. Multiple ChoiceIn order to directly report the data, what must a PivotChart always be associated with?TableRangePivotTableWorksheet
- 7. Multiple Choice
Which is the name of an interactive graphical representation of data that allows a user to change the groupings?
PivotChart
PivotTable
PivotDate
Rotate Table
- 8. Multiple ChoiceWhat ribbon contains the commands used to create a chart in Excel?Home RibbonInsert RibbonFormula RibbonData Ribbon
- 9. Multiple ChoiceJohn wants to change the chart style on his Pivot table. Which Pivot Table chart tools tab would he choose?DesignLayoutFormulaAnalyze
- 10. Multiple ChoiceWhat are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts?SliversPartialsSlicersMovers
- 11. Multiple ChoiceWhich is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories for grouping?PivotChartPivotTablePivotDateRotate Table
- 12. Multiple Choice
On a PivotTable, what is a field with values not entered as data but determined by a computation involving data in other fields called?
Complete
Auto
Calculated field
Analyzed field
- 13. Multiple ChoiceWhich ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable?LayoutOptionsDesignFormat
- 14. Multiple ChoiceWhat is the process of viewing a PivotTable report for a subset that meets the criterion only?FilteringSortingPositioningArranging
- 15. Multiple ChoiceWhen creating a PivotTable, which are drawn in columns in the worksheet data?RecordsFieldsCellsRanges
- 16. Multiple ChoiceWhich tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart?DesignLayoutFormatAnalyze
- Answer choicesTagsAnswer choicesTags