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?
Create a new blank query and type =Excel.CurrentWorkbook() in the formula bar
Select all worksheets in the file and create a new query from Table or Range
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?
Power Query always shows the most recent version of the data
Go to Home ⇒ Refresh Preview
Go to Data ⇒ Refresh All
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