Question 357 of 388
Single answerYou have data in a Microsoft Excel worksheet as shown in the following table. You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:- If the discount column returns an error, a discount of 0.05 must be used.- All the rows of data must be maintained.- Administrative effort must be minimized.What should you do in Power Query Editor?
✓ASelect Replace Errors.
BEdit the query in the Query Errors group.
CSelect Remove Errors.
DSelect Keep Errors.
✓
Correct Answer: A
Select Replace Errors.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.