4
AssignmentMultiple Choice

Spreadsheet Basics

Question 4 • AL-Career Preparedness

Suppose one hundred stores participated in the fund-raiser for one year. What would be the most efficient way to calculate totals and store averages by month?

Answer
A
Using the sum and average functions on the range of cells
B
Manually adding and averaging values
C
Using formulas that reference values instead of cell addresses

Explanation

Use the spreadsheet’s SUM and AVERAGE functions on each month’s range of cells. These functions quickly calculate totals and store averages for all 100 stores, and they update automatically if values change. Manually calculating would take longer and be more prone to errors.

AI-written and checked against the verified answer.

Previous
Next