Question 300
An executive wants an interactive summary of sales trends and pivotable figures in Excel. A targeted trial still reproduces the original gap after the team attempted this change: Design an Excel report layout over the report dataset. Which repair directly addresses the remaining defect?
Explanation
Correct Answer
Fix worksheet data bindings and aggregations in the Excel layout, then compare with source report data. This directly addresses the remaining defect for the requirement—An executive wants an interactive summary of sales trends and pivotable figures in Excel. It restores the mechanism described here: excel layouts are intended for analytical consumption and allow workbook-style exploration of report data.
Incorrect Answers
This correction is for the separate condition: A supplier aging report needs user-specified vendor filters and grouping options at runtime. It would not directly restore the intended behavior in this situation: An executive wants an interactive summary of sales trends and pivotable figures in Excel. Here, fix worksheet data bindings and aggregations in the excel layout, then compare with source report data, because excel layouts are intended for analytical consumption and allow workbook-style exploration of report data.
This correction is for the separate condition: A partner must change the display of a standard financial report using an app-based customization. It would not directly restore the intended behavior in this situation: An executive wants an interactive summary of sales trends and pivotable figures in Excel. Here, fix worksheet data bindings and aggregations in the excel layout, then compare with source report data, because excel layouts are intended for analytical consumption and allow workbook-style exploration of report data.
This correction is for the separate condition: A maintenance team wants a scheduled report to update derived flags without generating a document. It would not directly restore the intended behavior in this situation: An executive wants an interactive summary of sales trends and pivotable figures in Excel. Here, fix worksheet data bindings and aggregations in the excel layout, then compare with source report data, because excel layouts are intended for analytical consumption and allow workbook-style exploration of report data.





Microsoft Dynamics 365 Business Central Developer (MB-820) Practice Tests