CompTIA Data+ (DA0-001) — Question 78

A data analyst has been asked to create a sales report that calculates the rolling 12-month average for sales. If the report will be published on November 1, 2020, which of the following months shouts the report cover?

Answer options

• A. October 1, 2019 to October 31, 2020
• B. October 31, 2020 to November 1, 2021
• C. November 1, 2019 to October  31, 2020
• D. October 31, 2019 to October 31, 2020

Correct answer: C

Explanation

The correct answer is C, as it captures the entire 12-month period leading up to the report date of November 1, 2020. Option A is incorrect because it does not include November 2019, which is needed for the full year. Option B extends beyond the reporting period, while option D overlaps with the time frame but does not start from the correct date.