What is the correct way to refer the cell A10 on sheet3 from sheet1?
Tap an option to check yourself.
Answer: A) Sheet3!A10
In Excel, a cell on another sheet is referenced as SheetName!CellAddress.
Source: Scan #45 page 8 Q193
In Excel, a cell on another sheet is referenced as SheetName!CellAddress.
Source: Scan #45 page 8 Q193