EX 12-37 EX 1241 structure of the workbook. Do not specily a passwu 8. In the Payment Form worksheet, use data validation to add a validation list to cell C4 using the data in the range H4:H451 of the Payment Form worksheet as the source. 9. Create a validation rule for cell C5 to allow date values greater than or equal to 9/20/2021. Add an input message to the cell with the title Payment Date and the input message Enter a date of 9/20/2021 or later. If an invalid date is entered, display only a warning alert with the title Invalid Date and the message Confirm the date of the payment >>dation rule for cell Co to allow only decimal numbers between 1 and 500,000. hH in the Payment Form worksheet August 8, 2021 at 2:16 PM nge 04:06, and then use the Protection tab in the Format Cells dialog box to unlock Answer #8 and #9 please he six visible worksheets, click the Protect Sheet button in the Protect group on the the shorts allowing users only to select locked and unlocked cells. Do EXE X hat range il Paste $ % 9 ti a. Av Inl! BIU C10 A XV fx H F G 1 E A B D 1 1 Primrose Community Clinic Payment Form Donor IDs AN 1 Donor ID 2 Total Pledged Total Paid Owed 5 Date Amount 3 6 4 7 8 5 6 7 10 11 8 1 9 12 10 IL 13 14 11 12 13 15 16 17 14 15 16 18 1. 17 19 20 21 22 23 18 19 20 21 22 23 II. 24 25 26 27 24 Il 28 25 26 29 II. Documentation Summary Payment Form Donors Payments Pledge Tables EX 12-37 EX 1241 structure of the workbook. Do not specily a passwu 8. In the Payment Form worksheet, use data validation to add a validation list to cell C4 using the data in the range H4:H451 of the Payment Form worksheet as the source. 9. Create a validation rule for cell C5 to allow date values greater than or equal to 9/20/2021. Add an input message to the cell with the title Payment Date and the input message Enter a date of 9/20/2021 or later. If an invalid date is entered, display only a warning alert with the title Invalid Date and the message Confirm the date of the payment >>dation rule for cell Co to allow only decimal numbers between 1 and 500,000. hH in the Payment Form worksheet August 8, 2021 at 2:16 PM nge 04:06, and then use the Protection tab in the Format Cells dialog box to unlock Answer #8 and #9 please he six visible worksheets, click the Protect Sheet button in the Protect group on the the shorts allowing users only to select locked and unlocked cells. Do EXE X hat range il Paste $ % 9 ti a. Av Inl! BIU C10 A XV fx H F G 1 E A B D 1 1 Primrose Community Clinic Payment Form Donor IDs AN 1 Donor ID 2 Total Pledged Total Paid Owed 5 Date Amount 3 6 4 7 8 5 6 7 10 11 8 1 9 12 10 IL 13 14 11 12 13 15 16 17 14 15 16 18 1. 17 19 20 21 22 23 18 19 20 21 22 23 II. 24 25 26 27 24 Il 28 25 26 29 II. Documentation Summary Payment Form Donors Payments Pledge Tables