Please explain how to do this to the excel sheet below formulas and cells not co

Question

Please explain how to do this to the excel sheet below formulas and cells not contents

administrative expenses associated for a car rental. The Expenses for one rental transaction will be determined from the values specified in the worksheet. DO NOT enter the values in this column on a cell by cell basis. a. In the first cell directly under the Expenses label, calculate the total Expenses that corresponds to the number of cars rented IN THAT ROW (NumCars) using an "IF" statement to as part of the formula to determine the value of Expenses for one vehicle. b. First, use the "IF" statement to determine the single vehicle Expenses and second, edit the cell contents to multiply it by the NumCars so that the Expenses value represents the total Expenses costs for the Number of Cars (NumCars) rented in a given row. c. Use the absolute cell address for the numerical Expenses value for ONE vehicle which should then be multiplied by the number of cars in each row. d. Adjust column width as needed to eliminate truncation after format adjustments.. Note: the use of absolute addresses allows those Expenses values to be changed and then by recalculation, update the entire Excel table.

ExcelProject2 - Excel FRANCESCA BANNISTERX Table Tools Insert Draw Pae Layout Formulas Data Review View Help Team Design Tell me what you want to do AutoSum A . 2Wrap Text General Paste Copy B l u . |. |. A . E t-Merge & Center . $-96 , || conditional Format as Cel | Insert Delete Format Clear Sort & Find & Filter Select Fonmat Painter Formatting Table Styles Font Alignment Number Editing UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. Udate now AVERAGE 1YearQuarterLocationCarClassRevenue NumCars xses ProfitProfitPerCar Hybrid Expense per Car Non-Hybrid Expense per Car 100 2015 Q3 2015 Q3 Downtown Economy $805,325 Airport Economy$734,028 Downtown Economy $532,065 2015 2 Airport Economy $502,546 0,125 2015 02 Downtown Economy $396,848 Downtown Economy $375,118 2015 04 3,610 2015 01 Airport Economy ,408 2,881 2015 Q4 Airport Premium $663,901 4,055 3,533 2015 01 2015 Q4 Downtown Premium 624,053 Downtown Premium $540,217 $487,629 Airport Premium $505,403 370,679 2015 02 Downtown Premium 3,241 2015 01 2015 Q1 Airport Premium $375,811 2,466 2015 02 2015 Q4 Airport sUV 2015 Q4 Airport Premium $317,110 $663,548 $623,328 $540,623 $487,843 3,758 3,427 2015 02 Downtown SUV 4 Data Initial Analysis Profit Analysis O Type here to search ú e p® @ 0e @ ^adx 9/20/2018 1 12345678-9

Explanation / Answer

In Cell G2:

write the formula:

=if(D2="Hybrid",$N$1,$N$2)*F2

Drag the formula till the bottom

In Cell H2:

write the formula:

=E2-G2

Drag the formula till the bottom

In cell I2:

write the formula:

=H2/F2

Drag the formula till the bottom

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---