Excel Math & Trig Function Quiz

Question 1

What is the primary difference between the SUMIF and SUMIFS functions?

Question 2

To round the number 123.456 to precisely two decimal places (123.46), which formula is correct?

Question 3

Which function returns only the remainder after a division (e.g., 10 / 3 = 1 remainder)?

Question 4

What does the ABS function do?

Question 5

Which function would you use to get a random whole number between 1 and 100?

Question 6

What is the difference between INT and TRUNC?

Question 7

Which function should you use to multiply every number in a range together?

Question 8

The MROUND function is used to round a value to:

Question 9

Which function allows you to perform common math operations (Sum, Average, etc.) while ignoring errors and hidden rows?

Question 10

What is the result of =POWER(10, 2)?

Question 11

To calculate the square root of 16 in Excel, use:

Question 12

Which function rounds a number UP to the nearest integer or multiple of significance?

Question 13

Excel's PI() function returns:

Question 14

What does SUBTOTAL(9, Range) do?

Question 15

To convert degrees into radians for use in trig functions, use: