D100 WGU (Pivot)
Format Table - ANS-Good to do before making a pivot
What is true about the qualitative values in a PivotTable? - ANS-They classify data by
creating groups, based on the unique values for the qualitative values.
PivotTables are used to summarize measures by displaying the results of table
calculations. What are the two parts of these calculations? - ANS-A quantitative value
and an algorithm
Pivot Table Fields - ANS-Pulls the columns and associated date to new worksheet
Filters - ANS-What filters (if any) wanted added to report
Columns - ANS-What columns do I want to have displayed
Rows - ANS-What rows do i want to have displayed
Values - ANS-what values do I care about in the report
Protecting sheet - ANS-select cells that can be changed - home -launch - protection -
unclick lock - review tab - changes group - protect the sheet - check protect worksheet
Format Table - ANS-Good to do before making a pivot
What is true about the qualitative values in a PivotTable? - ANS-They classify data by
creating groups, based on the unique values for the qualitative values.
PivotTables are used to summarize measures by displaying the results of table
calculations. What are the two parts of these calculations? - ANS-A quantitative value
and an algorithm
Pivot Table Fields - ANS-Pulls the columns and associated date to new worksheet
Filters - ANS-What filters (if any) wanted added to report
Columns - ANS-What columns do I want to have displayed
Rows - ANS-What rows do i want to have displayed
Values - ANS-what values do I care about in the report
Protecting sheet - ANS-select cells that can be changed - home -launch - protection -
unclick lock - review tab - changes group - protect the sheet - check protect worksheet
