If you want to create a cell reference to the range B5:E5 on the Summary Info worksheet of the Sales.xls workbook you would use the following external reference: ____.
A)'[Sales.xlsx]Summary Info'\B5:E5
B)'(Sales.xlsx)Summary Info'!B5:E5

Question

Quizplus · Accepted Answer

The correct syntax for an external reference in Excel includes the workbook name in square brackets, the worksheet name in single quotes if it contains spaces, and an exclamation mark before the cell range. Therefore, option B is correct.

If You Want to Create a Cell Reference to the Range