Скачать или смотреть New Perspectives Excel 3652021 Module 12 SAM project Penta Tutoring Program

New Perspectives Excel 3652021 Module 12 SAM project Penta Tutoring Program

For any solution or help please contact us via the links given.
We are available 24/7
WA
https://wa.me/message/Q7NLXG5MHPX6J1
Instagram
instagram.com/master_tutor94


"Luis Palomba is in charge of community relations for Penta Insurance, a health insurance agency in Minneapolis, Minnesota. Luis is coordinating a program that sends tutors from Penta Insurance to area elementary schools. He is developing an Excel workbook to track and record the tutoring information, and needs to complete it before the upcoming Volunteer Fair. He asks for your help in automating the workbook.
Go to the Tutor Summary worksheet and then unprotect it so you can edit the contents."

"Luis wants to include an eye-catching title on the worksheet, which he shares with others at Penta Insurance.
Insert and format WordArt as follows:
a. Insert WordArt using the Fill: Dark Red, Accent color 1; Shadow style.
b. Type Penta Tutoring Program as the worksheet title.
c. Change the text fill of the WordArt to Green, Accent 6, Darker 50%.
d. Move the WordArt to row 1 so that it spans columns A:G."

"Go to the Tutor Records worksheet, where Luis tracks tutor assignments. He and his staff usually enter the tutoring details directly on the worksheet. He wants to make sure everyone enters the tutoring data correctly, especially the dates in the Tutoring Start Date column. The tutoring program begins on March 22, 2024 and ends on May 14, 2024. Create a data validation rule as follows:
a. In the range C5:C18, create a data validation rule that accepts only date values between 3/22/24 and 5/14/24.
b. Create an input message that uses Tutoring Start Date as the title and the following text as the input message: Enter the date to start tutoring.
c. Create a Stop style error alert that uses Invalid Date as the title and the following text as the error message: Enter a date between March 22 and May 14."

First insert the tutor registration data shown in Table 1. Then use the Add Tutor button to run the Add_Tutor macro, and then verify that it added a record on the Tutor Records worksheet.


Penta Insurance
Penta Tutoring Program
Penta Insurance Develope Excel Application
Penta Tutoring Program




Thank you for watching. If you found this video helpful, be sure to give it a thumbs up and subscribe to our channel for more SAM Cengage project solutions

#cengagesolution #solutionexpert #pentatutoring
#pentainsurance