what is execl/calc?, homework help

Jan 13th, 2016
Price: $5 USD

Question description

In this assignment, you will create a spreadsheet for a small>HOME BUSINESS which is selling three vitamin products:  CoQ-10, Iron, and Zinc.  The owner wants to look at sales by ">PRODUCT for the first quarter of the year and ;">CALCULATE monthly profit on the products.  Open a spreadsheet and do the following:

  1. Merge cells B1 through D1 and ;">TYPE Sales & Profit in all caps.  Center this in the merged cells. 
  2. In cell B2,">TYPE CoQ-10.  In cell C2, type Iron.  In cell D2, type Zinc.  Center these in their cells and make them bold.
  3. In A3, type Jan.  In A4, type Feb.  In A5, type Mar.  These should all be bold as well.
  4. Type in some numbers to represent the sales of each">VITAMIN PRODUCT for each month.  Each number should be different.  Make sure they all have a dollar sign. You need to do this by formatting the cells as currency with no decimal places.  
  5. In A7, type Sales and make it bold and in italics.  
  6. Using the SUM function,  ">CALCULATE the total sales for each product.  These results should be in cells B7, C7, and D7.  
  7. In A8, type Average Sales in bold and italics.
  8. Using the average function, ">FIND the average sales for each product.  These results should be in cells B8, C8, and D8.
  9. In E2, type Profit in bold and italics and centered in the cell.
  10. Each product has a different profit margin.  The CoQ-10 product has a 10% profit margin.  This means if $80 is sold, the profit is 0.10*80 or $8.  The profit margin for Iron is 15%, and the profit margin for Zinc is 5% (which is a multiplication factor of 0.05).  In E3, calculate the total profit for January from the sales of the three products.  You will need to type in the formula rather than use a function (like SUM) to do this.  Remember that to multiply, you must use the asterisk symbol (hold shift while hitting the 8 key).  Do the same to determine the February and March profits.
  11. In A9, type Total Profit in bold and italics.  
  12. In E9, determine the total profit.  Fill this cell with a different color so that it stands out.  
  13. ">SAVEyour spreadsheet with the filename LastNameWeek6 and upload it in the assignment area.

Tutor Answer

(Top Tutor) njonjo
School: UC Berkeley

Studypool has helped 1,244,100 students

Review from student
" Goes above and beyond expectations ! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1828 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors