Which of the following adds the values in cell B21 on the worksheets between Sheet1 and Sheet4?
A)=SUM(Sheet1-Sheet4!B21)
B)=SUM(Sheet1:Sheet4!B21)
C)=SUM(Sheet1 Sheet2 Sheet3 Sheet4!B21)
D)=SUM(Sheet1_Sheet4!B21)

Question

Quizplus · Accepted Answer

The correct syntax for adding values from multiple sheets is to separate the sheet names with a colon (:) and include the cell reference after the exclamation mark (!). Therefore, the correct formula is =SUM(Sheet1:Sheet4!B21). Choice A is incorrect because subtracting sheet names is not a valid syntax. Choice C is incorrect because sheet names should be separated by a colon, not a space. Choice D is incorrect because sheet names should be separated by a colon, not an underscore (_).

Which of the Following Adds the Values in Cell B21