CPDS Quiz 2

What can you use to easily filter pivot tables interactively in a worksheet?

• Slicer

• Cutter

• Division

• Sliver

John wants to create a chart that shows trends of sales for four quarters. What type of chart should he create?

• Pivot Chart

• Line Chart

• Embedded Chart

• Linked Chart

What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?

• Decrease/Increase

• Collapse/Expand

• Reduce/Add

• Subtract/Add

You wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use?

• Design

• Format

• Layout

• Analyze

Ram 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 Filter

• Legend Fields

• Axis Fields

• Values

Which is the name of an interactive graphical representation of data that allows a user to change the groupings?

• PivotChart

• PivotTable

• PivotDate

• Rotate Table

You wants to change the chart style on his Pivot table. Which Pivot Table chart tools tab would you choose?

• Design

• Layout

• Formula

• Analyze

When creating a PivotTable, which are drawn in columns in the worksheet data?

• Records

• Cells

• Fields

• Ranges

How would you change the value of the Sales $ column of a PivotTable from Sum to Average?

• Double-click the value in the PivotTable, choose Value Field Settings, and select Average

• Right-click any cell within a Sales $ column in the PivotTable, choose Value Field Settings, and select Average

• Right-click the header for the Sales $ column in the PivotTable, choose Value Field Settings, and select Average

• Don’t know

When you drag the Sales Units column to the Values area of your PivotTable it shows up as “Count of Sales Units”. What is the most likely cause?

• There is at least one text value somewhere in the Sales Units column of the source data

• The Sales Units column of the source data is formatted as text

• Someone has already defined a Count of Sales Units column on the PivotTable and that format is being forced on the newly added column

• Don't Know