I don’t know how to handle this Html / CSS question and need guidance.
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
