Quiz - Formulas

Quiz on Formulas

Name: ________________________________________  Date:___________________

Answer the questions using the following Excel table:

Name	Math	Science
Frank	1	2
Jose	3	4
Jennifer	2	0

1.       What would you get as a result if you type:  COUNTA(B1:B4)?

2.       What would you get as a result if you type: MAX(B2:C4)?

3.       What would you get as a result if you type: MEDIAN(B2:C4)?

4.       What would you get as a result if you type:  IF(B3>3,”An A Student”, ”Not an A student”)

5.       If you want to add cells C2, C3 and C4 you should use the following formula:

1. =SUM(C2+C3+C4)
2. =ADD(C2:C4)
3. =SUM(C2:C4)
4. =SUM(C2,C4)

6.       When using the PMT formula you would be able to find:

1. The interest of a loan
2. The total amount you would pay for a loan
3. The time you would spend paying a loan
4. The monthly payment of a loan

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)