Illustrated Excel 2019 | Module 1: End of Module Project 1 | Waterville Veterinary Hospital (2025)

Waterville Veterinary Hospital
COMPLETE AN INVOICE WORKSHEET

GETTING STARTED
• Open the file IL_EX19_EOM1-1_FirstLastName_1.xlsx, available for download from the SAM website.
• Save the file as IL_EX19_EOM1-1_FirstLastName_2.xlsx by changing the “1” to a “2”.
o If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• With the file IL_EX19_EOM1-1_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
o If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
PROJECT STEPS
1. 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 A1 to provide a title for the worksheet.
2. In cell B4, enter the date 5/12/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 m/d/yy.]
3. In cell B5, change the text "B101" to R101 so that the cell contains the correct reference number.
4. In cell C13, enter 2 as the quantity of arthritis medications provided for Rex.
5. Clear the contents of cell C17, which should not contain a value.
6. Calculate the total charge for each item. In cell E10, enter a formula that multiplies the value in cell D10 (the charge) by the value in cell C10 (the quantity of items) to find the total charge for the examination. Use the Fill Handle to fill the range E11:E14 with the formula in cell E10 to find the total charge for each item.
7. In cell E15, enter a formula that uses the SUM function to total the range E10:E14 to calculate the subtotal of all the charges.
8. In cell E17, enter a formula that subtracts the value in cell E16 (the discount) from the value in cell E15 (the subtotal) to find the total charge.
9. Copy the content of cell B6, then paste it in cell C20.
10. Hide the gridlines for the Invoice worksheet to make it look more like a printed invoice.
Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.
 
Final Figure 1: Invoice Worksheet