Quiz on Formulas
Name: ________________________________________ Date: 5/11/12
Use the Following Excel Table to answer all the questions:
Name
|
Math Score
|
Science Score
|
Emily
|
100
|
89
|
Maria
|
90
|
85
|
Jose
|
90
|
73
|
1. What would you get as a result if you type: =SUMIF(B2:B4,”=90”)?
2. What would you get as a result if you type: =COUNTIF(C2:C4,”>80”)?
3. What would you get as a result if you type: =IF (B2>90,”A student”, ”Not and A Student”)
4. What would you get as a result if you type: =AND(B2>90,C2>90)
5. What is the purpose of the PMT formula?
A) Calculate the Interest Rate of a Loan
B) Calculate the Loan Amount
C) Calculate the monthly payment of a loan
D) Calculate the Total Interest after the payment have been completed
