In a 3-D reference,worksheets references are separated from their cell references by a(n)________.
A)single quotation mark (')
B)double quotation mark (")
C)exclamation mark (!)
D)period (. )

Question

Quizplus · Accepted Answer

In a 3-D reference, worksheets are separated from their cell references by an exclamation mark (!). This means that when referencing a cell in another worksheet within the same workbook, the syntax is 'SheetName'!CellReference.

In a 3-D Reference,worksheets References Are Separated from Their Cell