Use the checklist below to earn the grade you want..
For a "C" you must have
- Correct formulas (absolute referenced)
- Simple formatting (colors, borders for organization for easy readability)
For a "B" you must have all the above plus:
- Additional formatting (currency, date, phone #, zip code)
- Restrict data entry in the order form
- No text in numerical fields
- Only correct product numbers can be entered
For an "A" you must have all above plus:
- Use data validation, sheet protection and cell formatting to:
- Completely control data entry
- Create a very User Friendly form
Extra Credit will be given for:
- Macro(s) that will clear the form and record the data for permanent record
- Get the date from the computer so date entry is unnecessary
- Use regions in your Vlookup formulas