CompTIA Data+ (DA0-001) — Question 47

A user receives a large custom report to track company sales across various date ranges. The user then completes a series of manual calculations for each date range. Which of the following should an analyst suggest so the user has a dynamic, seamless experience?

Answer options

• A. Create multiple reports, one for each needed date range.
• B. Build calculations into the report so they are done automatically.
• C. Add macros to the report to speed up the filtering and calculations process.
• D. Create a dashboard with a date range picker and calculations built in.

Correct answer: B

Explanation

The correct answer is B because integrating calculations directly into the report allows for automatic updates whenever the data changes, eliminating the need for manual calculations. Options A and D, while helpful, do not provide the same level of automation and dynamic interaction as option B. Option C could improve speed but would still require manual effort to set up and use the macros.