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

When you sort a list of numerical value into ascending or descending order, the value in the middle of the list is the _____.

Editorial Staff 0

You want to apply subtotals per sport in the data below. What should you do before applying subtotals?

Editorial Staff 0

How can you use Format Painter to apply the format of a single source cell to several nonadjacent destination cells?

Editorial Staff 0