Introduction to Pivots

What is a Pivot Table in Excel?

• A tool used for drawing freehand shapes
• A feature that allows users to create customized charts
• A data summarization tool used to analyze and extract significance from large datasets
• A feature to automatically correct errors in Excel sheets

Which of the following is NOT a valid area in a Pivot Table layout?

• Values
• Columns
• Rows
• Colors

Which option helps in refreshing the data in a Pivot Table?

• Update Table
• Refresh Pivot
• Reload Data
• Reanalyze

How can you sort data in a Pivot Table?

• Right-click and choose the 'Sort' option
• Drag and drop fields in the desired order
• Use the 'Sort' button in the Pivot Table Tools
• All of the options are correct

What is a 'Pivot Chart' in Excel?

• A type of chart that can be created only with Pivot Tables
• A chart that displays data as bars
• A chart that visualizes the source data before pivoting
• A chart that updates automatically when the related Pivot Table is modified

When you place a field in the "Columns" area of a Pivot Table, how does it affect the data display?

• It arranges the data horizontally
• It applies conditional formatting to the data
• It changes the data to percentage format
• It filters out specific rows of data

What does the 'Slicer' feature in Pivot Tables allow you to do?

• Change the color scheme of the Pivot Table
• Create multiple Pivot Tables in one sheet
• Filter data interactively by selecting specific criteria
• D) Hide all empty cells in the Pivot Table

In a Pivot Table, where would you place a field to display data categorically from top to bottom?

• Values
• Columns
• Filters
• Rows

•  

  For a table to work properly, the top row should have column headings. Yes or no? 

• Yes

• No

• No, only rows may have headings

• Can`t say

•  

  Which of these is NOT included in the PivotTable Field List pane? 

• Column Labels

• .

  Values

• 
  Report Filter

• .

  Formulas