Anna needs to reference a cell on another worksheet in her workbook. What is the correct syntax for this operation?

=SUM (F2:F5, Sheet2A10)

SUM (F2:F5, Sheet2! A10)

=SUM (F2:F5, ISheet2A10)

O ESUM (F2:F5,_Sheet2A10)

=SUM (F2:F5, Sheet2! A10)

Explanation:

There is an error in all the options, = SUM (F2:F5, Sheet2A10) this is the more and less correct.

If we want to make a reference on another worksheet, Anna has to add the symbol!, between the worksheet's name and the cell that wants to make the reference.

If we don't add the symbol = at the beginning is not a formula.