Q1. Which of the following is the correct formula in MS Excel?
A = POWER (2^3)
B = POWER (2,3) Correct
C = POWER (2*3)
D = POWER (2#3)
Explanation
In MS Excel, the POWER function takes two arguments: the number and the power, separated by a comma, so = POWER (2,3) is the correct form among the printed choices. The expression using 2^3 places an exponent expression where the function expects separated arguments. The expression using 2*3 supplies multiplication inside a single argument instead of two arguments. The expression using 2#3 uses an invalid separator for this function.