Including the period as the title 15 in cell c7

This preview shows page 4 - 6 out of 6 pages.

(including the period) as the title. 15. In cell C7, create a data validation rule that will only accept values from a list corresponding to the different assignment at the Reclaim by the River event as described below: a. The validation rule should ignore blanks and appear as an in-cell dropdown . b. Enter the following list: Waterfront Cleanup, River Cleanup, Landscaping, Material Transport, Refreshments, Support as the validation source. c. The input message should have the title Assignment and should use Select an assignment from the list. (including the period) as the Input message. d. The error alert should have the Stop style with Invalid assignment. (including the period) as the title. 16. Edit the data validation rule associated with cell C8 as described below: a. The input message should have the title T-Shirt Size and should use Select a t-shirt size from the list. (including the period) as the Input message. b. The error alert should have the Stop style with Select a valid t-shirt size. (including the period) as the title.
Image of page 4

Subscribe to view the full document.

New Perspectives Excel 2016 | Module 7: SAM Project 1a 17. Enter the following volunteer information into the worksheet: a. In cell C4, enter Kate Bryant as the Volunteer Name. b. In cell C5, enter Ultimate Craft Center as the Organization. c. In cell C6, enter 5/19/2018 as the Volunteer Date. d. In cell C7, select River Cleanup as the Assignment. e. In cell C8, select S as the T-Shirt Size. 18. With all the changes that you’ve made to the worksheet, Dee now wants to make sure that no further changes can be made. Format the range C4:C8, so that the cells in this range are unlocked. Then protect the Volunteer Registration worksheet without using a password and using the default settings. 19. Protect the structure of the current workbook without using a password. Your workbook should look like the Final Figures on the following pages. Save your changes, close the document, and then exit Excel. Follow the directions on the SAM website to submit your completed project. Final Figure 1: Volunteer Totals Worksheet
Image of page 5
New Perspectives Excel 2016 | Module 7: SAM Project 1a Final Figure 2: Volunteer Letterhead Worksheet Final Figure 3: Volunteer Records Worksheet Final Figure 4: Volunteer Registration Worksheet
Image of page 6
  • Fall '09
  • Visual Basic for Applications, developer, new perspectives, Dee Amytha, volunteer registration worksheet

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern