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