FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Which of the following demonstrates the general format of a formula that references a cell in a different worksheet? SheetName! CellAddress.

Detailed explanation-2: -Create a cell reference to another worksheet You can refer to cells that are on other worksheets in the same workbook by prepending the name of the worksheet followed by an exclamation point (!) to the start of the cell reference.

Detailed explanation-3: -Click the tab for the first worksheet that you want to reference. Hold down the Shift key then click the tab for the last worksheet that you want to reference. Select the cell or range of cells that you want to reference. Complete the formula, and then press Enter.