CIS101Excel Invoice ProjectWeek 6

Project Excel

CIS-101 Computer Information Systems

The goal of this project is to create an Excel Invoice File that you can use with clients or with other businesses like: NAPA Pro Link. It is important to be knowledgeablein creating Excel formulas and formatting. It is also necessary to be capable increatingExcel Invoice Documents that help with the day to day work flow. This project is designed as an exercise in formatting, layout, cells, and formulas within the Excel application while creating an INVOICE.

Directions:

  1. Create an Invoice from a blank Worksheet using Excel. Rename it to: Excel Project with your INITIALS.
  2. Select A1:L2 for a title area and type in “Invoice”. Use theMerge and Center option. Give this cell selection a background color and place a border on the bottom of these cells.

SEE EXAMPLE Picture BELOW

  1. Start at A4: create a billing information area to include customer’s name and address.
  2. Between Rows 8 and 9 create a border line that shows a breaking apart of the invoice file information.
  3. Create titles: Start at A10 withPart#, C10 Part Description, H10 Quantity, J10 Cost, and L10Total.
  4. Provide a Part #, Descriptions, Quantity, Cost for three parts, minimum 2 of each part; then use the PRODUCT formula“=PRODUCT(COL/ROW, COL/ROW)” in the L column in cells L11, L12 and L13 to find the total cost (Quantity x Cost) for rows 11, 12 and 13. Use the “$” Accounting number format (under NUMBER FORMATTING) for any cell that includes a number that is a dollar value.
  5. Once complete, column L, rows 11-13 should be the Total Cost of the Part (product) by Multiplying H column by J Column.
  6. Between Rows 14 and 15, there should be a border line.
  7. At H16 there should be a title “Total Cost of All Parts”.
  8. At H17 there should be a title “Cost of Labor”.
  9. At h18 there should be a title “Subtotal”.
  10. At H19 there should be a title “Taxes” and in the J column, a number for Tax %age.
  11. At H21 there should be a title “Total Cost”.
  12. In cell L16, use the SUM formula “=SUM(COL/ROW: COL/ROW)” to find the total cost of all parts.
  13. In cell L17, provide your own dollar amount for Cost of Labor.
  14. In cell L18, create a SUM formula to add L16+L17.
  15. Create a tax % in J19. Thenin cell L19,create a PRODUCT formula to multiply L18 x J19 to find the tax amount.
  16. In cell L21, create a SUM formula to add L18+L19
  17. The invoice needs to be in Portrait and Scaled to show 100% of the page.
  18. Email the Excel File to

1