Expert answer:what is execl/calc?, homework help

Answer & Explanation: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:Merge cells B1 through D1 and ;”>TYPE Sales & Profit in all caps.  Center this in the merged cells. 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.In A3, type Jan.  In A4, type Feb.  In A5, type Mar.  These should all be bold as well.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.  In A7, type Sales and make it bold and in italics.  Using the SUM function,  “>CALCULATE the total sales for each product.  These results should be in cells B7, C7, and D7.  In A8, type Average Sales in bold and italics.Using the average function, “>FIND the average sales for each product.  These results should be in cells B8, C8, and D8.In E2, type Profit in bold and italics and centered in the cell.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.In A9, type Total Profit in bold and italics.  In E9, determine the total profit.  Fill this cell with a different color so that it stands out.  “>SAVEyour spreadsheet with the filename LastNameWeek6 and upload it in the assignment area.

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades