\n Computer Applications for Business \u2013 Week 4 Assignment\n <\/p>\n
\n MS Excel: Comparing Televisions\n <\/p>\n
\n Start with a new spreadsheet in Microsoft Excel online or installed version of Microsoft Excel with no template applied. A template is not allowed for assignment.\n <\/p>\n
\n NOTE:\u00a0\u00a0You will not need to use files from the textbook for the assignment\n <\/p>\n
\n Apply your creative thinking and problem-solving skills to design and implement a solution.\n <\/p>\n
\n Part 1:\n <\/p>\n
\n You are shopping for a new television and want to compare the prices of three televisions. Research new televisions.\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Create a worksheet that compares the type, size, and the price for each television, as well as the costs to add an extended warranty.\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Use the concepts and techniques presented in this Excel module 1 to calculate the average price of a television and average cost of an extended warranty and to format the worksheet.\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Include a chart to compare the different television costs.\n <\/p>\n
\n Part 2:\n <\/p>\n
\n Based upon the data you found, how could you chart the information to show the comparisons? Which chart would be the best to use?\u00a0Answer these questions in\u00a0comments or submission text area when submitting..\n <\/p>\n
\n Save the file as CS155Week4lastnamefirstname. Ensure that you use\u00a0your\u00a0lastname\u00a0and\u00a0firstname\u00a0in the filename.\n <\/p>\n
\n The following areas will be part of grading criteria:\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Descriptive title, subtitle, and headings\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Data included\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Type, size, and price of each television included\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Average function used to average price of televisions\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Average function used to average cost of extended warranty\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Total for television and extended warranty for each using sum function\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Total results formatted as currency displaying $ symbols\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Sheet formatted\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Columns adjusted so that text is not cut off, and excess space is minimized\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Chart type appropriate for data it represents\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Chart title is descriptive of contents\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Chart formatted so that data makes sense and is easy to read\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Part 2 questions answered\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Correct filename\n <\/p>\n
\n Hide\n <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Computer Applications for Business \u2013 Week 4 Assignment MS Excel: Comparing Televisions Start with a new spreadsheet in Microsoft Excel online or installed version of Microsoft Excel with no template applied. A template is not allowed for assignment. NOTE:\u00a0\u00a0You will not need to use files from the textbook for the assignment Apply your creative thinking […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/247080"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=247080"}],"version-history":[{"count":1,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/247080\/revisions"}],"predecessor-version":[{"id":250779,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/247080\/revisions\/250779"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=247080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=247080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=247080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}