Question: PHASE 2 : SPREAD SHEET USING MS EXCEL In this phase, you will examine the same problem ( s ) described in phase 1 to

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: Item No. Item Name Arrival Date Quantity (kg)123AB Sodium April 1,2020400072CD Calcium May 8,2020700 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 or AVERAGE or COUNT or MIN or MAX at least ONE (1) should be an IF FUNCTION at least ONE (1) should use an Absolute cell reference 4. Use at least ONE (1) Conditional Format for your spreadsheet [1]5. Creation of at least TWO (2) Chart/Graphs (use proper titles & labels)[4]6. Inclusion on title for spreadsheet (name of the company/business that hired you)[2]7. Use of appropriate text formats/cell styles [2]8. Use of appropriate number formats (currency. Percentage etc. [2]9. Use of appropriate borders & Shadings [2]10. Use of appropriate row/column headings styles [2]11. Use of appropriate alignment and indentation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!