Question: What does this formula do? `=Sum(Sheet1:Sheet4!D18)`

  1. It adds data from cell D18 of Sheet1 and cell D18 of Sheet4
  2. It adds data from cell A1 of Sheet1 and cell D18 of sheet4
  3. It adds all data in the range A1:D18 in Sheet1, Sheet2, Sheet3 and Sheet4
  4. It adds data from all D18 cells in Sheet1, Sheet2, Sheet3 and Sheet4

Answer: The correct answer of the above question is Option D:It adds data from all D18 cells in Sheet1, Sheet2, Sheet3 and Sheet4