Answered step by step
Verified Expert Solution
Link Copied!

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 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Big Data Concepts, Theories, And Applications

Authors: Shui Yu, Song Guo

1st Edition

3319277634, 9783319277639

More Books

Students also viewed these Databases questions