Class Work - Formulas in Excel

Use the following table to answer all the questions:

Name	Total Hours	Pay Rate
Francisco	8	$10.5
Milena	10	$10
Laura	12	$6
Pedro	15	$9.5

1. What is the value on cell B4?

2. What would be the result after typing =AVERAGE(B2:B3)?

3. If you want to add cells B2, B3 and B4 you should use the following formula:

A)    =SUM(B2+B3+B4)

B)    =ADD(B2:B4)

C)    =SUM(B2:B4)

D)    =SUM(B2,B4)

4. Write another way to write the following formula =AVERAGE(C3,C4,C5)
5. What is the purpose of the COUNTBLANK formula?
6. What would you get as a result after typing =COUNTA(B1:B5)?
7. Which of these formulas you should use to find the middle value among cells C2 to C5?

                  A) =MIDDLE(C2:C5)

                  B) =MIDDLE(C2,C5)

                  C) =MEDIAN(C2:C5)

                  D) =MEDIAN(C2,C5)