Question: Expense report Open the Microsoft Excel file CH13 Expense Report from the data files. Edit the expense report to correct errors in spelling, capitalization, formulas,
Expense report Open the Microsoft Excel file CH13 Expense Report from the data files. Edit the expense report to correct errors in spelling, capitalization, formulas, and numbers. Attach a comment about any missing information. (Learning Objective 4)


100% % 0.00 123- Cambria 18 B I SA E- 2 fx Oak Industries A B C D E F G H 1 3 Subtotal 220.36 148.60 96.80 465.76 0 Breakfast Lunch Dinner Subtotal 6.50 10.48 7.56 8.80 21 12.50 26.87 39.37 14.06 31.78 26.87 66.21 22 10.48 16.36 23 57.00 24 Business Meals* Other Entertainment Subtotal 57.00 25 57.00 26 57.00 27 Gifts Other* Subtotal 0.00 28 18.00 18.00 29 18.00 30 Grand Total 277.73 216.08 113.16 31 606.97 32 Employee Signature Victor Perez Date 1/27/-- 33 Supervisor Signature 34 Date 35 Comments: *Explanation Required 36 37 + 5 Sheeti Oak Industries Expense Report 1/23/- For the Week Ending Employee Name Department Victor Perez Destination Cincinnati, ohio Job Fair Human Resourcces Purpose Monday Tuesday Wednesday Thursday Friday Saturday Sunday 0 Date 118 1/19/- 1/19/-- 121- 1/22/- 1/23/- 121- Total Airfare 12 Car Rental 13 Local Transportation 14 Tolls/Parking 15 Miles 16 Mileage Amount 17 Lodging 18 Subtotal 10.00 30.00 10.00 56.00 30.80 123.56 220.36 10.00 56.00 30.80 8.00 4.04 126,56 148.60 65.64 250.12 465.76 96.80 19 20 Breakfast Lunch Dinner 6.50 10.48 7.56 8.80 12.50 26. 87 21 14.06 31.78 26. 87 + Sheet1 100% % 0.00 123- Cambria 18 B I SA E- 2 fx Oak Industries A B C D E F G H 1 3 Subtotal 220.36 148.60 96.80 465.76 0 Breakfast Lunch Dinner Subtotal 6.50 10.48 7.56 8.80 21 12.50 26.87 39.37 14.06 31.78 26.87 66.21 22 10.48 16.36 23 57.00 24 Business Meals* Other Entertainment Subtotal 57.00 25 57.00 26 57.00 27 Gifts Other* Subtotal 0.00 28 18.00 18.00 29 18.00 30 Grand Total 277.73 216.08 113.16 31 606.97 32 Employee Signature Victor Perez Date 1/27/-- 33 Supervisor Signature 34 Date 35 Comments: *Explanation Required 36 37 + 5 Sheeti Oak Industries Expense Report 1/23/- For the Week Ending Employee Name Department Victor Perez Destination Cincinnati, ohio Job Fair Human Resourcces Purpose Monday Tuesday Wednesday Thursday Friday Saturday Sunday 0 Date 118 1/19/- 1/19/-- 121- 1/22/- 1/23/- 121- Total Airfare 12 Car Rental 13 Local Transportation 14 Tolls/Parking 15 Miles 16 Mileage Amount 17 Lodging 18 Subtotal 10.00 30.00 10.00 56.00 30.80 123.56 220.36 10.00 56.00 30.80 8.00 4.04 126,56 148.60 65.64 250.12 465.76 96.80 19 20 Breakfast Lunch Dinner 6.50 10.48 7.56 8.80 12.50 26. 87 21 14.06 31.78 26. 87 + Sheet1
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
