Question: What does this formula do? `=Sum(Sheet1:Sheet4!D18)`
- It adds data from cell D18 of Sheet1 and cell D18 of Sheet4
- It adds data from cell A1 of Sheet1 and cell D18 of sheet4
- It adds all data in the range A1:D18 in Sheet1, Sheet2, Sheet3 and Sheet4
- 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