Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Beginner
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
Don’t know
2
Beginner
Which of the following statements is incorrect when related to using Excel Tables as the source of a PivotTable?
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.
It only takes a few steps to set up
Don’t know
3
Beginner
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
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement