Question

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)

Explanation:

When referencing a cell from another worksheet in Excel, the correct syntax is =SUM(range,SheetName!CellReference). The exclamation mark (!) is used to separate the worksheet name from the cell reference. In the first option, there is no ! after Sheet2, so it's incorrect. In the third option, the ! is before the sheet name which is wrong. In the fourth option, _ is an incorrect separator. Only the second option =SUM(F2:F5,Sheet2!A10) follows the correct syntax.

Answer:

=SUM(F2:F5,Sheet2!A10) (the second option)