Notes_Tutorial20

Notes_Tutorial20 - Exchange rate 1.12 B6*A2 $B$6*A2 B6*$A2...

Info iconThis preview shows pages 1–15. Sign up to view the full content.

View Full Document Right Arrow Icon
Exchange rate 1.12 B6*A2 $B$6*A2 B6*$A2 B6*A$2 Date Sales in USD Sales in CDN Sales in CDN Sales in CDN Sales in CDN 1/9/2008 80,000 2/3/2008 78,000 4/15/2008 91000
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
B6*$A$2 Sales in CDN
Background image of page 2
Exchange rate 1.12 Date Sales in USD Sales in CDN 1/9/2008 80,000 2/3/2008 78,000 4/15/2008 91000
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Fitness client Weight (pounds) Height (inches) Age A 145 66 88 B 207 70 52 C 125 64 56 D 195 75 60 Sum using formula Sum using function Average using formula Average using function
Background image of page 4
Employee Position Hourly Wage J.M. Manufacturing M.G. Sales T.S. Sales N.S. Manufacturing
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Nested-IF (negative testing) Hourly Wages Manufacturing $40  Sales $35 
Background image of page 6
Employee Position Hourly Wage Nested-IF (negative testing) J.M. Manufacturing $40 $40 M.G. Sales $35 $35 T.S. Sales $35 $35 N.S. Manufacturing $40 $40 F.R.
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Student ID 723800 90% 0% F IF(B2<$E$ 640071 78% 60% D 168435 76% 70% C 588368 87% 80% B 660214 93% 90% A 286923 80% 213264 64% 227477 91% 690209 78% 178328 82% 232434 76% 769560 67% 600369 80% 322163 73% 724799 58% 479850 60% 693746 80% 535107 76% 298502 83% 875125 71% 324865 91% 736643 82% 214971 58% 880789 69% 109401 88% 850174 80% Percent Score Letter Grade Cutoff Values Letter Grade
Background image of page 8
$3,"F",IF(AND(B2>$E$3,B2<$E$4),"D",IF(AND(B2>$E$4,B2<$E$5),"C",IF(AND(B2>$E$5,B2<$E$
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
$6),"B","A"))))
Background image of page 10
Sum of all values Sum of positive values 23 -41 2 84 53 -34 24 58 38 52 14 54 -47 25 79 45 33 -74 41
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Annual interest rate Years (n) Loan principal PMT What is the monthly payment on a 5-year, $35,000 loan principal with a 6% annual interest rate?
Background image of page 12
Annual interest rate 6.00% Years (n) 5 Loan principal $35,000 PMT -$676.65 Now suppose you are able to pay only $400 per month, what is the maximum loan amount you can afford?
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Annual interest rate 6% Years (n) 5 Loan principal $35,000 PMT ($676.65) Month Beginning Balance Payment 1  $35,000.00  $676.65   $175.00   $34,498.35  2  $34,498.35  $676.65   $172.49   $33,994.20  3  $33,994.20  $676.65   $169.97   $33,487.52  4  $33,487.52  $676.65   $167.44   $32,978.31  5  $32,978.31  $676.65   $164.89   $32,466.55  6  $32,466.55  $676.65   $162.33   $31,952.24  7  $31,952.24  $676.65   $159.76 
Background image of page 14
Image of page 15
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 21

Notes_Tutorial20 - Exchange rate 1.12 B6*A2 $B$6*A2 B6*$A2...

This preview shows document pages 1 - 15. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online