excel homework

User Generated

1901599810_

Mathematics

Description

see attachment

see attachment

see attachment

see attachment

see attachment

see attachment

Unformatted Attachment Preview

HB337 HOMEWORK ASSIGNMENT #1 Using Excel 1. Entering Data  Enter in cell A1…Your name  Enter in cell E1… HB 337  Enter in cell A2…Your PID [e.g. A12345678]  Enter the following  Format numbers with 1000 separator (,)  Enter formula for Revenue in cell C5 to C10 [@$2.35 per bottle]  E.g. Cell C5: =b5*2.35  Enter formula for Cost of Goods Sold in cell D5 to D10 [@$19.20 per 24 bottle case]  E.g. Cell D5: =b5*19.2/24  Enter formula for Net Profit in cell E5 to E10 [Revenue-COGS]  E.g. Cell E5: =c5-d5 Page 1  Format numbers with $ sign, 1000 separator and 2 decimal places 2. Applying IF Formula Assume that there is a level of net profit that is deemed satisfactory… unless a month’s Net Profit exceeds $3,500 it should be classified as unsatisfactory. This is similar to a pass/fail test with $3,500 threshold.  Enter in cell F4 “Evaluation” as a title for column  Position cursor in the first of Evaluation column (cell F5)  Select the Paste Function or use Formulas… Insert Function option.  Select Function Category…Logical  Select Function Name “IF” then click “OK”  Enter in “logical_test”: E5>=3500  Enter in “value_if_true”: Satisfactory  Enter in “value_if_false”: Unsatisfactory  Check results for accuracy with respect to Net Profit of greater than or equal to $3,500  Apply/Drag it in Cell F6 to F10 3. Preparing a Bar Chart  Highlight…Cell A5 to E10  Click…Insert…Chart…Bar…Clustered Bar…OK  Click Chart title and type “Sales by Month”  Enter in Title (X) Axis: Click on the chart, click the “ + “ on top right hand side and check off “Axis Titles” and type Revenue on x-axis.  Enter in Title (Y) Axis: Click on the chart, click the “ + “ on top right hand side and check off “Axis Titles” and type Month on y-axis. Page 2  Click Design… Move Chart… New Sheet  Click OK  B e s u r e t h e b a r c h a r t appears as Chart 1 sheet  Click… Home…Copy 4. Linking the Bar Chart in MS-Excel to MS-PowerPoint Page 3  Open a blank slide in PowerPoint (Make sure the PowerPoint slide is open before you copy the table or it will not be able to find the copy)  Click… Home…Paste… Paste Special  Select… Paste link on left side of box  Be sure “Microsoft Excel Chart Object” is in the menu as below  Click… OK  Take a screen shot by clicking “PrtScn” on top right of keyboard  Open Paint Program by clicking start button at the bottom left of your screen and go to Paint  Crop the bar chart by using Paint program, right click, COPY  Paste the bar chart in a second PPT slide Page 4  Go back to MS-Excel  Select… Sheet 1  Change number as followed Page 5  Return to PowerPoint  Select the first slide which the bar chart has been pasted  Click anywhere in the bar chart  Right Click… Update Link  Be sure the bar chart is updated  Take a screen shot by clicking “PrtScn” on top right of keyboard  Crop the bar chart by using Paint program  Paste the bar chart in a third PPT slide Page 6 Page 7
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

See attached

Sales by Month

December

November

Month

October
Series4
Series3
Series2
September

Series1

August

July

-

1,000

2,000

3,000

4,000

5,000

Revenu...


Anonymous
Excellent resource! Really helped me get the gist of things.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4