Which of the following formulas is an example of a 3-D reference?
A) =SUMS(O14Anders:Zhang!)
B) =SUM(Anders:Zhang!O14)
C) =SUMOF'Zhang:Andrews'!
D) =SUMOF(Anders:Zhang!O14)

Question

Quizplus · Accepted Answer

Option B includes a reference to a range of cells across multiple worksheets, which makes it a 3-D reference. Option A is not a valid formula as there is no function called "SUMS". Option C and D are not valid formulas as there is no function called "SUMOF".

Which of the Following Formulas Is an Example of a 3-D