Microsoft Office Tutorials and References
In Depth Information
Session 2.2
Quick Check Answers
Session 2.1
Review
1. =MIN(B1:B50)
2. =B2+C2
3. =$A$1+C2
4. (a) A1 (b) $A$1 (c) $A1 and A$1
5. Enter the values 1 and 3 in the first two rows of column A. Select the two cells and
then drag the fill handle down over the range A1:A99, completing the series.
6. TODAY()
Session 2.2
1. the loan amount, the interest rate, the number of payment periods, and the payment
due each period
2. =PMT(7%/12,5*12,10000)
3. PV
4. =IF(A1>B1, “Yes”, “No”)
5. NOT
 
Search JabSto ::




Custom Search