14 Apr Excel Worksheet
Download and review the “Excel Worksheet” found directly below the assignment instructions under “Attachments” for the data sets required to complete this assignment. Note: You must download this “Excel Worksheet,” not just view it in your browser, in order to see all of the required data sets.
Sheet 1
1. Type your Farid Faraj in cell A1.
2. Type “UNV-504” in cell A2.
3. Type “Topic 3 Excel Assignment” in cell A3.
4. Double click Sheet 1 in the bottom left corner and rename Sheet 1 as “Title Sheet.”
Sheet 2
(Review “Excel Formulas and Functions Tutorial,” located in the topic Resources.)
· Open Sheet 2 by clicking the Sheet 2 tab at the bottom of the Excel Workbook.
· In cell D1, type “Total Unit Sales.”
· Using the basic calculation functionality of Excel, find the total unit sales (Price per Unit times the Units Sold) for each product. Do not use a separate calculator to find the results. Include the result in column D.
· Type “Average” in cell A12.
· In cell B12, insert a function to find the average price per unit.
· In cell C12, insert a function to find the average number of units sold.
· Change the price per unit of weed spray to $26.06.
· Change the plastic buckets units sold to 359.
· Type Total Sales in cell F4.
· Insert a function in cell G4 for the sum of all Total Unit Sales.
· Rename Sheet 2 “Garden Store.”
Sheet 3
(Review “How to Create a Pie Chart in Excel (With Percentages),” located in the topic Resources.)
· Create a pie chart using the data in columns D and E.
· Add data labels so that each slice of the pie shows the corresponding percentage and instrument family.
· Rename Sheet 3 “Symphony.”
Sheet 4
(Review “How to Make a Line Graph on Excel,” located in the topic Resources.)
· Create a line graph for Northeast Sales and Southeast Sales using the data provided.
· Create a second line graph for Northwest Sales and Southwest Sales using the data provided.
· Rename Sheet 4 “Division Sales.”
Sheet 5
(Review “How to Make a Scatter Graph/Plot in Microsoft Excel (Scatter Graph Tutorial),” located in the topic Resources.)
· Create a scatterplot using the data provided.
· Label the X-Axis “Attendance” and the Y-Axis “Soft Drink Sold.”
· Label Sheet 5 “Drinks.”
Sheet 6
(Review “How to Rename a Worksheet in Microsoft Excel,” located in the topic Resources.)
· Create a new tab.
· In cell A1, type the most challenging part of this assignment.
· In cell A2, write something new that you learned.
· Label Sheet 6 “Last.”
