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
Intermediate
You set up a query to unpivot the data shown in the image below as follows: Pull the data into Power Query ⇒ Right click the Customer column ⇒ Unpivot Other Columns. What will happen when you refresh the query if the original table is updated to have columns for Product 5, Product 6 and Product 7?
The newly added columns will be unpivoted as well
The columns for Product 1 through Product 4 will pivot, but the new columns will not
The query will break as the data source has changed
Don’t know
2
Intermediate
Is this data a good candidate to be unpivoted?
It could be if you transposed it first
No, it is already unpivoted
Yes
Don’t know
3
Intermediate
You are building a query that will unpivot a data set, and your intention is to use this table to drive several PivotTables. What should you ensure is removed from the data when you build the query?
Totals and subtotals
Column headers
We shouldn’t remove anything
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement