Mathematical Operations | MCQs

Explanation

The quickest way to select a range of data on your worksheet is to use Ctrl+Shift+8.

Explanation

x⁵ represents x raised to the power of 5, which is commonly formatted as a superscript in MS Office.

Explanation

The Excel FACT function returns the factorial of a given number. For example, = FACT(3) returns 6, equivalent to 3 x 2 x 1. FACT(0) + FACT(3) + FACT(5) = 1 + 3 x 2 x 1 + 5 x 4 x 3 x 2 x 1 FACT(0) + FACT(3) + FACT(5) = 1 + 6 + 120 FACT(0) + FACT(3) + FACT(5) = 127

Explanation

None of above is correct order of precedence in formula calculation.

****

RY17-012-23

Explanation

An array formula is a formula that can perform multiple calculations on one or more of the items in an array.