The time has come to check your knowledge on what you’ve learned so far. Ready and waiting for you is a multiple choice quiz of 5 questions and you’ll find out your score at the end of the quiz.
You don’t need to pass the quiz to continue with the course, but we recommend that you aim for at least 80%. If you score below that mark then have a look back through the previous material to make sure you’re comfortable with all the themes that we’ve covered so far. Make sure that you complete the practice exercises. They really do help and are better at embedding knowledge than quizzes!
Below you’ll find a list of the topics that this quiz may cover:
Pass Mark to continue to next lesson: N/A
Time limit: N/A
0 of 5 Questions completed
Questions:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 5 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Tough luck, make sure you understand where you went wrong and if you feel you need to, have a look back at the material so far. Otherwise, carry on to the next lesson!
Congratulations, you’ve managed to hit the 80% mark. You’ve got a good understanding of the topics covered so far, so carry on to the next lesson!
How do you connect PowerQuery to a range of data?
Which section of the PowerQuery screen is like VBA recorder and records the steps that we take to clean and format our data?
Which section of the PowerQuery Editor shows the queries or connections that PowerQuery has made in the file?
In which tab on the ribbon is the “Add Conditional Column” button?
Can you edit individual cells of data in the PowerQuery screen?