In cell E2, calculate the weekly rental rate by multiplying the daily rate by 96% for a 4% discount and then by 5 for a five-day week. In cell F2, determine the monthly rate using a similar approach. Copy both formulas down their respective columns.
a. Navigate to cell E2 on the Inventory sheet to compute the weekly rental rate. This involves multiplying the daily rate by 96%, accounting for a 4% discount, and then further multiplying it by 5 to represent a five-day week.
b. Execute the calculation for the weekly rental rate by entering the formula "=DailyRate*0.96*5" in cell E2. Replicate this formula down the column to uniformly apply the computation to other cells.
c. Shift focus to cell F2, where the objective is to ascertain the monthly rate. This entails multiplying the daily rate by 90% to accommodate a 10% discount and then multiplying it by 30 to align with a standard 30-day month.
d. Formulate the expression for the monthly rate in cell F2 as "=DailyRate*0.90*30" and extend the formula down the column to ensure its application to other cells. Ensure to replace "DailyRate" with the appropriate reference to the daily rate cell or value in both formulas.
Que. a. Click cell E2 on the Inventory sheet. The weekly rental rate is 96% of the daily rate for a 4% discount times 5 for a five-day week.
b. Enter a formula in cell E2 to multiply the daily rate by 96% times five days and copy it down the column.
c. Select cell F2. The monthly rate is 90% of the daily rate for a 10% discount times 30 for a standard 30 -day month.
d. Build the formula in cell F2 and copy it down the column.