Problem Solving with Computers (CS 135)
Dr. William J. Joel, WS 110, 7-9353

Project No. 2
(7 Points)

 

Problem

Using the solution you developed for Project No. 1, create a worksheet using Microsoft Excel.

Task

  • Create a set of equations based on your solution from Project No.1
  • Create a hand drawn version of your worksheet layout
  • Convert your equations into formulas, using your layout.
  • Enter values, formulas and labels into your worksheet and print out the final result with formulas turned on (see note below).
  • Submit:
    • your list of equations
    • a copy of your layout drawing
    • your list of formulas
    • a printout of your completed worksheet with formulas turned on

Notes

  • The values you include in the worksheet (gas mileage, distances, lodging, etc.) are up to you.
  • Feel free to do more than what is asked above, but note that if you do, you will neither lose nor gain points for the extra work.
  • To "turn on formulas"
    • From the Tools menu choose Options ...
    • Click on the View tab
    • Under Window Options check Formulas
    • Click on OK