Question: PHASE 2 : SPREAD SHEET USING MS EXCEL In this phase, you will examine the same problem ( s ) described in phase 1 to
PHASE : SPREAD SHEET USING MS EXCEL In this phase, you will examine the same problems described in phase 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 companybusiness This could be in the form of customer records, records of goods or services offered, financial records profitloss or inventory records, for example: Item No Item Name Arrival Date Quantity kgAB Sodium April CD Calcium May 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: At least TWO Sheets use colored sheet tabs and proper names At least TEN Records, all related to the companybusiness that hired you At least FIVE Formulas At least ONE should be SUM or AVERAGE or COUNT or MIN or MAX at least ONE should be an IF FUNCTION at least ONE should use an Absolute cell reference Use at least ONE Conditional Format for your spreadsheet Creation of at least TWO ChartGraphs use proper titles & labels Inclusion on title for spreadsheet name of the companybusiness that hired you Use of appropriate text formatscell styles Use of appropriate number formats currency Percentage etc. Use of appropriate borders & Shadings Use of appropriate rowcolumn headings styles Use of appropriate alignment and indentation
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
