Скачать или смотреть Shelly Cashman Excel 365/2021 | Module 9: SAM Project 1b

Shelly Cashman Excel 365/2021 | Module 9: SAM Project 1b #GreenLakeSportsCamp #Module9SAMProject1b


Contact Me:

WhatsApp : +923025441145

Email : [email protected]

Direct WhatsApp Link: https://tinyurl.com/3zfyhs35






#Shelly Cashman Excel 365/2021 | Module 9: SAM Project 1b #ShellyCashmanExcel 365/2021 #Module9SAMProject1b #Module9 #SAMProject1b


#Shelly Cashman Excel 365/2021 | Module 9: SAM Project 1b
#Shelly Cashman Excel 365/2021
#Cashman Excel 365/2021
#Excel 365/2021
#Module 9: SAM Project 1b
#SAM Project 1b
#Project 1b
#Module 9
#Excel 365/2021 | Module 9: SAM Project 1b
#Module 9: SAM Project
#SAM Project
#Project


PROJECT STEPS
1. Takara Hiyashi is on the board of the Green Lake Sports Camp, a recreational summer camp in Syracuse, New York. She is using an Excel workbook to analyze the camp's financials and asks for your help in correcting errors and solving problems with the data.
Go to the Teams worksheet. Takara asks you to correct the errors in the worksheet. Correct the first error as follows:
a. Use the Trace Precedents arrows to find the source of the #VALUE! error in cell C8.
b. Use the Trace Dependents arrows to determine whether the formula in cell C8 causes other errors in the worksheet.
c. Correct the formula in cell C8, which should add the baseball registration fee per person (cell C4) and the equipment fee (cell C7), and then multiply the result by the minimum number of campers (cell C6).
d. Remove the trace arrows.
2. Correct the Name error in cell C22 as follows:
a. Use any error-checking method to determine the source of the error in cell C22, which should calculate the average revenue per week.
b. Correct the error by editing the formula in cell C22.
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.
b. Add an Input Message using Number of Campers 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.
b. Type 10 as the minimum number of campers for the lacrosse sessions (cell E6).
c. Verify that this change corrected the remaining divide by zero errors and resulted in positive values in the range E16:E18.