Question

12. Identify the syntax used to enter the reference in a cell to link the cells of different worksheets? a. [WorkbookName]WorksheetName'!CellAddress b. [WorksheetName]WorkbookName'!CellAddress C. [SpreadsheetName]WorksheetName'!CellAddress d. '[WorksheetName]SpreadsheetName'!CellAddress​

Answer 1

Answer:

Create a cell reference to another worksheet ,

type = (equal sign) and the formula you want to use. Click the tab for the worksheet to be referenced. Select the cell or range of cells to be referenced.