PHASE 2: SPREAD SHEET USING MS EXCEL In this phase, you will examine the same problem(s) described in phase 1 to create a spreadsheet for the company or organization that hired you by using MS Excel, You will create sample Records of the data related to the company/business. This could be in the form of customer records, records of goods or services offered, financial records (profit/loss) or inventory records, for example: You are expected to: Use formulas for any calculations that may be necessary Create reports using charts and graphs as needed Format the spread sheet appropriately Create a spreadsheet that has the following specifications: 1. At least TWO (2) Sheets (use colored sheet tabs, and proper names) [3] 2. At least TEN (10) Records, all related to the company/business that hired you [10] 3. At least FIVE (5) Formulas 5] At least ONE (1) should be SUM/A VERAGE/ COUNT/MIN/MAX at least ONE (1) should be an IF FUNCTION at least ONE (1) should use an Absolute cell reference 4.UseatleastONE(1)ConditionalFormatforyourspreadsheet5.CreationofatleastTWO(2)ChartGraphs(usepropertitles&labels)[1][4] 6. Inclusion on title for spreadsheet (name of the company/business that hired you) [1] 7. Inclusion of header for atleast one sheet 8. Use of appropriate text formatsicell styles \1] [2] 9. Use of appropriate number formats (currency. Percentage etc.) 10. Use of appropriate borders \& Shadings [2] [2] 11. Use of appropriate row/column headings styles [2] 12. Use of appropriate alignment and indentation 2 TOTAL 35 MARKS PHASE 2: SPREAD SHEET USING MS EXCEL In this phase, you will examine the same problem(s) described in phase 1 to create a spreadsheet for the company or organization that hired you by using MS Excel, You will create sample Records of the data related to the company/business. This could be in the form of customer records, records of goods or services offered, financial records (profit/loss) or inventory records, for example: You are expected to: Use formulas for any calculations that may be necessary Create reports using charts and graphs as needed Format the spread sheet appropriately Create a spreadsheet that has the following specifications: 1. At least TWO (2) Sheets (use colored sheet tabs, and proper names) [3] 2. At least TEN (10) Records, all related to the company/business that hired you [10] 3. At least FIVE (5) Formulas 5] At least ONE (1) should be SUM/A VERAGE/ COUNT/MIN/MAX at least ONE (1) should be an IF FUNCTION at least ONE (1) should use an Absolute cell reference 4.UseatleastONE(1)ConditionalFormatforyourspreadsheet5.CreationofatleastTWO(2)ChartGraphs(usepropertitles&labels)[1][4] 6. Inclusion on title for spreadsheet (name of the company/business that hired you) [1] 7. Inclusion of header for atleast one sheet 8. Use of appropriate text formatsicell styles \1] [2] 9. Use of appropriate number formats (currency. Percentage etc.) 10. Use of appropriate borders \& Shadings [2] [2] 11. Use of appropriate row/column headings styles [2] 12. Use of appropriate alignment and indentation 2 TOTAL 35 MARKS
