| Project 1 Rubric | Name | ___________________________________________________________ |
| | Points Possible | Points Earned | Comments: |
| Customer and Company Info Section: |
| Company Name, Address, Phone and Website | 4 |
| Invoice Date (using function) | 2 |
| Invoice Number (input) | 2 |
| Due date (formula) | 2 |
| Bill To section: |
| Customer ID (drop down list) | 5 |
| Customer Name (Vlookup) | 5 |
| Customer Street Address (Vlookup) | 5 |
| Customer City, State and Zip (Vlookup) | 5 |
| Customer Phone (Vlookup) | 5 |
| Tax Exempt (drop down - yes or no) | 5 |
| Shipping Zone (vlookup) | 5 |
| Order Information: |
| Product Number (drop down list) | 5 |
| Description (Vlookup) | 5 |
| Quantity (input) | 2 |
| Quantity max at 50 units | 5 |
| Unit price (vlookup) | 5 |
| Amount (formula) | 5 |
| Subtotal (formula) | 5 |
| Tax: |
| IF Statement Correct | 5 |
| Uses assumption for tax percentage | 2 |
| Shipping: |
| Index and Match Table correct | 5 |
| Index and Match Table references assumptions | 5 |
| Shipping Formula: |
| Regular Shipping (not Alaska or Hawaii) | 5 |
| Free Shipping (not Alaska or Hawaii) | 5 |
| Regular + $15 for Alaska or Hawaii | 5 |
| Free Shipping + 15 for Alaska or Hawaii | 5 |
| Other Items: |
| Spellcheck | 5 |
| Professional appearance | 5 |
| Header with name | 2 |
| Invoice fit to one page | 2 |
| No #NA or #Value Errors | 4 |
| All blanks, no zeros, if no product info entered | 4 |
| All sheet tabs labeled appropriately | 4 |
| Total | 140 |
XEZEX
excel_project_rubric.xlsx
