High School

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
d. /WorkbookName/WorksheetName/CellRange

Answer :

Final answer:

Cell referencing in Excel involves a specific format: [WorkbookName]WorksheetName!CellRange.(b)

Explanation:

The general form of an external reference is [WorkbookName]WorksheetName!CellRange, 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. For example, [RiskReturn.xls]OptimalChoice!B6 refers to cell B6 in the OptimalChoice sheet of the RiskReturn.xls workbook.

Other Questions