Function Jeopardy

A

100

What’s wrong with this formula? =SUUM(A1:A10)

The function name is misspelled; it should be =SUM

200

Which function adds up a range of numbers?

Sum

300

Write a formula multiplying R5 and I9

=R5*I9

400

Write a formula to find the maximum value of cells B1, B2, and B3.

=MAX(B1, B2, B3)

500

Write a formula to calculate the sum of cells A1 through A10.

=SUM(A1:A10)

B

100

Write a formula to divide Y12 by K8

=Y12/K8

200

Fill in the blank: 

=________(D1:D8) to find the smallest value.

Min 

300

What’s wrong with this formula?

=SUM(A1 A2:A5)  

The comma is missing between A1 and the range A2:A5. 

Correct formula: =SUM(A1, A2:A5)

400

Fill In the Blank: 

=________(A1:A10) to find the highest value.

Max

500

What’s wrong with this formula? 

=MINIMUM(A1:A10)

There is no MINIMUM function in Excel; use MIN. 

Correct formula: =MIN(A1:A10)

C

100

Write a formula to find the average of cells D1 through D10.

=AVERAGE(D1:D10)

200

What’s wrong with this formula? 

=AVERAGE(A1+A2:A5)

Mixing a single cell (A1) with a range (A2:A5) is incorrect for AVERAGE. 

Correct formula: =AVERAGE(A1, A2:A5)

300

Fill in the blank: 

=________(B1:B5) to add the values in the range.

Sum

400

Write an equation to Add B8 and A5 and then divide that total by 7

=(B8+A5)/7

500

Write a formula to Divide A9 by B7 and then add the sum of A1 through A14. 

=(A9/B7) + (A1:A14)