Latest:
LinkedIn Microsoft Excel Certification 

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

Editorial Staff
  •  The AutoSum formulas refer to the column to the left of their cells.
  • The AutoSum formulas exclude the bottom row of data.
  • The AutoSum formulas include the year at the top of each column in the calculation. The formula bar clearly shows it’s the dates (top row) included, along with the total (bottom) row. Thus, the bottom row of data is not excluded.
  • The AutoSum formulas include their own cells, creating a circular reference.

The correct answer is:

  • The AutoSum formulas include the year at the top of each column in the calculation. The formula bar clearly shows it’s the dates (top row) included, along with the total (bottom) row. Thus, the bottom row of data is not excluded.

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers

You May Also Like

Which custom format will make the cells in column A appear like the corresponding cells in column B?

Editorial Staff 0

What is the difference between a workbook and a worksheet?

Editorial Staff 0

You want to define a reusable process to reshape data (removing blank rows, merging columns, etc.). What toold can you use to accomplush this?

Editorial Staff 0