Explain why you would create a 3-D reference in one worksheet that refers to a cell in another worksheet instead of just typing a value in the second worksheet.

Question

What will be an ideal response?

Answer 1

With a 3-D reference if the value on the original worksheet changes, that change will be updated automatically in the second worksheet so that you do not have to change a value in both worksheets.