Senior Power Query

Test your Senior-level Spreadsheets Power Query skills in Tools Systems. This timed assessment evaluates your expertise in Accounting.

Duration: 5 minutes

•40 questions

Time Remaining: 05:00

Progress: 0%

40 questions remaining

Question 1 of 40Assessment

You need to dynamically set the file path for a CSV data source based on a value in an Excel cell named 'FilePath'. What is the correct approach?

A. Use the 'Source' dialog and type '=FilePath' directly into the path box

B. Define a Power Query parameter and link it to the named cell 'FilePath'

C. Modify the M code to use 'Excel.CurrentWorkbook(){[Name="FilePath"]}[Content]{0}[Column1]'

D. Create a query from the named cell, drill down to the value, and reference that query

Keyboard Shortcuts

↑↓Navigate options

EnterSelect answer

←→Prev/Next question

SSkip question

1-4Select A-D

EscClear answer

SpaceNext question

BackspacePrevious question