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

SUMPRODUCT multiplies corresponding elements in two or more arrays (ranges of the same size) and then sums those products, making it extremely versatile for conditional calculations.

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

The percentage change formula is (New-Old)/Old, which translates to (B1-A1)/A1 in Excel. Format the result as a percentage.

Question 3

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

Accepted Answer

2

Answer

MOD returns the remainder after division. 17 divided by 5 is 3 with a remainder of 2, so MOD(17,5) returns 2.

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

The ampersand (&) operator concatenates text strings in Excel. A1&" "&B1 joins the contents of A1 and B1 with a space character between them.

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

When the num_digits argument is negative, ROUND rounds to the left of the decimal point. -2 rounds to the nearest hundred, so 1567 becomes 1600.

Excel Practice Test

Excel Practice Test

Microsoft Excel Formulas Questions and Answers 2