What does the following MS Excel formula do? =SUM(Sheet1:Sheet4!D18)

AIt adds data from all D18 cells in Sheet1, Sheet2, Sheet3 and Sheet4 ✓ Correct

BIt adds data from cell D18 of Sheet1 and cell D18 of Sheet4 only

CIt adds all data in the range A1 to D18 in Sheet1, Sheet2, Sheet3 and Sheet4

DIt adds data from cell A1 of Sheet1 and cell D18 of Sheet4

Correct answer: (A) It adds data from all D18 cells in Sheet1, Sheet2, Sheet3 and Sheet4

Explanation

The formula =SUM(Sheet1:Sheet4!D18) adds the value in cell D18 from Sheet1, Sheet2, Sheet3 and Sheet4.

It does not add only Sheet1 and Sheet4 while skipping the sheets in between.

It does not sum a range from A1 to D18 across the sheets.

It does not combine cell A1 of one sheet with D18 of another.

The colon between sheet names creates a three-dimensional reference spanning consecutive sheets.

The same cell on every sheet in that range is included in the total.

Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.