What is the proper format of an external reference to a workbook or worksheet thats name does not contains spaces;source and destination files are in the same folder.
A)''[WorkbookName]Worksheet''!Cell
B)[WorkbookName]Worksheet!Cell
C)'[WorkbookName]Worksheet'!Cell
D)Worksheet'!Cell

Question

Quizplus · Accepted Answer

When the workbook or worksheet name does not contain spaces, we do not need to use quotation marks around them. We can simply use the format "[WorkbookName]Worksheet!Cell". Moreover, as the source and destination files are in the same folder, we do not need to specify the full file path.

What Is the Proper Format of an External Reference to a Workbook