The general form of an external reference is ____ where Path is the path of the workbook file on the computer or network Workbook Name is the filename of the workbook and Sheet Range and Cell Range are worksheets and cells in the workbook respectively.
A)(WorkbookName)WorksheetName!CellRange
B)[WorkbookName]WorksheetName!CellRange
C)\WorkbookName\WorksheetName\CellRange

Question

Quizplus · Accepted Answer

The correct format for an external reference is [WorkbookName]WorksheetName!CellRange. Option A is incorrect because it doesn't include square brackets around the workbook name. Option C is incorrect because it uses backslashes instead of square brackets and exclamation marks.

The General Form of an External Reference Is ____ Where