Formula | MCQs

Explanation

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

We can think of an array as a row of values, a column of values, or a combination of rows and columns of values.

Array formulas can return either multiple results or a single result.

Explanation

 IN MS Excel, the "IF" function is used to check the particular condition.

It will return differently depending on whether the result of the condition was TRUE or FALSE.

***

ND18-1-2023 

The correct syntax for an IF statement in Excel is: A =IF(LogicalTest, TrueResult, FalseResult) This syntax states that if the logical test is true, the function will return the TrueResult, and if the logical test is false, the function will return the FalseResult. The other options are not correct.

Explanation

=SUM(A1:A5)/(10-10) is not calculated in excel because 10-10 is zero so something divided by zero is not defined in the excel function.

***

ND18-1-2023

****

RY17-012-23

Explanation

The active cell displays the results of its formula while we see the formula itself in the Formula Bar. 

Explanation

The absolute cell reference in excel is a cell address that contains a dollar sign ($).

It can precede the column reference, the row reference or both.

Explanation

The formula =5 + 2 * 3 follows the order of operations (PEMDAS):

• Multiply 2 and 3: 2 * 3 = 6
• Add 5 to the result: 5 + 6 = 11

Explanation

A formula always starts with an equal sign (=)

Additional Information:

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