5 CustID fName 4 Michael 9 Bob 4 Lisa 2 Robin 3 Susan 1 Salvatore 2 Bill 5 Maria 7 Martha 8 Luis 4 Matt
Iname Nelson Metz Harris Spencers Ryland Wallace Dodd Duran Fried Lopez Day
Excel Assignment 4b (Advanced Functions) OrderID ProductName Quantity UnitPrice Total 19283c Dimension 2300 2 $649.00 $1,298.00 23404p Canon Multipass 3 $399.00 $1,197.00 16784c Inspiron 8200 1 $1,300.00 $1,300.00 17340c Latitude x200 1 $1,699.00 $1,699.00 19284c Dimension 2300 4 $649.00 $2,596.00 17341c Latitude x200 3 $1,699.00 $5,097.00 15434c Inspiron 2650 3 $899.00 $2,697.00 0232m Comfort Carry 20 $79.00 $1,580.00 0543m Kenneth Cole 5 $249.00 $1,245.00 50872n Logitech Wireless 15 $70.00 $1,050.00 23410p Canon ZR45MC 5 $799.00 $3,995.00
Alexander Chow 11/26/07 Software App. A Pd. 7
Alexander Chow 11/26/07 Software App. A Pd.7
5
fName Michael Bob Lisa Robin Susan Salvatore Bill Maria Martha Luis Matt Rate
Iname Nelson Metz Harris Spencers Ryland Wallace Dodd Duran Fried Lopez Day 8.00%
Excel Assignment 4b (Advanced Functions) Term in Years – Monthly Payment Principal 1 2 3 4 $1,298.00 $112.91 $58.71 $40.67 $31.69 $1,197.00 $104.13 $54.14 $37.51 $29.22 $1,300.00 $113.08 $58.80 $40.74 $31.74 $1,699.00 $147.79 $76.84 $53.24 $41.48 $2,596.00 $225.82 $117.41 $81.35 $63.38 $5,097.00 $443.38 $230.52 $159.72 $124.43 $2,697.00 $234.61 $121.98 $84.51 $65.84 $1,580.00 $137.44 $71.46 $49.51 $38.57 $1,245.00 $108.30 $56.31 $39.01 $30.39 $1,050.00 $91.34 $47.49 $32.90 $25.63 $3,995.00 $347.52 $180.68 $125.19 $97.53
5 $26.32 $24.27 $26.36 $34.45 $52.64 $103.35 $54.69 $32.04 $25.24 $21.29 $81.00
5 Excel Assignment 4b (Advanced Functions) Term in Years – Total Interest Paid fName Iname Principal 1 2 3 4 5 Michael Nelson $1,298.00 $56.93 $110.92 $166.29 $223.02 $281.13 Bob Metz $1,197.00 $52.50 $102.29 $153.35 $205.67 $259.25 Lisa Harris $1,300.00 $57.02 $111.09 $166.54 $223.37 $281.56 Robin Spencers $1,699.00 $74.52 $145.19 $217.66 $291.92 $367.98 Susan Ryland $2,596.00 $113.86 $221.84 $332.57 $446.05 $562.25 Salvatore Wallace $5,097.00 $223.56 $435.56 $652.97 $875.77 $1,103.93 Bill Dodd $2,697.00 $118.29 $230.47 $345.51 $463.40 $584.13 Maria Duran $1,580.00 $69.30 $135.02 $202.41 $271.48 $342.20 Martha Fried $1,245.00 $54.61 $106.39 $159.50 $213.92 $269.65 Luis Lopez $1,050.00 $46.05 $89.73 $134.51 $180.41 $227.41 Matt Day $3,995.00 $175.23 $341.39 $511.80 $686.42 $865.25 Rate
8.00%
Alexander Chow 11/28/07 Software App. A Pd. 7
Alexander Chow 11/28/07 Software App. A Pd. 7
5 Excel Assignment 4b (Advanced Functions) fName Michael Bob Lisa Robin Susan Salvatore Bill Maria Martha Luis Matt
Iname Principal Nelson $1,298.00 Metz $1,197.00 Harris $1,300.00 Spencers $1,699.00 Ryland $2,596.00 Wallace $5,097.00 Dodd $2,697.00 Duran $1,580.00 Fried $1,245.00 Lopez $1,050.00 Day $3,995.00 WINNER: LOSER:
Die1
Die2 5 5 2 5 2 3 6 3 1 1 3 0 11
Die3 3 2 2 3 2 2 4 2 5 4 4
Check 5 LOSER 5 LOSER 1 LOSER 6 LOSER 6 LOSER 4 LOSER 5 LOSER 2 LOSER 5 LOSER 5 LOSER 3 LOSER
5 Excel Assignment 4b (Advanced Functions) fName Iname Principal Rating Michael Nelson $1,298.00 Bronze Bob Metz $1,197.00 Bronze Lisa Harris $1,300.00 Bronze Robin Spencers $1,699.00 Bronze Susan Ryland $2,596.00 Silver Salvatore Wallace $5,097.00 Gold Bill Dodd $2,697.00 Silver Maria Duran $1,580.00 Bronze Martha Fried $1,245.00 Bronze Luis Lopez $1,050.00 Bronze Matt Day $3,995.00 Gold 1000 Bronze 2000 Silver 3000 Gold
Alexander Chow 11/28/07 Software App. A Pd. 7