Microsoft Excel Formulas Questions and Answers 2

Question 1

What does the SUMPRODUCT function do in Excel?

Accepted Answer

Multiplies corresponding elements in arrays and returns the sum of those products

Answer

Adds all products in a product catalog

Answer

Calculates the sum and product separately

Answer

Multiplies all values in a single range

Question 2

Which formula correctly calculates the percentage change between an old value in A1 and a new value in B1?

Accepted Answer

=(B1-A1)/A1

Answer

=(A1-B1)/B1

Answer

=B1/A1*100

Answer

=(B1+A1)/A1

Question 3

What is the result of the formula =MOD(17,5)?

Accepted Answer

2

Answer

3

Answer

5

Answer

17

Question 4

Which formula would you use to combine the text in cells A1 and B1 with a space between them?

Accepted Answer

=A1&" "&B1

Answer

=A1+" "+B1

Answer

=JOIN(A1," ",B1)

Answer

=MERGE(A1,B1)

Question 5

What does the ROUND function do when the second argument is negative, such as =ROUND(1567,-2)?

Accepted Answer

Rounds to the nearest hundred, returning 1600

Answer

Returns an error

Answer

Rounds to 2 decimal places, returning 1567.00

Answer

Removes the last two digits, returning 1500

Question 6

Which formula returns the number of days between two dates in cells A1 and B1?

Accepted Answer

=B1-A1

Answer

=DAYS(A1,B1)

Answer

=DATEDIF(A1,B1,"D")

Answer

=NETWORKDAYS(A1,B1)