Question 7

Question 6

Question 5

Question 2

Quiz 5-11-12

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

Class Notes 04-09-12

Class Notes

Basic Navigation

q CTRL + Home (Takes you to A1)

q CTRL +           /        (Takes you to the end/top of the worksheet if there are no entries below) (maximum rows: 1,048,576)

q CTRL +          (Takes you to the far right end of the worksheet) (last column is: XDF)

q CTRL + Page UP / Page Down (Navigates through the worksheets)

Function Keys

q F1 (Help)

q F4 (Repeat action key – repeats your last simple step action)

q F7 ( Spell check)

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