
Excel Power Query Foundational Skills Assessment

Quiz
•
Professional Development
•
Professional Development
•
Easy
simon mwachi
Used 1+ times
FREE Resource
14 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 3 pts
What is Power Query mainly used for?
Powering your computer
Cleaning and transforming data
Creating memes
Charging phones with Excel
2.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Which of these is NOT a Power Query feature?
Load data from multiple sources
Clean and transform messy tables
Summon Excel gods
Combine multiple Excel sheets
3.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Where do you find Power Query in Excel?
Under Insert tab
On the Data tab, “Get & Transform” section
Next to PowerPoint
Behind the scenes with HR
4.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
What happens when you “Close & Load” in Power Query?
Excel goes to sleep
Your data is loaded into a worksheet
Excel crashes
The file closes itself and reboots your laptop
5.
MULTIPLE CHOICE QUESTION
30 sec • 3 pts
Power Query is best described as...?
A cleaning robot for your data
A finance officer
A spreadsheet DJ
An online dating site for Excel tables
6.
MULTIPLE CHOICE QUESTION
30 sec • 4 pts
If your source data updates, what should you do in Power Query?
Scream
Delete everything and start over
Click “Refresh”
Take a tea break and hope it fixes itself
7.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Why is Power Query useful for HELB officers?
Makes loan repayment lists cleaner
Automatically waives loans
Finds your long-lost classmates
Predicts how long graduates will dodge repayment
Create a free account and access millions of resources
Similar Resources on Wayground
18 questions
Pre-Training Assessment Power Query & Power Pivots(Genpact)

Quiz
•
Professional Development
10 questions
MS PowerBI Assessment

Quiz
•
Professional Development
10 questions
Power BI week 6

Quiz
•
Professional Development
10 questions
Filtering and Sorting

Quiz
•
Professional Development
10 questions
Daelites PowerBi test week 3

Quiz
•
Professional Development
10 questions
Power BI Quiz

Quiz
•
Professional Development
15 questions
MS Excel

Quiz
•
Professional Development
10 questions
Power Bi class day 5

Quiz
•
Professional Development
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade