PROJECT STEPS

Randi Perkel is a veterinary technician at the walk$-$in pet clinic of the Waterville Veterinary Hospital in Waterville, Maine. She is developing an invoice worksheet to track service charges for the Billing Department and has asked you to help complete the invoice.

Go to the Invoice worksheet. Enter the text Waterville Pet Clinic in cell A$1$ to provide a title for the worksheet.

In cell B$4,$ enter the date $\frac{5}{12}\frac{?}{21}($which Excel formats as $"5/12/2021")$ to provide the date the service was provided. $[$Mac Hint: The date will displayed using the format $\frac{m}{d}\frac{?}{yy}.$

In cell B$5,$ change the text $"$B$101"$ to R$101$ so that the cell contains the correct reference number.

In cell C$13,$ enter $2$ as the quantity of arthritis medications provided for Rex.

Clear the contents of cell C$17,$ which should not contain a value.

Calculate the total charge for each item. In cell E$10,$ enter a formula that multiplies the value in cell D$10($the charge$)$ by the value in cell C$10($the quantity of items$)$ to find the total charge for the examination. Use the Fill Handle to fill the range E$11$:E$14$ with the formula in cell E$10$ to find the total charge for each item.

In cell E$15,$ enter a formula that uses the SUM function to total the range E$10$:E$14$ to calculate the subtotal of all the charges.

In cell E$17,$ enter a formula that subtracts the value in cell E$16($the discount$)$ from the value in cell E$15($the subtotal$)$ to find the total charge.

Copy the content of cell B$6,$ then paste it in cell C$20.$