Need help solving this, show step by step. Show how to do this.
4. In the Projects table, Hwan wants to make sure that everyone entering project information enters the correct project categories, which are listed in the range 14:17. He asks you to ensure users enter a value from this range. Create a data validation rule as follows: a. In the range 04:C37, create a data validation rule that accepts only List values from the range 14:17. b. Create an input message that uses Project Category as the title and the following text as the input message: Enter a project category. C. Create a Stop style error alert that uses Invalid Category as the title and the following text as the error message: Enter a category listed in column I. Hwan wants to make sure all of the categories entered in the Category column of the Projects table are valid. Identify and correct any invalid values as follows: In the range C4:C37, circle invalid data. b. Change the invalid entry to site development to correct the error. 5. a. File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Record Macro Use Relative References Properties View Code Insert Design Mode Run Dialog Map Properties Import Expansion Packs E Export Refresh Data Source Visual Macros Basic Add- ins Excel COM Add-ins Add-ins ! Macro Security v Code Add-ins Controls XML G2 fix C D E F H I K L M N. Engineering Projects Print Stats 1 2 3 Category State Project Start 4 Highway NE 1/12/2021 5 Highway NE 1/20/2021 6 Bridge WY 2/16/2021 7 Site development NE 2/22/2021 8 Site development SD 2/22/2021 9 Paving ND 3/1/2021 10 Bridge NE 3/12/2021 11 Site development WY 3/20/2021 12 Site enhancement NE 3/23/2021 13 Paving ND 3/24/2021 14 Paving MT 3/30/2021 15 Paving NE 4/2/2021 16 Paving SD 4/2/2021 17 Paving MT 4/5/2021 18 Bridge WY 4/5/2021 19 Paving ND 4/14/2021 20 Paving MT 4/16/2021 21 Parring 1/16/2021 Documentation Projects Project Stats Estimate Paid to Date - Category Projects Total EstimatesAvg Estimates $30,562 $30,562 Bridge $14,500 $12,000 Highway $54,672 $50,000 Paving $107,654 $57,654 Site development $38,750 $30,000 $48,932 $45,932 Estimate $72,358 $72,358 >50,000 $24,505 $24,505 Projects: $34,756 $34,756 $68,900 $34,900 Client ID $42,350 $4,250 W-0338 $27,800 $17,000 Total paid: $28,500 $28,500 $70,347 $30,400 Projects by State $19,576 $10,576 MT $78,400 $38,400 ND $76,320 $16,320 NE 552050 $12050 SD Projects by State Project Payments Projects by Category Monthly Sal + Ready EO File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Record Macro Use Relative References E Properties QE View Code Insert Design Mode Run Dialog Map Properties Import Expansion Packs Export Refresh Data Source Visual Macros Basic Add- ins ! Macro Security Excel COM Add-ins Add-ins Code Add-ins Controls XML G2 X fic D I K L Projects by State 16 Paving SD 17 Paving MT 18 Bridge WY 19 Paving ND 20 Paving MT 21 Paving MT 22 Highway SD 23 Paving NE 24 Site development WY 25 Paving ND 26 Bridge MT 27 Highway SD 28 Highway ND 29 Site development SD 30 Paving 31 Highway MT 32 Paving WY 33 Paving NE 34 Site development NE 35 Site development SD 36 Highway ND 37 Paving NE 38 39 Documentation E 4/2/2021 4/5/2021 4/5/2021 4/14/2021 4/16/2021 4/16/2021 4/17/2021 4/23/2021 5/2/2021 5/10/2021 5/14/2021 5/14/2021 5/26/2021 5/30/2021 6/1/2021 6/3/2021 6/6/2021 6/12/2021 6/17/2021 6/20/2021 6/24/2021 6/26/2021 F $28,500 $70,347 $19,576 $78,400 $76,320 $52,050 $56,890 $34,560 $19,750 $34,566 $29,800 $24,528 $18,500 $85,437 $82,350 $31,250 $75,250 $100,350 $34,582 $44,500 $82,300 $37,650 H $28,500 $30,400 $10,576 MT $38,400 ND $16,320 NE $12,050 SD $6,000 WY $17,000 $2,000 $24,000 $20,000 $2,400 $18,500 $43,000 $40,000 $11,250 $7,500 $10,350 $14,582 $20,500 $42,000 $17,000 NE Projects Project Stats Projects by State Project Payments Projects by Category Monthly Sal ... + Ready EO
