In this assignment, you apply Microsoft\u00ae Excel\u00ae formatting to a business example. You will use this skill to enter and analyze data using charts.\u00a0\u00a0\tAssignment Steps\u00a0 Resources:\u00a0\u00a0\t“\ufffdMicrosoft\u00ae Office Help and Training\u00a0\t“\ufffdOther tutorials available online\u00a0\t“\ufffdWeek 3 video: “Excel 2016 Essential Training”\u00a0\t\u00a0\t\u00a0Read the following business scenario:\u00a0\u00a0\t\u00a0\tYour company has asked you to create a spreadsheet to analyze the following data. The data will be reviewed for top salespeople bonuses and commissions payments based on individual sales. Averages will be used to analyze month-over-month sales throughout the years.\u00a0 Use the Sales Analysis Microsoft\u00ae Excel\u00ae spreadsheet and apply formatting to accomplish the following: “\ufffdCalculate total sales using the SUM function.\u00a0\t“\ufffdCalculate total sales for each quarter. (March, June, and September each represent a quarter.). A quarter is three months.\u00a0\t“\ufffdCalculate average sales for each quarter to help determine 4th-quarter potential sales.\u00a0 “\ufffdHighlight the top salesperson in each quarter.\u00a0\u00a0\t“\ufffdGenerate a Microsoft\u00ae Excel\u00ae chart or graph that displays the total sales by region to identify the highest and lowest selling regions.\u00a0\t“\ufffdInsert a hyperlink to the company’s web page. (You can use any business web page for this example.)\u00a0\t“\ufffdChange your spreadsheet to a page or print layout view to be sure it fits well on a printed 8.5″ x 11” sheet of paper.<\/p>\n","protected":false},"excerpt":{"rendered":"
In this assignment, you apply Microsoft\u00ae Excel\u00ae formatting to a business example. You will use this skill to enter and analyze data using charts.\u00a0\u00a0 Assignment Steps\u00a0 Resources:\u00a0\u00a0 “\ufffdMicrosoft\u00ae Office Help and Training\u00a0 “\ufffdOther tutorials available online\u00a0 “\ufffdWeek 3 video: “Excel Read More …<\/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-203042","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/203042","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=203042"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/203042\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=203042"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=203042"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=203042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}