Getting Started:

1) Download the Partially Completed Spreadsheet TVandPrinterComparision.xlsx

2) Download and open the four worddocuments with the TVs and Printers to compare

o TV1-2018VIZIOM-Series-65-Class.docx

o TV2-LG55Class4KHDRSmartLED.docx

o Printer1-HPOfficejet8040.docx

o Printer2-EPSON_Expression_Premium_XP-600.docx

3) Open the Spreadsheet to enter the data from the sales information for the TVs and the Printers

4) In the TV Tab

o 5pts Enter the data from TV 1 Vizio M56-F0

o 5pts Enter the data from TV 2 LG 55SK8000AUB

o Once Data Entry is complete

▪ 5pts Use Conditional Formatting>> Color Scale to highlight the price with the lowest value GREEN and the Highest RED

▪ 10pts Use Conditional Formatting>> Color Scale to highlight these with the Highest value GREEN and the Lowest RED

• Screen Size (inches)

• Refresh Rate (Hz)

• Output Power (Watts)

▪ 8pts Use Formulas to calculate the Min and Max values of:

• Price

• Screen Size (inches)

• Refresh Rate (Hz)

• Output Power (Watts)

▪ 2pts Format Price in Dollars

▪ 10pts Create two Graphs to display Screen Size (Inches) and Refresh Rate (Hz):

• Create a Column Chart for Screen Size (Inches)

o Hint: Create a chart with selected data and the header. After Chart is created you need to change Axis Label Names

• Create a Bar Chart for Refresh Rate (Hz)

5) Check and Save Your work

6) In the Printer Tab

o 5pts Enter the data from Printer 1 HP 8040

o 5pts Enter the data from Printer 2 Premium XP-600

o Once Data is complete

▪ 5pts Use Conditional Formatting>> Color Scale to highlight the price with the lowest value GREEN and the Highest RED

▪ 10pts Use Conditional Formatting>> Color Scale to highlight these with the Highest value GREEN and the Lowest RED

• Black Print Speed (ppm)

• Color Print Speed (ppm)

• Black Copy Speed (cpm)

• Color Copy Speed (cpm)

• Scan Resolution (DPI)

▪ 10pts Use Formulas to calculate the Min and Max values of:

• Black Print Speed (ppm)

• Color Print Speed (ppm)

• Black Copy Speed (cpm)

• Color Copy Speed (cpm)

• Scan Resolution (DPI)

▪ 10pts Create two Graphs to display Scan Resolution (DPI) and Print Speed (ppm)

• Create Column Chart for Scan Resolution (DPI)

o Hint: Create chart with selected data and header. After Chart is created you need to change Axis Label Names

• Create Column Chart for Color Print Speed (ppm)

7) Check and Save Your work

8) Save the Excel File as your_name_TV_Printer.xlsx

o Example: Jane_Doe_TV_Printer.xlsx.

9) 10pts After completing the Spreadsheets

• Create a Word Document as your_name_TV_Printer.docx

o Example: Jane_Doe_TV_Printer.docx

• Write a paragraph on which TV you would choose to buy and why

o What was the key term(s) that made the difference?

• Write a paragraph on which Printer you would choose to buy and why

o What was the key term(s) that made the difference?

• Save the File