Click cell E$2$ 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.

Enter a formula in cell E$2$ to multiply the daily rate by $96\%$ times five days and copy it down the column.

page E$2-195$Select cell F$2.$ The monthly rate is $90\%$ of the daily rate for a $10\%$ discount times $30$ for a standard $30-$day month.

Build the formula in cell F$2$ and copy it down the column.

Name cell ranges.

Select cells A$1$:A$17,$ press Ctrl$,$ and select cells D$1$:F$17.$

Create names from the selection $[$Formulas tab, Defined Names group$].$

Verify that you have created four range