Excel Power Query Foundational Skills Assessment

What is Power Query mainly used for?

• Powering your computer

• Cleaning and transforming data

• Creating memes

• Charging phones with Excel

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

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

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

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

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

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

What does the Power Query Editor open in?

• A different Excel workbook

• A special editor window

• WordPad

• A government portal

Which step is recorded automatically in Power Query Editor?

• Your tea break

• Every transformation you apply

• Your login credentials

• How many times you blink

What happens if you remove a step from the Applied Steps pane?

• Excel reports you to IT

• Nothing, it’s just for show

• That transformation is undone

• Excel deletes the internet