I am not too savvy and need some assistance with these steps.

I am doing an assignment and using excel. I am not too savvy and need some assistance with these steps.

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

that row. Expenses = Numcars * Expense per Car

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.

the use of absolute cell addresses allows those Expenses

values to be changed and then by recalculation, update the entire

Excel table. It can be helpful to double-check a hybrid and a nonhybrid

row with a calculator for calculation accuracy.