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
Save file after completing and submit work by attaching file to week 4 assignment submission area.
Grading Criteria Assignment
Maximum Points
Descriptive title, subtitle, and headings
10
Data included
10
Type, size, and price of each television included
10
Average function:
· cost of televisions
· cost of extended warranty
16
Sum function for television and extended warranty
8
Total results formatted as currency displaying $ symbols
5
Chart type appropriate for data it represents, and Chart title descriptive of contents
15
Sheet and Chart formatted and is easy to read
10
Part 2 questions answered
6
Filename CS155Week4lastnamefirstname
10
Override for incorrect file type, template used or incorrect content
100
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.