Question: 4. For this problem, DO NOT WRITE A C# PROGRAM OR USE VISUAL STUDIO - instead, create a Microsoft Excel spreadsheet that calculates the annual

4. For this problem, DO NOT WRITE A C# PROGRAM OR USE VISUAL STUDIO - instead, create a Microsoft Excel spreadsheet that calculates the annual cost of gas for your car. This will help you think through the components of a calculation, which will be helpful for future assignments. In individual cells of your spreadsheet setup the following: a) a cell where you enter a number for the cost of gas as a dollar amount per gallon b) a cell where you enter a number for the number of miles you estimate you drive in one year c) a cell where you enter a number for the estimated miles per gallon (MPG) that your car gets d) then a cell where you create a formula that calculates the number of gallons of gas your car uses, in one year [based on b) and c) above a formula that you create] e) then a cell where you create a formula that calculates the total cost of gas, for your car, for one year [based on d) and a) above a formula that you create] TEST: As you change values for a) b) c) in your spreadsheet, verify that cells d) and e) correctly recalculate. For example: INPUTS: if gas costs $3.00/gallon and your amazing car gets 1,000 Miles Per Gallon and if you drove 12,000 miles in one year then: OUTPUTS: your calculated gallons used in 1 year would be 12 Gallons, your calculated total cost of gas would be $36.00 - you can use these INPUTS/OUTPUTS to test
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
