{"id":1265,"date":"2017-07-07T16:36:10","date_gmt":"2017-07-07T16:36:10","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-compapp\/?post_type=chapter&#038;p=1265"},"modified":"2021-06-01T19:28:15","modified_gmt":"2021-06-01T19:28:15","slug":"assignment-organize-sales-data","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-compapp\/chapter\/assignment-organize-sales-data\/","title":{"raw":"Assignment: Organize Sales Data","rendered":"Assignment: Organize Sales Data"},"content":{"raw":"This assignment can be found in Google Docs:\u00a0<a href=\"https:\/\/docs.google.com\/document\/d\/1Vcq6unjp1mgcqo6nGbW8IOSRQORez8Iv6iuzLOTOK1Q\/edit\" target=\"_blank\" rel=\"noopener\">Business Communication Skills for Managers Assignment: Organize Sales Data<\/a>\r\n\r\nTo make your own copy to edit:\r\n<ul>\r\n \t<li><strong>If you want a Google Doc<\/strong>: in the file menu of the open document, click \u201cMake a copy.\u201d This will give you your own Google Doc to work from.<\/li>\r\n \t<li><strong>If you want a PDF or Word file<\/strong>: in the file menu of the open document, click \u201cDownload\u201d and select the file type you would like to have (note: depending on the file type you select, the formatting could get jumbled).<\/li>\r\n<\/ul>\r\n&nbsp;\r\n\r\nFor this assignment, you will manipulate an Excel worksheet to organize and display data about sales totals throughout a year.\r\n\r\nDownload <a href=\"https:\/\/s3.amazonaws.com\/lumenlearning\/success\/waymaker\/compapp\/Module+6+assignment.xlsx\">this Excel workbook<\/a>. It already contains the data you need.\u00a0<span class=\"s1\">Follow the directions, then submit your assignment. If you get stuck on a step, review this module and ask your classmates for help in the discussion forum.<\/span>\r\n<ol>\r\n \t<li>Open the workbook.\u00a0Save it to the Rowan folder on your desktop as <strong>BA132_LastName_SalesData.xlsx<\/strong>, replacing \"LastName\" with your own last name. (Example: BA132_Hywater_SalesData) It is a good idea to save your work periodically.<\/li>\r\n \t<li>Format the data as a table with the name of the months and sales total as headers. You may use any table style you like.\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163044\/organizingsalesdata1.png\"><img class=\"aligncenter wp-image-1266\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163044\/organizingsalesdata1.png\" alt=\"A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales.\" width=\"800\" height=\"598\" \/><\/a><\/li>\r\n \t<li>Change the cell format so that all the sales totals display as currency with a dollar sign and two decimal places.\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163207\/organizingsalesdata2.png\"><img class=\"aligncenter wp-image-1267\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163207\/organizingsalesdata2.png\" alt=\"A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales. All of column B has been formatted with dollar signs next to all of the numbers.\" width=\"800\" height=\"596\" \/><\/a><\/li>\r\n \t<li>Indicate that the data for June and October needs to be verified by applying a different cell style to those cells.\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163342\/organizingsalesdata3.png\"><img class=\"aligncenter wp-image-1268\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163342\/organizingsalesdata3.png\" alt=\"A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales. All of column B has been formatted with dollar signs next to all of the numbers. The data in cells B7 and B11 have been highlighted in gray.\" width=\"800\" height=\"597\" \/><\/a><\/li>\r\n \t<li>AutoFit the column width.\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163529\/organizingsalesdata4.png\"><img class=\"aligncenter wp-image-1269\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163529\/organizingsalesdata4.png\" alt=\"A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales. All of column B has been formatted with dollar signs next to all of the numbers. The data in cells B7 and B11 have been highlighted in gray. The auto fit column width has been applied.\" width=\"800\" height=\"596\" \/><\/a><\/li>\r\n \t<li>AutoSum the total sales for the year.<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163910\/organizingsalesdata5.png\"><img class=\"aligncenter wp-image-1273\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163910\/organizingsalesdata5.png\" alt=\"A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales. All of column B has been formatted with dollar signs next to all of the numbers. The data in cells B7 and B11 have been highlighted in gray. The auto fit column width has been applied. In cell B14 a new value has been opened displaying the total sales for the year.\" width=\"800\" height=\"596\" \/><\/a><\/li>\r\n \t<li>Save your work and submit the workbook in your course online.<\/li>\r\n<\/ol>","rendered":"<p>This assignment can be found in Google Docs:\u00a0<a href=\"https:\/\/docs.google.com\/document\/d\/1Vcq6unjp1mgcqo6nGbW8IOSRQORez8Iv6iuzLOTOK1Q\/edit\" target=\"_blank\" rel=\"noopener\">Business Communication Skills for Managers Assignment: Organize Sales Data<\/a><\/p>\n<p>To make your own copy to edit:<\/p>\n<ul>\n<li><strong>If you want a Google Doc<\/strong>: in the file menu of the open document, click \u201cMake a copy.\u201d This will give you your own Google Doc to work from.<\/li>\n<li><strong>If you want a PDF or Word file<\/strong>: in the file menu of the open document, click \u201cDownload\u201d and select the file type you would like to have (note: depending on the file type you select, the formatting could get jumbled).<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>For this assignment, you will manipulate an Excel worksheet to organize and display data about sales totals throughout a year.<\/p>\n<p>Download <a href=\"https:\/\/s3.amazonaws.com\/lumenlearning\/success\/waymaker\/compapp\/Module+6+assignment.xlsx\">this Excel workbook<\/a>. It already contains the data you need.\u00a0<span class=\"s1\">Follow the directions, then submit your assignment. If you get stuck on a step, review this module and ask your classmates for help in the discussion forum.<\/span><\/p>\n<ol>\n<li>Open the workbook.\u00a0Save it to the Rowan folder on your desktop as <strong>BA132_LastName_SalesData.xlsx<\/strong>, replacing &#8220;LastName&#8221; with your own last name. (Example: BA132_Hywater_SalesData) It is a good idea to save your work periodically.<\/li>\n<li>Format the data as a table with the name of the months and sales total as headers. You may use any table style you like.<br \/>\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163044\/organizingsalesdata1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1266\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163044\/organizingsalesdata1.png\" alt=\"A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales.\" width=\"800\" height=\"598\" \/><\/a><\/li>\n<li>Change the cell format so that all the sales totals display as currency with a dollar sign and two decimal places.<br \/>\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163207\/organizingsalesdata2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1267\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163207\/organizingsalesdata2.png\" alt=\"A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales. All of column B has been formatted with dollar signs next to all of the numbers.\" width=\"800\" height=\"596\" \/><\/a><\/li>\n<li>Indicate that the data for June and October needs to be verified by applying a different cell style to those cells.<br \/>\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163342\/organizingsalesdata3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1268\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163342\/organizingsalesdata3.png\" alt=\"A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales. All of column B has been formatted with dollar signs next to all of the numbers. The data in cells B7 and B11 have been highlighted in gray.\" width=\"800\" height=\"597\" \/><\/a><\/li>\n<li>AutoFit the column width.<br \/>\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163529\/organizingsalesdata4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1269\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163529\/organizingsalesdata4.png\" alt=\"A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales. All of column B has been formatted with dollar signs next to all of the numbers. The data in cells B7 and B11 have been highlighted in gray. The auto fit column width has been applied.\" width=\"800\" height=\"596\" \/><\/a><\/li>\n<li>AutoSum the total sales for the year.<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163910\/organizingsalesdata5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1273\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/07163910\/organizingsalesdata5.png\" alt=\"A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales. All of column B has been formatted with dollar signs next to all of the numbers. The data in cells B7 and B11 have been highlighted in gray. The auto fit column width has been applied. In cell B14 a new value has been opened displaying the total sales for the year.\" width=\"800\" height=\"596\" \/><\/a><\/li>\n<li>Save your work and submit the workbook in your course online.<\/li>\n<\/ol>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-1265\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Assignment: Organize Sales Data. <strong>Authored by<\/strong>: Shelli Carter. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":20,"menu_order":16,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Assignment: Organize Sales Data\",\"author\":\"Shelli Carter\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"578f4dad-8036-41a3-bfc4-828b4d7af8ca","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-1265","chapter","type-chapter","status-publish","hentry"],"part":975,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/chapters\/1265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/wp\/v2\/users\/20"}],"version-history":[{"count":14,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/chapters\/1265\/revisions"}],"predecessor-version":[{"id":2815,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/chapters\/1265\/revisions\/2815"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/parts\/975"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/chapters\/1265\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/wp\/v2\/media?parent=1265"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/chapter-type?post=1265"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/wp\/v2\/contributor?post=1265"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/wp\/v2\/license?post=1265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}