Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Shelly Cashman Excel 2 0 1 9 | Module 9 : SAM Project 1 6 3 . Correct the divide by zero errors as follows:

Shelly Cashman Excel 2019| Module 9: SAM Project 16
3. Correct the divide by zero errors as follows:
a. Evaluate the formula in cell C18 to determine which cell is causing the divide by zero error.
b. Correct the formula in cell C18, which should divide the revenue per session (cell C16) by the minimum number of campers (cell C6).
c. Fill the range D18:G18 with the formula in cell C18.
4. Takara suspects that the remaining divide by zero errors and the two negative values in the range E16:E18 are related to the zero value in cell E6. 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 C6:G6 as follows:
a. Set a data validation rule for the range C6:G6 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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

The company has fair promotion/advancement policies.

Answered: 1 week ago