Question: The AutoSum formulas in the range C9:F9 below return unexpected values. Why is this?

1. The AutoSum formulas refer to the column to the left of their cells.
2. The AutoSum formulas exclude the bottom row of data.
3. The AutoSum formulas include the year at the top of each column in the calculation.
4. The AutoSum formulas include their own cells, creating a circular reference.

Answer: The correct answer of the above question is Option C:The AutoSum formulas include the year at the top of each column in the calculation.