A

Admin • 828.03K Points
Coach

Q. Using the AutoSum button will replace in the selected cell ...... ?

  • (A) the sum of values in the cell's column
  • (B) nothing until you select a range of cells
  • (C) the sum of the cell's row unless you change the range
  • (D) a formula which will add values in the range Excel guesses you want to add
Explanation by: Admin
Using the AutoSum button will replace the selected cell with option (4) a formula that will add values in the range Excel guesses you want to add. The AutoSum button in Excel is a shortcut for quickly inserting a formula to calculate the sum of a range of cells. When you click the AutoSum button, Excel will automatically determine the range of cells it believes you want to add based on the adjacent cells, and it will insert a sum formula in the selected cell. The inserted formula will typically be something like "=SUM(A1:A10)", where A1:A10 represents the range of cells Excel guesses you want to add.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.