Assignment 2 (Duration: 20 hours; Hand in: End of 5th Week) P2, P3, P4, M1, M2
The Owner of BCC has asked you to develop a complex spreadsheet model to analyse their sales data, as covered in the scenario (P2).
This will involve the use of formulae, features and functions to process information (P3) and refining the complex spreadsheet model by changing rules and values (M1). You should also make use of multiple worksheets and appropriate features and functions. You must use appropriate tools to present data from your spreadsheet model (P4) and analyse and interpret data from the spreadsheet model (M2). The presented data will be used to provide supporting evidence for a business loan to help finance the European expansion. |
|