Pivot Tables
An interactive tool that allows you to look at spreadsheet data from many different perspectives
Pivot Table
A chart that provides a graphical representation of the data in a pivot table.
Pivot Chart
This tool shows arrows that indicate which cells are affected by the value of the currently selected cell.
Trace Dependents
What type of statement is an IF statement?
Conditional
Explain what this formula does.
=COUNTIF(D3:D52,"Providence")
It ccounts the number of times the word "Providence" occurs in the range D3:D52.
When building a pivot table, what do you drag and drop in to the grid at the bottom of the pivot table task pane?
Fields
List the steps to print a pivot chart; only the chart, nothing else that's on the data sheet.
Click on the chart, click the File tab, click Print
This filtering tool is used in pivot tables and pivot charts.
Slicer
This formula will add a range of numbers if one or more criteria is met.
Sumifs
In the SUMIFS argument window, which range requires numbers?
Sum range
What are the 2 pivot table contextual tabs?
Analyze and Design
What are the 3 pivot chart contextual tabs?
Analyze, Design, and Format
List the steps to clear all the filters from both the pivot table and pivot chart at the same time?
Analyze tab, clear, clear filters
When using the sumif and sumifs formulas, what type of data is always required?
Numbers
Open the "Technology Equipment Inventory" data sheet then write a formula that will tell you how many printers you have in stock.
=SUMIF(C3:C52,"Printers",E3:E52)
What are 2 things that are part of a pivot table, but not part of the original data sheet?
Filters
Totals
Which tool will update data in the pivot chart and pivot table at the same time?
Refresh All
What is the Fx button used for?
Formulas and Functions
Which formula would you use to analyze cell A3 to see if it's greater than 90, then return "Honors" if true, and "No Honors" if not true?
IF
Open the "Technology Equipment Inventory" data sheet then write a formula that will tell you the total number of items you have in stock from Educational Technolgoy.
=SUMIF(A3:A52,A50,E3:E52)
Which setting will allow you to change the way data calculates in a pivot table?
Field Settings
List tthe 2 main differences between a regular chart and a pivot chart
You don't need to highlight data before building the pivot chart
Pivot charts have filters
What type of data is in the new column and row that is automatically created when you build a pivot table?
Total, Grand Total, or Subtotal
This is the process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet
What-if Analysis Or Goal Seek
Open the "Technology Equipment Inventory" data sheet then write a formula that will tell you how many shipments of "Scanners" went to "LA".
=COUNTIFS(C3:C52,"scanners",D3:D52,"LA")