**Transcribed Image Text: **4. a. DeShawn suspects that the two remaining errors are related to the zero value in cell C5. He wants to make sure that anyone entering the minimum number of trainees enters a number greater than zero. Add data validation to the range B5:F5 as follows: Set a data validation rule for the range B5:F5 that allows only whole number values greater than 0. b. Add an Input Message using Number of Trainees as the Input Message title and the following text as the Input message: Enter the minimum number of trainees for this program. Add an Error Alert using the Stop style, Trainees Error as the Error Alert title, and the following text as the Error message: The minimum number of trainees must be greater than 0. C.
5. a. Identify the invalid data in the worksheet and correct the entry as follows: Circle the invalid data in the worksheet. b. Type 15 as the minimum number of trainees for the Tech Skills program (cell C5). Verify that this change cleared the remaining errors in the worksheet. C.
B21 4 x vfx =@ AVG(B16:F16) A B D E F G Maxwell Training 4 SA 3 1 2 Orientation Tech Skills Soft Skills Product Mandatory 3 Training fee per person $ 150 $ 495 $ 329 $ 229 $ 495 4 Sessions per program 2 12 10 6 5 Minimum trainees 10 15 20 10 6 Online access fee 500 $ 1,200 $ 750 $ 500 $ 750 7 Gross Income $ 2,000 $ 1,200 $ 5,685 $ 5,080 $ 5,700 8 9 Number of trainers 2 5 3 3 10 Trainer cost $ 525 $ 1,100 $ 1,000 $ 785 $ 1,100 11 Materials cost $ 470 $ 1,400 $ 650 $ 750 $ 1,200 12 Expenses $ 1,520 $ 6,900 $ 3,650 $ 3,105 $ 4,500 13 14 Income stats 15 Per program 480 $ (5,700) $ 2,035 $ 1,975 $ 1,200 16 Per session $ 240 $ (475) $ 204 $ 329 $ 300 17 Per trainee #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 18 19 Average income 20 Per program (2.00) 21 Per session ANAME? 22 Per trainee #DIV/0! 23

**More** **Transcribed Image Text: **4. a. DeShawn suspects that the two remaining errors are related to the zero value in cell C5. He wants to make sure that anyone entering the minimum number of trainees enters a number greater than zero. Add data validation to the range B5:F5 as follows: Set a data validation rule for the range B5:F5 that allows only whole number values greater than 0. b. Add an Input Message using Number of Trainees as the Input Message title and the following text as the Input message: Enter the minimum number of trainees for this program. Add an Error Alert using the Stop style, Trainees Error as the Error Alert title, and the following text as the Error message: The minimum number of trainees must be greater than 0. C.
5. a. Identify the invalid data in the worksheet and correct the entry as follows: Circle the invalid data in the worksheet. b. Type 15 as the minimum number of trainees for the Tech Skills program (cell C5). Verify that this change cleared the remaining errors in the worksheet. C.
B21 4 x vfx =@ AVG(B16:F16) A B D E F G Maxwell Training 4 SA 3 1 2 Orientation Tech Skills Soft Skills Product Mandatory 3 Training fee per person $ 150 $ 495 $ 329 $ 229 $ 495 4 Sessions per program 2 12 10 6 5 Minimum trainees 10 15 20 10 6 Online access fee 500 $ 1,200 $ 750 $ 500 $ 750 7 Gross Income $ 2,000 $ 1,200 $ 5,685 $ 5,080 $ 5,700 8 9 Number of trainers 2 5 3 3 10 Trainer cost $ 525 $ 1,100 $ 1,000 $ 785 $ 1,100 11 Materials cost $ 470 $ 1,400 $ 650 $ 750 $ 1,200 12 Expenses $ 1,520 $ 6,900 $ 3,650 $ 3,105 $ 4,500 13 14 Income stats 15 Per program 480 $ (5,700) $ 2,035 $ 1,975 $ 1,200 16 Per session $ 240 $ (475) $ 204 $ 329 $ 300 17 Per trainee #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 18 19 Average income 20 Per program (2.00) 21 Per session ANAME? 22 Per trainee #DIV/0! 23