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)