{"id":45,"date":"2017-07-06T15:37:17","date_gmt":"2017-07-06T15:37:17","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/?post_type=chapter&#038;p=45"},"modified":"2017-07-06T18:21:18","modified_gmt":"2017-07-06T18:21:18","slug":"sales-tax-calculation-assignment","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/chapter\/sales-tax-calculation-assignment\/","title":{"raw":"Sales Tax Calculation Assignment","rendered":"Sales Tax Calculation Assignment"},"content":{"raw":"<h3>The purpose of his assignment is to:<\/h3>\r\nApply Absolute Referencing in a spreadsheet problem\r\n<h3>Preparation: (Items to review from previous lessons)<\/h3>\r\n<ul>\r\n \t<li>Entering data in cells<\/li>\r\n \t<li>Applying attributes (bold, underline)<\/li>\r\n \t<li>AutoSum<\/li>\r\n<\/ul>\r\n<h3>New Terms:<\/h3>\r\n<ul>\r\n \t<li>Absolute Referencing<\/li>\r\n<\/ul>\r\n<h3>Narrative:<\/h3>\r\nUnderstanding how to calculate using absolute referencing saves a great deal of time in inserting formulas. (THIS ASSIGNMENT IS WORTH 20 POINTS. THE RUBRIC IS ON PAGE 2)\r\n<ol>\r\n \t<li>Start a new spreadsheet<\/li>\r\n \t<li>Put your name in cell A1<\/li>\r\n \t<li>In cell A2, put the title: Accrue Sales Tax, and center it over the table.<\/li>\r\n \t<li>In cell G1 put the words Tax Rate<\/li>\r\n \t<li>In cell H1 put in 0.8612<\/li>\r\n \t<li>In cell B4 put in the heading Sales, and bold it.<\/li>\r\n \t<li>In cell C4 put the heading Sales Tax, and bold it<\/li>\r\n \t<li>In cell A5:A10 put in the words STORE 1 to STORE 6<\/li>\r\n \t<li>In cell A11 put in the word Total and bold it.<\/li>\r\n \t<li>In cells B5:B10 put in some sales amounts that are over between 40,000 to 100,000. Put different totals after each store.<\/li>\r\n \t<li>Absolute Referencing. (Be sure to have read Relative Referencing vs. Absolute Referencing) Starting in C5 insert a formula that uses the absolute reference of H1 and multiplies that to the total sales figure.<\/li>\r\n \t<li>In cell B11, sum column B. and sum Column C.<\/li>\r\n \t<li>Save the document as Sales Calculation<\/li>\r\n \t<li>Submit your document through Blackboard print at your instructor\u2019s suggestion.<\/li>\r\n<\/ol>\r\n<h3>Check the Rubric below to be sure you have completed all tasks.<\/h3>\r\n<img class=\"alignnone  wp-image-46\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/2159\/2017\/07\/06153529\/Screen-Shot-2017-07-06-at-8.35.04-AM-300x114.png\" alt=\"\" width=\"450\" height=\"171\" \/>","rendered":"<h3>The purpose of his assignment is to:<\/h3>\n<p>Apply Absolute Referencing in a spreadsheet problem<\/p>\n<h3>Preparation: (Items to review from previous lessons)<\/h3>\n<ul>\n<li>Entering data in cells<\/li>\n<li>Applying attributes (bold, underline)<\/li>\n<li>AutoSum<\/li>\n<\/ul>\n<h3>New Terms:<\/h3>\n<ul>\n<li>Absolute Referencing<\/li>\n<\/ul>\n<h3>Narrative:<\/h3>\n<p>Understanding how to calculate using absolute referencing saves a great deal of time in inserting formulas. (THIS ASSIGNMENT IS WORTH 20 POINTS. THE RUBRIC IS ON PAGE 2)<\/p>\n<ol>\n<li>Start a new spreadsheet<\/li>\n<li>Put your name in cell A1<\/li>\n<li>In cell A2, put the title: Accrue Sales Tax, and center it over the table.<\/li>\n<li>In cell G1 put the words Tax Rate<\/li>\n<li>In cell H1 put in 0.8612<\/li>\n<li>In cell B4 put in the heading Sales, and bold it.<\/li>\n<li>In cell C4 put the heading Sales Tax, and bold it<\/li>\n<li>In cell A5:A10 put in the words STORE 1 to STORE 6<\/li>\n<li>In cell A11 put in the word Total and bold it.<\/li>\n<li>In cells B5:B10 put in some sales amounts that are over between 40,000 to 100,000. Put different totals after each store.<\/li>\n<li>Absolute Referencing. (Be sure to have read Relative Referencing vs. Absolute Referencing) Starting in C5 insert a formula that uses the absolute reference of H1 and multiplies that to the total sales figure.<\/li>\n<li>In cell B11, sum column B. and sum Column C.<\/li>\n<li>Save the document as Sales Calculation<\/li>\n<li>Submit your document through Blackboard print at your instructor\u2019s suggestion.<\/li>\n<\/ol>\n<h3>Check the Rubric below to be sure you have completed all tasks.<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-46\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/2159\/2017\/07\/06153529\/Screen-Shot-2017-07-06-at-8.35.04-AM-300x114.png\" alt=\"\" width=\"450\" height=\"171\" \/><\/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-45\">\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>Sales Calculation 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":9,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Sales Calculation 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-45","chapter","type-chapter","status-publish","hentry"],"part":144,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/chapters\/45","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\/45\/revisions"}],"predecessor-version":[{"id":47,"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/chapters\/45\/revisions\/47"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/parts\/144"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/chapters\/45\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/wp\/v2\/media?parent=45"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/pressbooks\/v2\/chapter-type?post=45"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/wp\/v2\/contributor?post=45"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/wp-json\/wp\/v2\/license?post=45"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}