The Correct formula is to start the cell reference with the worksheet name and then you follow it by an exclamation point or mark.
How do you reference a cell A1?
A reference is known to be the cell's address and it is one that helps to identify a cell or numbers of cells.
Conclusively, the Correct formula is to start the cell reference with the worksheet name and then you follow it by an exclamation point or mark (!). E.g. if you want to reference cell B1 on Sheet2, its cell reference would be named as Sheet2! A2.
Learn more about worksheet from
https://brainly.com/question/25130975
#SPJ1
