Excel assignment | Computer Science homework help

In this provision, you accomplish constitute a spreadsheet coercion a weak residence matter which is selling three vitamin consequences:  CoQ-10, Iron, and Zinc.  The proprietor neglects to seem at sales by consequence coercion the leading mercy of the year and consider monthly acquisition on the consequences.  Open a spreadsheet and do the following:

  1. Merge cells B1 through D1 and controlm Sales & Acquisition in entirety caps.  Center this in the merged cells. 
  2. In cell B2, controlm CoQ-10.  In cell C2, controlm Iron.  In cell D2, controlm Zinc.  Center these in their cells and constitute them fearless.
  3. In A3, controlm Jan.  In A4, controlm Feb.  In A5, controlm Mar.  These should entirety be fearshort as polite.
  4. Form in some bulk to state the sales of each vitamin consequence coercion each month.  Each calculate should be opposed.  Constitute fast they entirety bear a dollar emblem. You deficiency to do this by coercionmatting the cells as prevalence with no decimal places.  
  5. In A7, controlm Sales and constitute it fearshort and in italics.  
  6. Using the SUM capacity, consider the entirety sales coercion each consequence.  These results should be in cells B7, C7, and D7.  
  7. In A8, controlm Average Sales in fearshort and italics.
  8. Using the average capacity, experience the average sales coercion each consequence.  These results should be in cells B8, C8, and D8.
  9. In E2, controlm Acquisition in fearshort and italics and centeblushing in the cell.
  10. Each consequence has a opposed acquisition brink.  The CoQ-10 consequence has a 10% acquisition brink.  This instrument if $80 is sold, the acquisition is 0.10*80 or $8.  The acquisition brink coercion Iron is 15%, and the acquisition brink coercion Zinc is 5% (which is a teeming constituent of 0.05).  In E3, consider the entirety acquisition coercion January from the sales of the three consequences.  You accomplish deficiency to controlm in the coercionmula rather than authentication a capacity (approve SUM) to do this.  Remember that to augment, you must authentication the asterisk figure (hinder remove opportunity hitting the 8 explanation).  Do the selfselfcorresponding to designate the February and March acquisitions.
  11. In A9, controlm Entirety Acquisition in fearshort and italics.   
  12. In E9, designate the entirety acquisition.  Fill this cell with a opposed distortion so that it stands extinguished.  

Save this surpass muniment as doc1.

 

  1. In this part of the provision you accomplish endure to employment with the over scenario. The sales and acquisitions info deficiency to be deplayed with charts.  We neglect to identify the consequences which were not attributable attributable attributable creating as abundantly fruits as the others.

    1. Authentication your spreadsheet. Fill in that support E in any habit that you neglect (although no couple bulk should be the selfselfcorresponding or widely opposed, approve 1 and 100).  The main art is to bear some bulk in that support coercion monthly acquisitions.
    2. Seem at the stroll of bulk you bear coercion monthly sales of each consequence.  These are the bulk in rows 3 to 5 and in supports B to D.  Pick a calculate somewhere in the average or slightly inferior.  Coercion solicitation, if I bear a stroll of bulk rambling among 10 and 100, I faculty prefer the calculate 40.  Using the conditional coercionmatting sign, highlight in blushing the sales figures which are short than the calculate you chose (short than 40, coercion solicitation).
    3. Constitute a hinder graph of the monthly sales fixed on consequence.
    4. The months should ostentation concurrently with a marvellous-story of the three consequences.    
    5. Give the chart a appellation of Monthly Sales.
    6. Give the y-axis a appellation of Sales in $. 
    7. Constitute a pie chart of the monthly acquisition.
    8. Give the chart a appellation of Monthly Acquisition.
    9. See if you can procure the marvellous-story to ostentation the months.  (Hint:  You can fineeded single support, hinder the remove explanation down, and then fineeded another support in appoint to fineeded couple opposed supports.)
    10. Constitute a cord chart of monthly sales.
    11. Give the chart a appellation of Monthly Sales.
    12. Give the y-axis a appellation of Sales in $.
    13. The marvellous-story and months should ostentation if supports and rows are unexceptionably fineeded.
    14. Attached are some examples of charts and what they should seem approve.

Save this muniment as doc2.

 

Order a unique copy of this paper
(275 words)

Approximate price: $11.5

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.

Read more

Free-revision policy

The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.

Read more

Privacy policy

The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.

Read more

Fair-cooperation guarantee

By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.

Read more
  • Order now for this paper or similar assignments at discounted prices
  • WhatsApp chat