Shelly Cashman Excel 365 | Module 9: SAM Critical Thinking Project C Full Circle Conferences скачать в хорошем качестве

Shelly Cashman Excel 365 | Module 9: SAM Critical Thinking Project C Full Circle Conferences

#Shelly Cashman Excel 365 | Module 9: SAM Critical Thinking Project C #Shelly Cashman Excel 365 | Module 9: SAM Critical Thinking Project C Contact Us: WhatsApp Number:+923187569415 Chatting Link :https://tinyurl.com/yzpfk6fm I am providing help in all online courses like Excel, Word, Access, PowerPoint, Accounting , Management Courses, Finance Courses, Computer Science Courses, Information Technology Courses, All Writing Assignments etc. I can do your Quizzes, Exams , Mid-Term, Final Exams. In short I can get you A grade in your courses. If you want me do your courses My WhatsApp number and Email is given you can contact me through that. Thanks 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. Start with the first error. a. Use the Trace Precedents arrows to find the source of the #VALUE! error for the Workshop gross income, and then use the Trace Dependents arrows to determine whether the Workshop gross income formula causes other errors in the worksheet. b. Correct the formula, which should multiply the Workshop attendance fee per person by the minimum number of attendees, and then add the recordings fee to that result. c. Remove the trace arrows. 2. Correct the #NAME? error. a. Use any error-checking method to determine the source of the #NAME? error, which should calculate the average income per session. b. Correct the #NAME? error by editing the formula. 3. Correct the divide-by-zero errors. a. Evaluate the formula that calculates the Conference income per attendee to determine which cell is causing the divide-by-zero error. b. Correct the formula, which should divide the income per event by the minimum number of attendees. c. Fill the rest of the per attendee cells with the formula you corrected. (Hint: You will correct the new error for the Convention income per attendee in the following steps.) 4. Martin suspects that the two remaining errors are related to the zero value for the minimum number of Convention attendees per session. 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 for the minimum number of attendees per session for the five types of sessions. a. Set a data validation rule for the minimum attendees per session for the five types of sessions 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. a. Circle the invalid data in the worksheet. b. Type 25 as the minimum number of attendees for a convention, and then 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. a. Use Max Attendance as the scenario name. b. Use the enrolled clients per day data for the five types of sessions as the changing cells. c. Enter cell values for the Max Attendance scenario as shown in bold in Table 1, which are the same values as for the maximum clients per day for the five types of