Question

13 POINTS!! BRAINLIEST TO CORRECT ANSWER! 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,!Sheet2A10)


=SUM(F2:F5,_Sheet2A10)

Answer 1

Answer:

a

Explanation:

Answer 2

Answer:

b. =SUM(F2:F5,Sheet2!A10)

Explanation:

EDGE2020

got it correct!