Question

What is the output of the following MS-Excel formula? =SUM(1,2)^SUM(1,1)
1. 8
2. 9
3. Error
4. 16
5.

Answer 1

Correct Answer - Option 2 : 9

The correct answer is 9.

• The result of the MS-Excel formula-SUM(1,2)^SUM(1, 1) is 9.
• Firstly SUM(1,2) will be solved and it is equal to 3------3^SUM(1,1)
• Then SUM(1,1) will be solved and it is equal to 2------3^2
• Then lastly 3^2 is solved which means the square of 3 is equal to 9.

• The Excel SUM function returns the sum of values supplied.
  • These values can be numbers, cell references, ranges, arrays, and constants, in any combination.
  • SUM can handle up to 255 individual arguments.
• Purpose 
  • Add numbers together
• Return value 
  • The sum of values supplied.
• Syntax 
  • =SUM (number1, [number2], [number3], ...)
• Arguments 
  • number1 - The first value to sum.
  • number2 - [optional] The second value to sum.
  • number3 - [optional] The third value to sum.