Back to lesson
1. What is the easiest way to create an official Excel table?
Go to the Insert tab > Table > Select your data range
Select a cell inside your data range > Insert > PivotTable
Select a cell inside your data range > Home > Format as Table
2. Which of the following statements is incorrect when related to using Excel Tables as the source of a PivotTable?
Building against Excel tables versus directly against a data range helps future proof your solution for expanding data.
It takes a lot of effort to set up.
Every time you add new data to the Table you need to update the Source range for the PivotTable.
3. Assume the following: We built a PivotTable and targeted the data range in $A$5:$K$150 as our data source. We then added more data in row 151. What would happen when we update our PivotTable?
If we set our PivotTable against the range $A$5:$K$150, the data WOULD be pulled in to the PivotTable.
The data would only have been pulled in if we inserted a new row at row 149.
If we set our PivotTable against the range $A$5:$K$150, the data would NOT be pulled in to the PivotTable.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement