Q:

Suppose you are working on a worksheet named “Sheet1″ and you want to sum the value of cell A to A10 in the worksheet named “Sheet3″ then the correct formula in MS Excel 2010 is:

• 1
  =SUM(Sheet3iAI:A10
• 2
  =SUM (AL: A10)
• 3
  =Sheet3SAI:A1O
• 4
  =SUMSHEET3 (A1: A10)