Please explain how to do the steps below as in what ill put into the box to compute the correct output its requesting

In the Profit Analysis worksheet: Expenses costs include maintenance, cleaning, and 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. Format: Currency (leading dollar sign) No decimal places Arial 10 point Normal font

Step Requirement Comments 19 In the Profit Analysis Worksheet: a. In the first cell directly under the Profit label, rowwise calculate total profit by subtracting Expenses from revenue (should be a positive number). b. In the first cell directly under the ProfitperCar label, row-wise divide Profit by NumCars. c. Adjust column widths as needed to eliminate truncation after formatting. Format: Currency (leading dollar sign) No decimal places for Profit and two decimal places for ProfitperCar data Arial 10 point Normal font 20 In the Profit Analysis worksheet: a. Create a Pivot Table using numeric data from Profit column. b. Display the total profit for each of the four classes of cars. c. Display the total profit for Airport as well as the Downtown location. d. Row and column calculations (sum) are required so that the total profit for EACH location and the total profit for EACH carclass are visible in the pivot table. There must be a grand total (sum) that represents the sum of ALL profit. e. Position the upper left corner of the Pivot Table in the same column as the Hybrid Expense per Car label begins and two rows below it. f. Use format as defined in the Comments. Locate the top edge of the Pivot Table in Row 4 and left aligned with the Hybrid Expenses label. Format (for pivot table labels, text, data as appropriate): Currency (leading dollar sign) No decimal places Right-align pivot table column labels Arial 10 point Normal font 21 In the Profit Analysis worksheet: a. Create a Pivot Table using numeric data from Profit column. b. Display the average quarterly profit for each of the four classes of cars. c. Display the average quarterly profit for each location. d. Row and column calculations (average) are required so that the average quarterly profit for EACH location and the average quarterly profit for EACH carclass are visible in the pivot table. There must be a composite average (average) that represents the average of all quarterly profit values. e. Position the upper left corner to align with the pivot table above and two rows below the pivot table above. f. The positioning of the column and row categories should match those of the above pivot table. This pivot table displays average NOT total. Adjust column widths to avoid data and label truncation after both pivot tables are created.

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