IL_EX19_EOM1-1_AngelNorth_Report_1

.xlsx

School

Atlanta Technical College *

*We aren’t endorsed by this school

Course

1000

Subject

Accounting

Date

Jun 5, 2024

Type

xlsx

Pages

5

Uploaded by AmbassadorMorningOstrich34

Illustrated Excel 2019 | Module 1: End of Module Project 1 Angel North GE ver. 17.2.0-rc0000 1. 10/10 Enter text in a cell. 2. 10/10 Enter a date in a cell. 3. 10/10 Update a value in a cell. 4. 10/10 Enter a number in a cell. 5. 10/10 Clear cell contents. 6. 10/10 Create a formula. Copy a formula into a range. 7. 10/10 Create a formula using a function. 8. 10/10 Create a formula. 9. 10/10 Copy and paste a range of values. 10. 10/10 Turn off the display of gridlines in a worksheet. SUBMISSION #1 | SCORE IS: 100 OUT OF 100 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. 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.] In cell B5, change the text "B101" to R101 so that the cell contains the correct reference number. In cell C13, enter 2 as the quantity of arthritis medications provided for Rex. Clear the contents of cell C17, which should not contain a value. 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. 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. 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. Copy the content of cell B6, then paste it in cell C20. Hide the gridlines for the Invoice worksheet to make it look more like a printed invoice.
Waterville Veterinary Hospital COMPLETE AN INVOICE WORKSHEET Author: Angel North Illustrated Excel 2019 | Module 1: End of Module Project 1 Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy the file from the SAM website.
y of
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help