Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please solve using excel and provide formulas used in cells Problem 5.2 Conditional Formatting Step 1: In worksheet Part2 there is a list of salespersons
Please solve using excel and provide formulas used in cells
Problem 5.2 Conditional Formatting Step 1: In worksheet Part2" there is a list of salespersons and their quarterly output. You are to highlight cells using conditional formatting according to the rules below: (15 points) i) Below $500 Red Cell with Red Writing ii) Between $500 and $3,000 - White Cell with Blue Writing iii) Above $3,000 Green Cell with Green Writing Step 2: There is also a column for when each person turned in their sales report. You are to use conditional formatting such that if the user turned in their report after 12/17/2020 a red icon is placed in the cell, and if they turned it in on or before a green icon is placed in that cell. (10 points) Name Q2 Below 500 High 3000 Due Date 12/17/20 958.00 139.005 3,430.00 542.00 Longenecker, Sean Desai, Christopher Matthews, Rachel Dodds, Westley Wadsworth, Lydia Rosene, Jacob Walton, Erin Wadsworth, Jeffrey Matthews, Aaron Barmer, Qian Dodds, Lindsey Goldberg, William Yang, Kalene Blum, Elizabeth Kelly, Kali Goldfarb, Benjamin knizner, Michael Walton. Jazmine Weddington, Eric Badgett, Joseph Barksdale, Brian Falsy, Rigsbee Goldberg, Benjamin Folk. Christopher Dodds, Ashley Zhao, Zachary Williams, Jace Zhao, Shane Barclay, Alicia Lloyd, Christopher Davis, Chad Folk, Paul Badgett, Max Khader, Maile Q1 $ 2,357.00 $ 2,807.00 $ 2,551.00 1$ 153.00 1 $ 1,211.00 $ 109.00 $ 283.00 $ 1,344.00 $ 2,757.00 $ 2,221.00 $ 2,092.00 $ 672.00 | $ 3,737.00 $ 958.00 $ 1,669.00 $ 594.00 $ 833.00 1$ 3,062.00 $ 190.00 $ 2,034.00 $ 1,201.00 $ 291.00 $ 756.00 $ 3.278.00 $ 2,008.00 $ 173.00 $ 3,345.00 $ 1,435.00 $ 1,803.00 | $ 1,093.00 $ 2,896.00 $ 959.00 $ 3,059.00 $ 3,558.00 Q3 Q4 $ 387.00 $ 2,734.00 $ 732.00 $ 3,978.00 $ 255.00 / $ 2,335.00 $ 1,144.00 $ 1,802.00 $ 1,634.00 $ 2,897.00 $ 1,750.00 $ 1,129.00 $ 678.00 $ 3,784.00 $ 1,789.00 $ 3,174.00 $ 167.00 $ 3,614.00 $ 953.00 $ 3,937.00 $ 1,018.00 $ 440.00 $ 3,168.00 $ 2,679.00 $ 987.00 $ 395.00 $ 3,638.00 $ 2,258.00 $ 1,186.00 $ 956.00 $ 1,649.00 $ 3,551.00 $ 845.00 $ 465.00 $ 2,084.00 $ 1,916.00 $ 395.00 $ 2,314.00 $ 2,475.00 $ 128.00 $ 3,112.00 $ 3,314.00 $ 839.00 $ 3,480.00 $ 441.00 $ 3,226.00 $ 1,470.00 $ 54.00 $ 3,206.00 $ 3,047.00 $ 3,082.00 $ 1,611.00 $ 643.00 $ 2.929.00 $ 1,453.00 $ 379.00 $ 984.00 | $ 2,672.00 $ 645.00$ 3,612.00 $ 1,426.00 $ 1,909.00 $ 3,431.00 $ 1,523.00 $ 543.00 $ 3,170.00 $ 1,929.00 $ 2,817.00 $ 1,447.00 $ 237.00 $ 3.153.00 $ 1.643.00 $ 654.00 $ 1,767.00 $ 2,011.00 $ 3,924.00 $ 3,152.00 $ 2,571.00 $ 3,112.00 $ 2,875.00 $ 351.00 $ 3,861.00 $ 3,790.00 $ 1,081.00 $ 1,302.00 $ 1,420.00 $ 2,531.00 $ 967.00 $ 2,577.00 $ 2,557.00 $ 3,447.00 $ 2,524.00 $ 992.00 $ 1,486.00 $ 2,189.00 $ 3,666.00 $ 3,761.00 $ 2,358.00 $ 2,146.00 $ 1,279.00 $ 3,503.00 $ 3,409.00 Date Report Turned In 12/17/20 12/21/20 12/4/20 12/2/20 12/29/20 12/25/20 12/13/20 12/2/20 12/2/20 12/12/20 12/15/20 12/30/20 12/31/20 12/31/20 12/5/20 12/27/20 12/26/20 12/29/20 12/31/20 12/15/20 12/2/20 12/13/20 12/30/20 12/8/20 12/27/20 12/1/20 12/20/20 12/21/20 12/9/20 12/13/20 12/1/20 12/24/20 12/17/20 12/12/20 Problem 5.2 Conditional Formatting Step 1: In worksheet Part2" there is a list of salespersons and their quarterly output. You are to highlight cells using conditional formatting according to the rules below: (15 points) i) Below $500 Red Cell with Red Writing ii) Between $500 and $3,000 - White Cell with Blue Writing iii) Above $3,000 Green Cell with Green Writing Step 2: There is also a column for when each person turned in their sales report. You are to use conditional formatting such that if the user turned in their report after 12/17/2020 a red icon is placed in the cell, and if they turned it in on or before a green icon is placed in that cell. (10 points) Name Q2 Below 500 High 3000 Due Date 12/17/20 958.00 139.005 3,430.00 542.00 Longenecker, Sean Desai, Christopher Matthews, Rachel Dodds, Westley Wadsworth, Lydia Rosene, Jacob Walton, Erin Wadsworth, Jeffrey Matthews, Aaron Barmer, Qian Dodds, Lindsey Goldberg, William Yang, Kalene Blum, Elizabeth Kelly, Kali Goldfarb, Benjamin knizner, Michael Walton. Jazmine Weddington, Eric Badgett, Joseph Barksdale, Brian Falsy, Rigsbee Goldberg, Benjamin Folk. Christopher Dodds, Ashley Zhao, Zachary Williams, Jace Zhao, Shane Barclay, Alicia Lloyd, Christopher Davis, Chad Folk, Paul Badgett, Max Khader, Maile Q1 $ 2,357.00 $ 2,807.00 $ 2,551.00 1$ 153.00 1 $ 1,211.00 $ 109.00 $ 283.00 $ 1,344.00 $ 2,757.00 $ 2,221.00 $ 2,092.00 $ 672.00 | $ 3,737.00 $ 958.00 $ 1,669.00 $ 594.00 $ 833.00 1$ 3,062.00 $ 190.00 $ 2,034.00 $ 1,201.00 $ 291.00 $ 756.00 $ 3.278.00 $ 2,008.00 $ 173.00 $ 3,345.00 $ 1,435.00 $ 1,803.00 | $ 1,093.00 $ 2,896.00 $ 959.00 $ 3,059.00 $ 3,558.00 Q3 Q4 $ 387.00 $ 2,734.00 $ 732.00 $ 3,978.00 $ 255.00 / $ 2,335.00 $ 1,144.00 $ 1,802.00 $ 1,634.00 $ 2,897.00 $ 1,750.00 $ 1,129.00 $ 678.00 $ 3,784.00 $ 1,789.00 $ 3,174.00 $ 167.00 $ 3,614.00 $ 953.00 $ 3,937.00 $ 1,018.00 $ 440.00 $ 3,168.00 $ 2,679.00 $ 987.00 $ 395.00 $ 3,638.00 $ 2,258.00 $ 1,186.00 $ 956.00 $ 1,649.00 $ 3,551.00 $ 845.00 $ 465.00 $ 2,084.00 $ 1,916.00 $ 395.00 $ 2,314.00 $ 2,475.00 $ 128.00 $ 3,112.00 $ 3,314.00 $ 839.00 $ 3,480.00 $ 441.00 $ 3,226.00 $ 1,470.00 $ 54.00 $ 3,206.00 $ 3,047.00 $ 3,082.00 $ 1,611.00 $ 643.00 $ 2.929.00 $ 1,453.00 $ 379.00 $ 984.00 | $ 2,672.00 $ 645.00$ 3,612.00 $ 1,426.00 $ 1,909.00 $ 3,431.00 $ 1,523.00 $ 543.00 $ 3,170.00 $ 1,929.00 $ 2,817.00 $ 1,447.00 $ 237.00 $ 3.153.00 $ 1.643.00 $ 654.00 $ 1,767.00 $ 2,011.00 $ 3,924.00 $ 3,152.00 $ 2,571.00 $ 3,112.00 $ 2,875.00 $ 351.00 $ 3,861.00 $ 3,790.00 $ 1,081.00 $ 1,302.00 $ 1,420.00 $ 2,531.00 $ 967.00 $ 2,577.00 $ 2,557.00 $ 3,447.00 $ 2,524.00 $ 992.00 $ 1,486.00 $ 2,189.00 $ 3,666.00 $ 3,761.00 $ 2,358.00 $ 2,146.00 $ 1,279.00 $ 3,503.00 $ 3,409.00 Date Report Turned In 12/17/20 12/21/20 12/4/20 12/2/20 12/29/20 12/25/20 12/13/20 12/2/20 12/2/20 12/12/20 12/15/20 12/30/20 12/31/20 12/31/20 12/5/20 12/27/20 12/26/20 12/29/20 12/31/20 12/15/20 12/2/20 12/13/20 12/30/20 12/8/20 12/27/20 12/1/20 12/20/20 12/21/20 12/9/20 12/13/20 12/1/20 12/24/20 12/17/20 12/12/20Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started