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
Advanced
Assuming you want to create a query to consolidate all queries in the current workbook, how would you get started?
Select all worksheets in the file and create a new query from Table or Range
Create a new blank query and type =Excel.CurrentWorkbook() in the formula bar
Create a new query From Excel Workbook and browse to the workbook you are currently in
Don’t know
2
Advanced
If you are editing a query, how do you ensure that you are seeing the most current version of the data available to you?
Go to Data ⇒ Refresh All
Go to Home ⇒ Refresh Preview
Power Query always shows the most recent version of the data
Don’t know
3
Advanced
You create a query called "Transactions" by referring to Excel.CurrentWorkbook(), expand the 3 tables in the workbook and hit Close & Load. What will happen when you refresh this query?
It will load the data from the 3 tables into a single table on a new worksheet
It will cause an increasing number of errors on each refresh
It will cause a circular reference, duplicating the number of rows on each refresh
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement