Search for courses or lessons
Redeem a coupon
Start free trial
Which of the following methods will work 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
Which of the following statements is incorrect when related to using Excel Tables as the source of a PivotTable?
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
Building against Excel tables versus directly against a data range helps future proof your solution for expanding data.
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 new 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 new data would NOT be pulled in to the PivotTable
Back to the top
© 2020 GoSkills Ltd.
Skills for career advancement