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

$3.$ 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.$

$4.$ 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.$

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

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