in cell g13, insert a formula that adds taxes and fees to the base cost of the t
ID: 2586265 • Letter: I
Question
in cell g13, insert a formula that adds taxes and fees to the base cost of the trip in cell f13 by using the percentage value in the input area. use a mixed reference to the cell containing 20% In the input area above the data.
Tools Data Window Help e00a1Trips LastFirs Formulas Data Review View Insert Page Layout Define Name Create from Selection AutoSum Recently Firancial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions pean Excurslons nt Sales and Commissions input Area Summary Statisties Total for all trips Average trip cost Median trip cost Lowest cost Highest cost Todry's date: es and Fees onthi Per Year Agent Name Student iD Tour Code Colins McDonnough Trip Description Departure Date lase Cost of Trigal Cost with Tadent Payment Fge 20 Check Out the Czech Republic 10 Adventures in Canada 60 Roaming Rome 10001 Croatian Wonders 8/25/04 10/14/04 Parisian PMeasures 2749 1849 Viva España 10 Adventures in Canadia 40 Uve it Up London 50 Parisian Pleasures 60 Roaming Rome 0009 10/14/04 749 1849 PLookup Tables DataExplanation / Answer
=SUM(F13,F13*B$6)
click the insrtion point in the formula bar and then type $ before the column or row you want to make absolute.
B F G 6 INPUT 20% 13 1799=SUM(F13,F13*B$6)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.