2017 3rd Qtr Midterm Evaluation–Please fill this out and be HONEST & SPECIFIC in your responses. Thank you!

Excel Section 3

FINISH: QUIZ

You are looking into getting a $5000 loan. You are looking at Bellevue State Bank who has an APR of 12% and will give you a loan for 3 years AND Fidelity Bank who has an APR of 15% and will give you the loan for 2 years. Create a spreadsheet that incorporates the following:

  1. PMT
  2. MAX
  3. MIN
  4. AVG
  5. SUM
  6. IF
  7. Named Range
  8. Attractive formatting

YOU MAY DO THIS WITH A PARTNER–BE CREATIVE–YOU MAY ADD MORE INFORMATION TO MAKE THIS WORK

PRINT TWICE–SHOW FORMULAS & SHOW ANSWERS