help, please otne e01.grader h insert Page Layout Formulas Data Review View Help

Question

help, please

otne e01.grader h insert Page Layout Formulas Data Review View Help Tell me what yo File Home Cut Eb Copy Calibri -111-1A"" Wrap Text · General Paste Format Painter Merge & Center Clipboard Font Alignment E19 1 Travel Expense Report 2 Standard Inputs 3 Daily Meal Allowance 4 Airport Parking Daily Rate 5 Mileage Rate to/from Airport 6 Roundtrip Miles to Airport $ 65.00 9.00 0.60 20.00 Traveler Inputs Depart Date Return Date # of Nights Hotel Rate/Night Hotel Tax Rate 6/1/2018 6/5/201 149.00 18.00% 8 9 Detailed Expenses 10 Budget Item 11 Travel to/from Destination 12 Mileage to/from Airport 13 Airport Parking 14 Airfare 15 Destination Expenses 16 Shuttle to/from Hotel 17 Hotel Accommodations 18 Meals Budget Actual Over or under %of Budget 12 40.75 534.2 475 50 75 710 320 9 Other 20 Incidentals 21 Totals 50 575 1736.95 Expenses

Explanation / Answer

Use the below formulas mentioned:
Cell E5:
=E4-E3
Cell B12:
=B5*B6
Cell B13:
=(E5+1)*B4
Cell B17:
=(1+E7)*E6*E5
Cell B18:
=(1+E5)*B3
Cell D12:
=C12-B12
Cell E12:
=C12/D12

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.