PREPARE AN EXCEL WORKBOOK

You will prepare an Excel Workbook for an existing or fictional organization of your choice presenting company information and statistics such as:

· inventory

· human resources

· sales and revenue

· budgets

· financial analysis and forecasting

Requirements:

Consistency across Excel workbook

– use the same Theme for all sheets (2 marks)

– consistent content, organization, positioning and formatting across all sheets (3 marks)

– they look clean, professional and uncluttered

Higher Marks for proper use and presentation/explanation of two or more of the following:

· 3d References

· functioning Data Table(s)

· Amortization Table(s)

· Named Reference Formulae

Excel Document

– includes at least two Tables (2 mark)

– on separate sheets presenting different information (1 mark)

– properly formatted, labeled and titled (2 marks)

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

– includes at least two different types of Charts (2 marks)

– on separate sheets presenting different information (1 mark)

– properly formatted, labeled and titled (2 mark)

– 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 Auto Functions 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)

 Formulas should display :

– complex calculations using multiple operations and parentheses and/or

– non-Auto Function Formulae (If, PMT, FV, Match, CountIf, etc.) 

– make sure that Formulae and other information is properly produced in Series 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 (2 marks)

– Use print option set – your Tables and Charts in a small booklet (no need to print, but set up like this print option)

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

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

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

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

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