IF USE OF AI FOUND, THE SOLUTION WILL BE DOWNVOTED!!!

Shelly Cashman Excel $2019|$ Module $9$: SAM Project $16$

Correct the divide by zero errors as follows:

a$.$ Evaluate the formula in cell C$18$ to determine which cell is causing the divide by

zero error.

b$.$ Correct the formula in cell C$18,$ which should divide the revenue per session $($cell

C$16)$ by the minimum number of campers $($cell C$6).$

c$.$ Fill the range D$18$:G$18$ with the formula in cell C$18.$

Takara suspects that the remaining divide by zero errors and the two negative values in

the range E$16$:E$18$ are related to the zero value in cell E$6.$ She wants to make sure that

anyone entering the minimum number of campers enters a number greater than zero.

Add data validation to the range C$6$:G$6$ as follows:

a$.$ Set a data validation rule for the range C$6$:G$6$ that allows only whole number

values greater than $0.$

Add an Input Message using Number of $$ampers as the Input Message. Title and

the following text as the Input message:

Enter the minimum number of campers for this session.

c$.$ Add an Error Alert using the Stop style, Campers Error as the$-$Error Alert Title,

and the following text as the Error message:

The minimum number of campers must be greater than $0.$

Identify the invalid data in the worksheet and correct the entry as follows:

a$.$ Circle the invalid data in the worksheet.