Microsoft Excel Formulas 3

Question 1

Which function combines the results of multiple IF conditions without nesting?

Accepted Answer

IFS

Answer

IFS evaluates multiple condition-value pairs in order and returns the value for the first TRUE condition.

Question 2

What does =CONCATENATE("Hello", " ", "World") return?

Accepted Answer

Hello World

Answer

CONCATENATE joins text strings in order; the space in the middle argument produces "Hello World".

Question 3

The ROUND function =ROUND(3.567, 2) returns which value?

Accepted Answer

3.57

Answer

ROUND with 2 decimal places rounds 3.567 to 3.57 because the third decimal (7) is ≥ 5.

Question 4

Which formula correctly calculates a weighted average for values in A1:A3 with weights in B1:B3?

Accepted Answer

=SUMPRODUCT(A1:A3,B1:B3)/SUM(B1:B3)

Answer

SUMPRODUCT multiplies each value by its weight and sums the results, then dividing by total weight gives the weighted average.

Question 5

What does the & operator do in an Excel formula?

Accepted Answer

Concatenates text strings

Answer

The & operator joins (concatenates) text values, functioning identically to the CONCATENATE function.

Excel Practice Test