Quiz

  1. 1
    Intermediate

    How do you edit or reconfigure a query step when you are inside the query editor?

  2. 2
    Intermediate

    Someone shares a file with you containing a Power Query which pulls data from a workbook, but when you try to refresh the query you get an error saying that the “Download Did Not Complete”. Which of the following explanations is the most likely of those given to cause this error?

  3. 3
    Intermediate

    You have built a query that retrieves a weekly transaction record from a text file and then created a PivotTable that summarizes the transactions. Next week you get a new file and need to produce the same style of report for the week. What should you do?