·        Format the tables on each worksheets

o  properly formatted, labeled and titled (2 marks)

o  a non-default Table Style is applied to each (2 marks)

o  all tables have same format (1 mark)

·        Analyze the raw data and summarize them on Sales Rep, Manufacturers, Payment, etc. (4 marks)

·        present your findings/summary in at least two different types of Charts (2 marks)

o  on separate sheets presenting different information (1 mark)

o  properly formatted, labeled and titled (2 marks)

o  a non-default Chart Style is applied to each (1 mark)

·        use of proper Cell Styles and Borders (4 marks)

·        use of Structured (Named) References where appropriate (2 marks)

·        include at least three different AutoFunctions in your tables (Sum, Average, Min, etc.) (3 marks)

·        includes at least three, different, hand-written Formulae of at least intermediate complexity in your tables (6 marks)

o  formulas should display

§ complex calculations using multiple operations and parentheses and/or

§ non-AutoFunction Formulae (If, PMT, FV, Match, CountIf, etc.)

·        make sure that Formulae and other information is properly produced and copied by using the Fill Handle (2 marks)

·        use at least three different Number Formats (Accounting, Currency, Dates, etc.) correctly and consistently in your Tables (3 marks)

·        use Conditional Formatting at least twice in your Tables (4 marks)

·        print your Tables and Charts in a small booklet

o  print on both sides of the page (1 mark)

o  use the most appropriate page orientation(s) (portrait or landscape) for easy reading (1 mark)

o  set proper Print Areas to fit your tables and charts neatly on the pages without making them too small to read (1 mark)

o  in the headers of the printed pages, include the project title with the name of the organization (1 mark)

o  in the footers of the printed pages, include your names and titles, the date and the correct page numbers (2 marks)