Each of the following statements is TRUE about referencing data between worksheets EXCEPT:
A)One of Excel's more powerful features is the ability to reference data between worksheets.
B)Multiple worksheets represent a second dimension.
C)If you think of a worksheet as a two-dimensional array, then multiple worksheets in a workbook can be thought of as a three-dimensional array.
D)By using a 3-D formula with 3-D references, you can easily create a summary worksheet from multiple worksheets that are updated automatically as the source data is updated.

Question

Quizplus · Accepted Answer

Multiple worksheets add a third dimension, not a second, to the data structure in Excel. A single worksheet is already a two-dimensional array (rows and columns), so adding more worksheets is like adding layers or a third dimension.

Each of the Following Statements Is TRUE About Referencing Data