Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started