Question

x the right option.
What is the correct way to refer cell A1 on sheet 2 from sheet 1?
​

Answer 1

Explanation:

to reference a cell or range of cells in another worksheet in the same workbook, put the worksheet name followed by an exclamation mark(!) before the cell address