Skip to main content

You are shopping for a new television and want to compare the prices of three televisions.

 Computer Applications for Business – 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:  You will not need to use files from the textbook for the assignment

Apply your creative thinking and problem-solving skills to design and implement a solution.

Part 1:

You are shopping for a new television and want to compare the prices of three televisions. Research new televisions.

·         Create a worksheet that compares the type, size, and the price for each television, as well as the costs to add an extended warranty.

·         Use 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.

·         Include a chart to compare the different television costs.

Part 2:

Based upon the data you found, how could you chart the information to show the comparisons? Which chart would be the best to use? Answer these questions in comments or submission text area when submitting..

Save the file as CS155Week4lastnamefirstname. Ensure that you use your lastname and firstname in the filename.

The following areas will be part of grading criteria:

·         Descriptive title, subtitle, and headings

·         Data included

·         Type, size, and price of each television included

·         Average function used to average price of televisions

·         Average function used to average cost of extended warranty

·         Total for television and extended warranty for each using sum function

·         Total results formatted as currency displaying $ symbols

·         Sheet formatted

·         Columns adjusted so that text is not cut off, and excess space is minimized

·         Chart type appropriate for data it represents

·         Chart title is descriptive of contents

·         Chart formatted so that data makes sense and is easy to read

·         Part 2 questions answered

·         Correct filename

WE HAVE DONE THIS ASSIGNMENT BEFORE, WE CAN ALSO DO IT FOR YOU

GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

CLICK HERE TO MAKE YOUR ORDER on You are shopping for a new television and want to compare the prices of three televisions.

Are You looking for Assignment and Homework Writing help? We Provide High-Quality Academic Papers at Affordable Rates. No Plagiarism.

TO BE RE-WRITTEN FROM THE SCRATCH

Comments

Post a Comment

Popular posts from this blog

Identify and discuss a key milestone in the history of computers that interests you and why.

  Part 1Title: Lab ResponseDiscuss one feature of MS Word and one feature of MS Excel that you found challenging within the lab and why. Examples are WordArt, inserting shapes, adding borders, cell styles, etc. This response should be at least one paragraph in length. Part 2Title: History of Computers Identify and discuss a key milestone in the history of computers that interests you and why. This section should be at least one paragraph. Part 3Title: System Software vs. Application Software In your words, explain the difference between application software and system software as if to another coworker who has limited technical knowledge. Use examples to support your rationalization. This section should be at least two paragraphs. Part 4Title: Blockchain and Cryptocurrency In a minimum of one paragraph each: 1. Conduct some research on the internet and discuss one underlying technology of cryptocurrencies like blockchain, cryptography, distributed ledger technol...
Post a Comment
Read more

Cybersecurity and Infrastructure Security (CISA)

 Develop a research paper that identifies a specific Department of Homeland Security (DHS) operating agency. Fully describe 1 DHS operating agency from the following list: Cybersecurity and Infrastructure Security (CISA) U.S. Customs and Border Protection (CBP) U.S. Citizenship and Immigration Services (USCIS) Federal Emergency Management Agency (FEMA) U.S. Coast Guard (USCG) U.S. Immigration and Customs Enforcement (ICE) U.S. Secret Service (USSS) Transportation Security Administration (TSA) The information must include a discussion of the selected DHS agency. Identify the agency’s mission, goals, objectives, and metrics. Conduct an analysis of how these mission areas address the threats or challenges. Recommend agency program priorities among the current set of goals, objectives, metrics, or budget items. Justification of all choices is an essential element of this assignment. Reference all source material and citations using APA format. WE OFF...
Post a Comment
Read more

Discuss how the project

ord count : no idea 1. You are required to write a report on all project activities involved in all the 10 knowledge areas of project management for the entire project life cycle. You should also include a list of the respective PM documents, for example PM Plan, PM Quality Management Plan, Risk management, Procurement, etc. The report must include the activities that are considered before the project is closed out. 2. Discuss how the project quality management plan can provide adequate standards and controls in managing global teams in projects. Your discussion must provide adequate arguments for the need of cultural awareness and legal issues. Regards, The post Discuss how the project appeared first on My Assignment Tutor . Assignment status :  Resolved by our Writing Team Source@ PrimeWritersBay.com GET THIS PAPER COMPLETED FOR YOU FROM THE WRITING EXPERTS   CLICK HERE TO ORDER 100% ORIGINAL PAPERS AT PrimeWritersBay.com NO PLAGIARISM
Post a Comment
Read more