{"id":17796,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/excel-assignment-instructions"},"modified":"2017-06-05T17:05:52","modified_gmt":"2017-06-05T17:05:52","slug":"excel-assignment-instructions","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/excel-assignment-instructions\/","title":{"rendered":"Excel Assignment Instructions &#8211;"},"content":{"rendered":"<p>Excel Assignment Instructions &#8211;<\/p>\n<p>Sheet 1<br \/>\nA. Open the Excel Workbook found with these instructions in \u201cExcel Assignment\u201d in Topic 3.<br \/>\nB. Type your first and last name in cell A1.<br \/>\nC. Type \u201cUNV-504\u201d in cell A2.<br \/>\nD. Type \u201cTopic 3 Excel Assignment\u201d in cell A3.<br \/>\nE. Activate the Data Analysis Add-in.<br \/>\na. Use the \u201cActivating the Data Analysis Add-in\u201d video link in cell B6 of the Excel Tutorial Links from the Topic 3 Materials for help with these steps.<br \/>\nF. Double click Sheet 1 in the bottom left corner and rename Sheet 1 as \u201cTitle Sheet.\u201d<br \/>\nSheet 2<br \/>\nA. Open Sheet 2 by clicking the Sheet 2 tab at the bottom of the Excel Workbook.<br \/>\nB. In cell D1 type \u201cTotal Unit Sales.\u201d<br \/>\nC. Using the basic calculation functionality of Excel, find the total unit sales (Price per unit time the units sold) for each product. Do not use a separate calculator to find the results. Include the result in column D.<br \/>\na. Use the \u201cBasic Calculations\u201d video link in cell B10 of the Excel Tutorial Links from the Topic 3 Materials for help with these steps.<br \/>\nD. Type \u201cAverage\u201d in cell A12.<br \/>\nE. In cell B12, insert a function to find the average price per unit.<br \/>\na. For help with this, view the Basic Functions tutorial video in cell B11 of the Excel Tutorial Links from the Topic 3 Materials.<br \/>\nF. In cell C12, insert a function to find the average number of units sold.<br \/>\nG. Change the price per unit of weed spray to $26.06.<br \/>\nH. Change the plastic buckets units sold to 359.<br \/>\nI. Type Total Sales in cell F4.<br \/>\nJ. Insert a function in cell G4 for the sum of all Total Unit Sales.<br \/>\nK. Rename Sheet2 \u201cGarden Store.\u201d<br \/>\nSheet 3<br \/>\nA. Create a Pie Chart using the data in columns D and E.<br \/>\nB. Add data labels so that each slice of the pie shows the corresponding percentage and instrument family.<br \/>\na. Use the \u201cPie Chart Labeling Data\u201d video link in cell B15 of the Excel Tutorial Links from the Topic 3 Materials for help with these steps.<br \/>\nC. Rename Sheet3 \u201cSymphony.\u201d<\/p>\n<p>Sheet 4<br \/>\nA. Create a line graph for Northeast Sales and Southeast Sales using the data provided.<br \/>\nB. Create a second line graph for Northwest Sales and Southwest Sales using the data provided.<br \/>\na. Refer to the \u201cLine Graph\u201d video link in cell B16 of the Excel Tutorial Links from the Topic 3 Materials for help with this step.<br \/>\nC. Rename Sheet4 \u201cDivision Sales.\u201d<\/p>\n<p>Sheet 5<br \/>\nA. Create a scatter plot using the data provided.<br \/>\na. Refer to the \u201cXY Scatterplot\u201d video link in cell B17 of the Excel Tutorial Links from the Topic 3 Materials for help with this step.<br \/>\nB. Label Sheet5 \u201cDrinks.\u201d<\/p>\n<p>Sheet 6<br \/>\nA. Create a new tab.<br \/>\na. Click the \u201cUse of Tabs\u201d resource video link in cell B5 of the Excel Tutorial Links from the Topic 3 Materials for help with these steps.<br \/>\nB. In cell A1 type the most challenging part of this assignment.<br \/>\nC. In cell A2 write something new that you learned.<br \/>\nD. Label Sheet6 \u201cLast.\u201d<br \/>\nE. Save the Excel Workbook and upload to your Topic 3 Excel Assignment drop box.<\/p>\n<p>&lt;tableborder=&#8221;0&#8243; cellpadding=&#8221;0&#8243; cellspacing=&#8221;0&#8243; width=&#8221;370&#8243; style=&#8221;font-family: Verdana, arial, sans-serif; line-height: normal; border-collapse: collapse; width: 278pt;&#8221;&gt;Product Price per unit Units sold Lawn mower $ 230.27 179 Rake $ 17.90 413 Shovel $ 31.31 1136 Garden hose $ 24.99 267 Weed spray $ 25.84 1025 Hedge trimmers $ 50.75 842 Pruners $ 28.44 354 Sprinkler $ 19.99 571 Plastic Bucket $ 8.64 953 Gloves $ 7.50 2641<br \/>\n&lt;tableborder=&#8221;0&#8243; cellpadding=&#8221;0&#8243; cellspacing=&#8221;0&#8243; width=&#8221;370&#8243; style=&#8221;font-family: Verdana, arial, sans-serif; line-height: normal; border-collapse: collapse; width: 278pt;&#8221;&gt;<br \/>\nInstrument Number of musicians Instrument Family Number of Musicians<br \/>\nViolin 12 Brass 14<br \/>\nViola 10 Percussion 7<br \/>\nCello 9 Strings 34<br \/>\nDouble bass 3 Woodwinds 12<br \/>\nTrumpet 3<br \/>\nTuba 4<br \/>\nTrombone 4<br \/>\nFrench Horn 3<br \/>\nBassoon 3<br \/>\nFlute 2<br \/>\nClarinet 4<br \/>\nOboe 3<br \/>\nPercussion 7<\/p>\n<p>Division January February March April May June July August September October November December<br \/>\nNortheast Sales 75 105 100 90 121 105 89 36 105 114 67 97<br \/>\nSoutheast Sales 72 95 101 27 98 87 93 97 107 115 59 101<br \/>\nCentral Sales 63 22 105 99 107 104 91 92 109 107 81 87<br \/>\nNorthwest Sales 54 62 80 85 93 82 105 110 14 115 92 94<br \/>\nSouthwest Sales 84 88 95 93 63 97 107 111 110 112 97 89<\/p>\n<p>Temperature Soft drinks sold<br \/>\n96-105 194<br \/>\n86-95 185<br \/>\n76-85 210<br \/>\n66-75 205<br \/>\n56-65 175<br \/>\n46-55 120<br \/>\n36-45 110<br \/>\n26-35 107<br \/>\n16-25 100<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel Assignment Instructions &#8211; Sheet 1 A. Open the Excel Workbook found with these instructions in \u201cExcel Assignment\u201d in Topic 3. B. Type your first and last name in cell A1. C. Type \u201cUNV-504\u201d in cell A2. D. Type \u201cTopic <a href=\"https:\/\/www.benedictsol.com\/blogs\/excel-assignment-instructions\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-17796","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/17796","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=17796"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/17796\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=17796"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=17796"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=17796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}