If you want to create a cell reference to 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

Option D is the correct choice as it uses the correct syntax for creating an external reference to a cell in a different workbook. The syntax includes the workbook name enclosed in square brackets, followed by the sheet name and cell reference separated by an exclamation mark. Therefore, the correct external reference to cell B6 in the Summary Info worksheet of the Sales.xlsx workbook is '[Sales.xlsx]Summary Info'!B6. Options A, B, and C are incorrect as they use incorrect syntax or incorrect workbook name.

If You Want to Create a Cell Reference to B6