Concept explainers
Explanation of Solution
Spreadsheet to track expenses:
Step 1: Design a spreadsheet as shown below.
The below spreadsheet contains columns like “Day”, “Mileage cost”, “Flight cost”, “Hotel cost”, “Taxi cost”, and “Total amount”.
Screenshot of the spreadsheet
In the above spreadsheet,
- The days are listed from “D6” to “D10”.
- The car mileage costs are listed in the cells from “E6” to “E10”.
- The flight costs are listed in the cells from “F6” to “F10”.
- The hotel costs are listed in the cells from “G6” to “G10”.
- The taxi costs are listed in the cells from “H6” to “H10”.
Step 2: Computing total amount spent for each day
Screenshot of the spreadsheet
In the above spreadsheet,
- The total amount spent for each day is calculated by adding all the costs.
- The cell “I6” contains the formula “SUM (E6:H6)”.
- The cell “I7” contains the formula “SUM (E7:H7)”.
- The cell “I8” contains the formula “SUM (E8:H8)”.
- The cell “I9” contains the formula “SUM (E9:H9)”.
- The cell “I10” contains the formula “SUM (E10:H10)”.
After calculating, the spreadsheet looks like the below screenshot.
Screenshot of the spreadsheet
Step 3: Computing total car mileage cost
Car mileage cost is calculated by adding all the amount that was spend for all days.
Screenshot of the spreadsheet
In the above spreadsheet, the cell “E11” contains the formula “SUM (E6:E10)” which adds all the values that are given in the range of cells...
Want to see the full answer?
Check out a sample textbook solutionChapter 12 Solutions
Computer Science Illuminated
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education