{"id":100,"date":"2017-07-06T17:35:27","date_gmt":"2017-07-06T17:35:27","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/?post_type=chapter&#038;p=100"},"modified":"2017-07-06T18:20:27","modified_gmt":"2017-07-06T18:20:27","slug":"ford-sales-assignment","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/chapter\/ford-sales-assignment\/","title":{"raw":"Ford Sales Assignment","rendered":"Ford Sales Assignment"},"content":{"raw":"<h3>The purpose of this assignment is to:<\/h3>\r\n1. Finish compiling a report\r\n\r\n2. Apply centering title\r\n\r\n3. Create two simple column charts\r\n\r\n4. Make changes to those charts\r\n\r\n5. Apply Currency to specific rows\r\n<h3>Preparation: (Review of Terms)<\/h3>\r\n<ul>\r\n \t<li>SUM and AVE function<\/li>\r\n \t<li>Merge and Center titles<\/li>\r\n \t<li>Apply Currency to specific rows<\/li>\r\n \t<li>Adjust column width<\/li>\r\n \t<li>Change a legend<\/li>\r\n \t<li>Create a Pie Chart<\/li>\r\n \t<li>Create a 3D Cluster Column Chart<\/li>\r\n<\/ul>\r\n<h3>New Terms: (Terms bolded in the steps)<\/h3>\r\n<ul>\r\n \t<li>Chart Elements: Horizontal Axis Title (Step #13, Page 2 )<\/li>\r\n \t<li>Select two columns that are not adjacent to each other. (Step #15, Page 2)<\/li>\r\n \t<li>Changing Chart Style (Step #16, Page 2)<\/li>\r\n<\/ul>\r\n<h3>Narrative:<\/h3>\r\nThis assignment is much shorter Working with a Pie Chart, other attributes are introduced to show the versatility of charts. (THIS ASSIGNMENT IS WORTH 20 POINTS. THE RUBRIC IS ON PAGE 3.)\r\n\r\nAssignment:\r\n\r\n1. Open Ford Motor Company spreadsheet and save it as Ford Sales.\r\n\r\n2. Center the title, bold it and increase the size to 18 pt.\r\n\r\n3. Center the subtitle, bold it and increase the size to 14 pt.\r\n\r\n4. Bold all the Quarter headers and the makes of each Ford car.\r\n\r\n5. Adjust the columns to see all the information.\r\n\r\n6. Bold the word TOTAL in column A.\r\n\r\n7. Complete the worksheet using formulas for the totals and average.\r\n\r\n8. Insert dollar signs with two decimal places on all totals and averages, but not on the individual quarter sales.\r\n\r\n9. Enter your name in cell A25.\r\n\r\n10. Create a 3-D Clustered Column chart showing the quarterly sales for each car by selecting cells A3 \u2013 E7 to include the car names and the quarter headings.[Hint- Insert tab, Charts group, Column drop-down list, 3-D Clustered Column]\r\n\r\n11. Move and size the chart to display in cells A10 \u2013 A23\r\n\r\n12. Change the position of the Legend to the top. [Hint, Chart Tools, Design, Add Chart Elements, Legend]\r\n\r\n13. Add Chart Elements: Horizontal Axis Title to state Sales By Ford.\r\n\r\n14. Add a Title: Ford Motor Company.\r\n\r\n15. Select two columns that are not adjacent to each other\r\n<ul>\r\n \t<li>Select A4 to A7. Hold down the CTRL key and select G4-G7. Two separate columns are selected.<\/li>\r\n \t<li>Select 3-D Pie.<\/li>\r\n<\/ul>\r\n16. Changing a chart style. From the Chart Tools, Select Design and view the Chart Styles. Choose the third option that will have percentages on the wedges. (See example below)\r\n\r\n17. Move this chart to about F10- F23.\r\n\r\n18. Change orientation to Landscape.\r\n\r\n19. Again save your work as Ford Sales.\r\n\r\n20. Submit through Blackboard.\r\n\r\n21. If not on Blackboard, follow instructor\u2019s submitting directions.\r\n\r\n<img class=\"alignnone  wp-image-101\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/2159\/2017\/07\/06173349\/Screen-Shot-2017-07-06-at-10.33.28-AM.png\" alt=\"\" width=\"444\" height=\"278\" \/>\r\n<h3>Check the rubric below to be sure you have completed all the tasks.<\/h3>\r\n<img class=\"alignnone  wp-image-102\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/2159\/2017\/07\/06173456\/Screen-Shot-2017-07-06-at-10.34.34-AM-300x176.png\" alt=\"\" width=\"523\" height=\"307\" \/>","rendered":"<h3>The purpose of this assignment is to:<\/h3>\n<p>1. Finish compiling a report<\/p>\n<p>2. Apply centering title<\/p>\n<p>3. Create two simple column charts<\/p>\n<p>4. Make changes to those charts<\/p>\n<p>5. Apply Currency to specific rows<\/p>\n<h3>Preparation: (Review of Terms)<\/h3>\n<ul>\n<li>SUM and AVE function<\/li>\n<li>Merge and Center titles<\/li>\n<li>Apply Currency to specific rows<\/li>\n<li>Adjust column width<\/li>\n<li>Change a legend<\/li>\n<li>Create a Pie Chart<\/li>\n<li>Create a 3D Cluster Column Chart<\/li>\n<\/ul>\n<h3>New Terms: (Terms bolded in the steps)<\/h3>\n<ul>\n<li>Chart Elements: Horizontal Axis Title (Step #13, Page 2 )<\/li>\n<li>Select two columns that are not adjacent to each other. (Step #15, Page 2)<\/li>\n<li>Changing Chart Style (Step #16, Page 2)<\/li>\n<\/ul>\n<h3>Narrative:<\/h3>\n<p>This assignment is much shorter Working with a Pie Chart, other attributes are introduced to show the versatility of charts. (THIS ASSIGNMENT IS WORTH 20 POINTS. THE RUBRIC IS ON PAGE 3.)<\/p>\n<p>Assignment:<\/p>\n<p>1. Open Ford Motor Company spreadsheet and save it as Ford Sales.<\/p>\n<p>2. Center the title, bold it and increase the size to 18 pt.<\/p>\n<p>3. Center the subtitle, bold it and increase the size to 14 pt.<\/p>\n<p>4. Bold all the Quarter headers and the makes of each Ford car.<\/p>\n<p>5. Adjust the columns to see all the information.<\/p>\n<p>6. Bold the word TOTAL in column A.<\/p>\n<p>7. Complete the worksheet using formulas for the totals and average.<\/p>\n<p>8. Insert dollar signs with two decimal places on all totals and averages, but not on the individual quarter sales.<\/p>\n<p>9. Enter your name in cell A25.<\/p>\n<p>10. Create a 3-D Clustered Column chart showing the quarterly sales for each car by selecting cells A3 \u2013 E7 to include the car names and the quarter headings.[Hint- Insert tab, Charts group, Column drop-down list, 3-D Clustered Column]<\/p>\n<p>11. Move and size the chart to display in cells A10 \u2013 A23<\/p>\n<p>12. Change the position of the Legend to the top. [Hint, Chart Tools, Design, Add Chart Elements, Legend]<\/p>\n<p>13. Add Chart Elements: Horizontal Axis Title to state Sales By Ford.<\/p>\n<p>14. Add a Title: Ford Motor Company.<\/p>\n<p>15. Select two columns that are not adjacent to each other<\/p>\n<ul>\n<li>Select A4 to A7. Hold down the CTRL key and select G4-G7. Two separate columns are selected.<\/li>\n<li>Select 3-D Pie.<\/li>\n<\/ul>\n<p>16. Changing a chart style. From the Chart Tools, Select Design and view the Chart Styles. Choose the third option that will have percentages on the wedges. (See example below)<\/p>\n<p>17. Move this chart to about F10- F23.<\/p>\n<p>18. Change orientation to Landscape.<\/p>\n<p>19. Again save your work as Ford Sales.<\/p>\n<p>20. Submit through Blackboard.<\/p>\n<p>21. If not on Blackboard, follow instructor\u2019s submitting directions.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-101\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/2159\/2017\/07\/06173349\/Screen-Shot-2017-07-06-at-10.33.28-AM.png\" alt=\"\" width=\"444\" height=\"278\" \/><\/p>\n<h3>Check the rubric below to be sure you have completed all the tasks.<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-102\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/2159\/2017\/07\/06173456\/Screen-Shot-2017-07-06-at-10.34.34-AM-300x176.png\" alt=\"\" width=\"523\" height=\"307\" \/><\/p>\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-100\">\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>Ford Sales Assignment. <strong>Authored by<\/strong>: Fran Wells. <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":23590,"menu_order":4,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Ford Sales Assignment\",\"author\":\"Fran Wells\",\"organization\":\"\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-100","chapter","type-chapter","status-publish","hentry"],"part":146,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/chapters\/100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/wp\/v2\/users\/23590"}],"version-history":[{"count":1,"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/chapters\/100\/revisions"}],"predecessor-version":[{"id":103,"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/chapters\/100\/revisions\/103"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/parts\/146"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/chapters\/100\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/wp\/v2\/media?parent=100"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/chapter-type?post=100"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/wp\/v2\/contributor?post=100"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/wp\/v2\/license?post=100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}