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?
Select a cell inside your data range > Home > Format as Table
Select a cell inside your data range > Insert > PivotTable
Go to the Insert tab > Table > Select your data range
Don’t know
2
Beginner
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.
Every time you add new data to the Table you need to update the Source range for the PivotTable
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?
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 data WOULD be pulled in to the PivotTable
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