Occasionally What Should You Do While Working With A Pivottable

Question: Why create an Excel table, prior to creating a PivotTable?

Answer: Because if new rows or columns are added to the table, the PivotTable will be aware of them when refreshed.When you make a PivotTable based on an Excel table, the PivotTable will be aware of any new rows or columns when you refresh it.

Question: Behind every PivotChart is a _____.

Answer: Behind every PivotChart is a PivotTable .PivotCharts visualize the data within a PivotTable.

Question: When would you use a PivotTable?

Answer: When you need to summarize a bunch of data.PivotTables summarize data so that you can make sense of it.

Question: Which of the following is a filter?

Answer: a timeline and a slicerTimelines and slicers are two types of filters you can add to a PivotTable

Question: When you add a row field, what are you doing?

Answer: Adding a condition that divides up a value field.Row fields divide up value fields.

Question: By default, where will Excel put a new PivotTable?

Answer: On a new sheet, to the left of the current sheet.By default Excel puts the PivotTable on a new sheet to the left of the one you're working on.

Question: What is the best use of a column field?to represent a vertical timelineto filter the entire PivotTableto filter an Excel tableto represent a horizontal timeline

Answer: to represent a horizontal timeline

Question: Which of the following is a conceptual representation of the value field?A list of people names that need to be sorted alphabeticallyA list of product names that need to be put in a specific orderA list of dates that need to be put in orderA pile of something that needs to be divided up

Answer: A pile of something that needs to be divided up

Question: PivotTables use the term _____ when referring to data columns.ColumnFieldValueRow

Answer: Field (???)

Question: Occasionally, what should you do while working with a PivotTable?Refresh the PivotTable, because this helps it calculate faster in ExcelDo nothing to update a PivotTable, because the case will always be up-to-date and recognize any changes you may have maderefresh the PivotTable, since it is simply a snapshot in timeRefresh the PivotTable, because this will format the PivotTable properly

Answer: refresh the PivotTable, since it is simply a snapshot in time

Question: Which of the following is a good thing to do prior to creating a PivotTable?delete columns of datadelete any blank rows or columnsdelete fields of dataabbreviate column names

Answer: delete any blank rows or columns