UNV 504 Week 3 Excel Assignment Instructions
UNV 504 Week 3 Excel Assignment
Instructions
Complete the Excel Worksheet
assignment using the “Excel Worksheet Instructions” and “Excel Worksheet.”
You are not required to submit this
assignment to Turnitin.
Sheet 1
- Open the Excel Worksheet found with these instructions
in “Excel Assignment” in Topic 3.
- Type your first and last name in cell A1.
- Type “UNV-504” in cell A2.
- Type “Topic 3 Excel Assignment” in cell A3.
- Double click Sheet 1 in the bottom left corner and
rename Sheet 1 as “Title Sheet.”
Sheet 2
- 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.
- Use the “Basic Calculations” video link in cell B10 of
the Excel Tutorial Links from the Topic 3 Materials for help with these
steps.
- Type “Average” in cell A12.
- In cell B12, insert a function to find the average
price per unit.
- For help with this, view the “Basic Functions” video
link in cell B11 of the Excel Tutorial Links from the Topic 3 Materials.
- 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
- 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.
- Use the “Pie Chart Labeling Data” video link in cell
B15 of the Excel Tutorial Links from the Topic 3 Materials for help with
these steps.
- Rename Sheet 3 “Symphony.”
Sheet 4
- 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.
- Refer to the “Line Graph” video link in cell B16 of the
Excel Tutorial Links from the Topic 3 Materials for help with this step.
- Rename Sheet 4 “Division Sales.”
Sheet 5
- Create a scatterplot using the data provided.
- Refer to the “XY Scatterplot” video link in cell B17 of
the Excel Tutorial Links from the Topic 3 Materials for help with this
step.
- Label the X-Axis “Attendance” and the Y-Axis “Soft
Drink Sold.”
- Label Sheet 5 “Drinks.”
Sheet 6
- Create a new tab.
- Click the “Use of Tabs” video link in cell B5 of the
Excel Tutorial Links from the Topic 3 Materials for help with these steps.
- In cell A1, type the most challenging part of this
assignment.
- In cell A2, write something new that you learned.
- Label Sheet 6 “Last.”
- Save the Excel Workbook and upload to your Topic 3
Excel Assignment drop box.
Comments
Post a Comment