You can enter formulas that reference cells on other worksheets in the workbook.

Name: You can enter formulas that reference cells on other worksheets in the workbook.
Brand: Quizplus
Rating: 4.7 (42 reviews)

Question

Quizplus · Accepted Answer

This is true, you can reference cells on other worksheets in the same workbook by including the sheet name before the cell reference, separated by an exclamation point. For example, if the cell you want to reference is in Sheet2 and has the address C4, the formula would be =Sheet2!C4.

You Can Enter Formulas That Reference Cells on Other Worksheets