Скачать или смотреть Shelly Cashman Excel 365 | Module 9 SAM Project A | Full Circle Conferences

If you directly want to get the project from us then contact us on Whatsapp. Click on link below👇👇
https://wa.me/message/PPXGSJS2TLWUA1

Whatsapp Contact Number:
+91 8114420233

Email ID:
[email protected]

PROJECT STEPS
1. Martin Mosley runs the southern office of Full Circle Conferences, a company that organizes conferences, conventions, trade shows, and other events for North American organizations. He is using an Excel workbook to analyze the company's financials and asks for your help in correcting errors and solving problems with the data.

Go to the Income worksheet. Martin 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 G7.
b. Use the Trace Dependents arrows to determine whether the formula in cell G7 causes other errors in the worksheet.
c. Correct the formula in cell G7, which should multiply the Workshop attendance fee per person (cell G3) by the minimum number of attendees (cell G5), and then add the recordings fee (cell G6) to that result.
d. Remove the trace arrows.
2. Correct the #NAME? error in cell C21 as follows:
a. Use any error-checking method to determine the source of the error in cell C21, which should calculate the average income per session.
b. Correct the error by editing the formula in cell C21.
3. Correct the divide-by-zero errors as follows:
a. Evaluate the formula in cell C17 to determine which cell is causing the divide-by-zero error.
b. Correct the formula in cell C17, which should divide the income per event (cell C15) by the minimum number of attendees (cell C5).
c. Fill the range D17:G17 with the formula in cell C17. (Hint: You will correct the new error in cell D17 in the following steps.)
4. Martin suspects that the two remaining errors are related to the zero value in cell D5. He asks you to make sure that anyone entering the minimum number of attendees enters a number greater than zero to avoid divide by zero errors.

Add data validation to the range C5:G5 as follows:
a. Set a data validation rule for the range C5:G5 that allows only whole number values greater than 0.
b. Add an Input Message using Number of Attendees as the Input Message title and the following text as the Input message:
Enter the minimum number of attendees for this event.
c. Add an Error Alert using the Stop style, Attendee Error as the Error Alert title, and the following text as the Error message:
The minimum number of attendees 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 25 as the minimum number of attendees for a convention (cell D5).
c. Verify that this change cleared the remaining errors in the worksheet.
6. Go to the Consulting worksheet. This worksheet analyzes financial data for small-group consulting sessions, which Full Circle runs throughout the day of an event. Martin has already created a scenario named Current Enrollment that calculates profit based on the current number of people enrolled for each consulting session. He also wants to calculate profit based on the maximum number of attendees.

Add a new scenario to compare the profit with maximum enrollments as follows:
a. Use Max Attendance as the scenario name.
b. Use the enrolled clients per day data (range C9:G9) as the changing cells.
c. Enter cell values for the Max Attendance scenario as shown in bold in
8. Show the Low Attendance scenario values in the Consulting worksheet, and then close the Scenario Manager window.
9. Go to the Proposed Consulting worksheet. Martin is considering whether to change the fees for the small-group consulting sessions. He has created three scenarios on the Proposed Consulting worksheet showing the profit with a $10 or $15 fee increase or a $5 fee decrease.

Compare the average profit per event based on the scenarios as follows:
a. Create a Scenario Summary report using the average profit per event (range C11:G11) as the result cells to show how the average profit changes depending on the fee changes.
b. Use New Fees Scenario Report as the name of the worksheet containing the report.
10. Martin also wants to focus on one or two types of small-group consulting sessions at a time when comparing the average profit per event. Return to the Proposed Consulting worksheet and create another type of report as follows:

#samproject1a #samprojects #cengageassignments #SC_EX365_9a #SC_EXCEL #excel_assignments #excel_sam_projects #Module9SamProjecta #full_circle_conferences #shelly_cashman_excel #SC_EX365_9a_FirstLastName_1.xlsx #SC_EX365_9a_FirstLastName_2.xlsx