ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam
Go to Exam

Exam 70-778 topic 1 question 62 discussion

Actual exam question from Microsoft's 70-778
Question #: 62
Topic #: 1
[All 70-778 Questions]

You have a query that retrieves sales data. A sample of the data is shown in the following table.

You need to ensure that the values in the Date column contain a date. Null values must be replaced with the date from the previous row.
What should you click on the Transform tab in Query Editor?

  • A. Format, and then Clean
  • B. Date, and then Earliest
  • C. Fill, and then Down
  • D. Replace Values, and then Replace Errors
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
References:
https://www.excelcampus.com/library/fill-down-blank-null-cells-power-query/
by prokocim at April 25, 2020, 7:09 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
prokocim
Highly Voted 5 years, 1 month ago
C is correct
upvoted 11 times
...
Steviyke
Most Recent 4 years ago
Yeah C is the correct option. Under Fill in the Transform ribbon, you DOWN (for replacing null values with preceding values, and UP (replaces null values with values after them).
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel