If you want to create a cell reference to the B6 on the Summary Info worksheet of the Sales.xls workbook,you would use the following external reference: ____.
A) '[Sales.xlsx]Summary Info'/B6
B) '(Sales.xlsx)Summary Info'!B6
C) '[Sales.xlsx:Summary Info]'!B6
D) '[Sales.xlsx]Summary Info'!B6

Question

Quizplus · Accepted Answer

The correct syntax for an external reference to a cell in a different workbook is '[workbook name]worksheet name'!cell reference. Therefore, the correct external reference to cell B6 on the Summary Info worksheet of the Sales.xlsx workbook would be '[Sales.xlsx]Summary Info'!B6. Option D is the only choice that follows this syntax. Options A, B, and C all have incorrect syntax.

If You Want to Create a Cell Reference to the B6