Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Module 7 sam project 1a

29/11/2021 Client: muhammad11 Deadline: 2 Day

New Perspectives Excel 2016 | Module 7: SAM Project 1a

C:\Users\akellerbee\Documents\SAM Development\Design\Pictures\g11731.png New Perspectives Excel 2016 | Module 7: SAM Project 1a

Reclaim the River

Developing an Excel Application

GETTING STARTED
Open the file NP_EX16_7a_FirstLastName_1.xlsm, available for download from the SAM website.

Save the file as NP_EX16_7a_FirstLastName_2.xlsm by changing the “1” to a “2”.

0. If you do not see the .xlsm file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

With the file NP_EX16_7a_FirstLastName_2.xlsm still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.

· If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

If you see a Message Bar with a security warning at top of the Excel window, click the Enable Content button in the Message Bar to enable the macros contained in the file (see Figure 1).

Figure 1: Security Warning Message Bar

To complete this project you will need to display the Developer tab. To add this tab to the Excel ribbon, click the File tab to open Backstage View and then click the Options button. In the Excel Options dialog box, click the Customize Ribbon option and click the Developer check box (see Figure 2). Click the OK button to close the Excel Options dialog box and confirm the Developer tab appears in the Excel Ribbon.

Figure 2: Customize Ribbon Section of Excel Options Dialog Box

PROJECT STEPS
Dee Amytha is the coordinator for the Reclaim the River, a 3-day volunteer event where local businesses and community groups help to revitalize the banks of the Charles River. She has asked for your help updating the worksheet she is using to track and record volunteer information.

Switch to the Volunteer Totals worksheet, and then unprotect it.

Dee started to create named ranges in the worksheet and has asked you to finish the updates.

Create a defined name for the range C5:C10, using Friday_Afternoon as the range name.

View the comment associated with cell A10. Follow the instructions in the comment to update a value in the worksheet, and then delete the comment.

Edit the defined name associated with the range C15:C20 to be Saturday_Afternoon instead of Sat_Aftr. [Mac Hint: Delete the named range Sat_Aftr, and use Saturday_Afternoon as the a new named range for the range C15:C20.]

Apply the defined names Saturday_Morning, Sunday_Morning, and Sunday_Afternoon to the existing formulas on the Volunteer Totals worksheet. Ignore Relative/Absolute value and use row and column names. (Hint: If you receive an error that Excel cannot find any references to replace, make sure that only a single cell, rather than a range, in the worksheet is selected prior to applying the defined names.)

Select the range G3:H8 and create names from the selection, using the values shown in the Left column.

In cell H9, enter a formula using the SUM function to total the values in the defined range Total_Volunteers. Use the defined range Total_Volunteers in your formula.

Insert the following comment into the merged range G1:H1: Consider moving this table to another worksheet. (including the period). If necessary, hide the comment.

Dee wants to create a macro that will allow her to quickly add the Reclaim the River header to any worksheet she adds to the workbook.

Switch to the Volunteer Letterhead worksheet. Make sure the Use Relative References option is not selected in the Developer tab. [Mac Hint: The Developer pane doesn’t include this option, so Mac users can ignore this option.]

Record a macro named RtR_Letterhead, stored in the current workbook with the keyboard shortcut Ctrl+ Shift+L [Mac Hint: Option+Cmd+Shift+L] and the description Macro to add the Reclaim the River letterhead to a worksheet. (including the period). With the macro recording, complete the following actions:

a. Change the column width of columns A:D to 21.00 characters.

b. Merge and center the range A1:D1.

c. Enter the text Reclaim the River into the merged range A1:D1.

d. Italicize the merged range A1:D1 and apply a 24 pt. font size to the merged range.

e. Change the background color to Blue, Accent 5, Lighter 40% (9th column, 4th row in the Theme Colors palette) and the font color to White, Background 1 (1st column, 1st row in the Theme Colors palette).

f. Click the Stop Recording button in the Code group on the Developer tab.

Confirm that your macro works as expected by switching to the Volunteer Records worksheet and running the RtR_Letterhead macro you just recorded. (Hint: You can use the keyboard shortcut you just created to run your macro.)

Switch to the Volunteer Registration worksheet.

Delete the defined name Volunteer_Data associated with the range C4:C8 on this worksheet.

Dee created two macros to use on the Volunteer Registration worksheet. She wants you to review the macros and assign them to buttons, to make them easier to access.

Assign the Clear_Data macro to the Clear Data macro button in the range B10:B11.

Edit the Clear_Data macro (found in Module 1).

In the Clear_Data macro VBA code, change the range used in the code to the range C4:C8. The edited code should read: Range("C4:C8").Select (see Figure 3 for details).

Run the Clear_Data macro to confirm that the macro erases the values in the range C4:C8. (Hint: You must complete Step 17 correctly to receive credit.)

Figure 3: Clear_Data() Macro

Create a form control macro button in the range C10:C11, next to the Clear Data button and then complete the following actions:

g. Assign the macro Record_Volunteer to the button.

h. Change the button label using Record Volunteer as the new name.

In cell C6, create a data validation rule that will only accept date values corresponding to the dates of the Reclaim the River event as described below:

i. The dates should be between 5/18/2018 and 5/20/2018.

j. The input message should have the title Volunteer Date and should use the text Enter volunteer date. (including the period) as the Input message.

k. The error alert should have the Stop style with Invalid volunteer date. (including the period) as the title.

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:

l. The validation rule should ignore blanks and appear as an in-cell dropdown.

m. Enter the following list: Waterfront Cleanup, River Cleanup, Landscaping, Material Transport, Refreshments, Support as the validation source.

n. The input message should have the title Assignment and should use Select an assignment from the list. (including the period) as the Input message.

o. The error alert should have the Stop style with Invalid assignment. (including the period) as the title.

Edit the data validation rule associated with cell C8 as described below:

p. 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.

q. The error alert should have the Stop style with Select a valid t-shirt size. (including the period) as the title.

Enter the following volunteer information into the worksheet:

r. In cell C4, enter Kate Bryant as the Volunteer Name.

s. In cell C5, enter Ultimate Craft Center as the Organization.

t. In cell C6, enter 5/19/2018 as the Volunteer Date.

u. In cell C7, select River Cleanup as the Assignment.

v. In cell C8, select S as the T-Shirt Size.

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.

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

Final Figure 2: Volunteer Letterhead Worksheet

Final Figure 3: Volunteer Records Worksheet

Final Figure 4: Volunteer Registration Worksheet

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Chartered Accountant
Top Rated Expert
Math Specialist
Pro Writer
A Grade Exams
Smart Tutor
Writer Writer Name Offer Chat
Chartered Accountant

ONLINE

Chartered Accountant

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$23 Chat With Writer
Top Rated Expert

ONLINE

Top Rated Expert

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$24 Chat With Writer
Math Specialist

ONLINE

Math Specialist

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$17 Chat With Writer
Pro Writer

ONLINE

Pro Writer

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$20 Chat With Writer
A Grade Exams

ONLINE

A Grade Exams

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$18 Chat With Writer
Smart Tutor

ONLINE

Smart Tutor

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$28 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Fatal error freeze detected war thunder - Who proposed the one gene one enzyme hypothesis - Oxford phonics world 1 pdf free download - Https://www.sec.gov/archives/edgar/data/320187/000032018718000142/nke-5312018x10k.htm - Public health job cover letter - Www tutor2u net business - Journal Article - Spread plate method principle - Ap biology cheat sheet - Government - WEEK 5 #2 - Blp oil spray system - Researchers endeavoring to conduct an online study - Target corporation case study pdf - Organizational Analysis - What do you think should I get business Non-profit business plan writing service or not? - Lufthansa annual report 2010 - Order 2540229: Choose one contemporary U.S. political issue. Use the two political parties’ positions on the topic as a starting point to establish each side of the issue. - Battle of lake borgne - Sample swot analysis nursing home - Lucky charms commercial 2014 - Dragon age inquisition bronze acorn charm - Strategic management multiple choice questions and answers - Cadbury schweppes americas beverages - Fundamentals of management ricky w griffin pdf - Biology WEEK 5 DISCUSSION - Physics practical resonance tube - Doing a competitive strength assessment entails - Volkswagen ethical issues case study - Active directory design proposal - North norfolk district council your choice your home - Viernes ul - Virgil book 2 translation - Drishtikon a management journal - Survival analysis techniques for censored and truncated data solution - Owasp application security architecture cheat sheet - Maths methods unit 1 and 2 practice sacs - Aloha international moving services inc - Taxation of individuals and business entities solutions - Initiating the Project - Problem Set 10 - Simile in the gift of the magi - Walworth gate valve catalogue - Nutrition soap note example - What happens in hamlet john dover wilson pdf - Mat 144 major assignment 1 - Al hno3 al no3 3 nh4no3 h2o - Reading Reflections are generally a half-page (single-spaced) analysis of the readings. - Exploring density worksheet answers - CYPRODEV412 - Siemens live tank circuit breaker - How to calculate theoretical yield - If prices fall, then real wealth __________ and the quantity of aggregate demand __________. - Discuss Question - Strategic management in international context - Andrew carnegie on the triumph of america 1885 - Ancient history syllabus qld - Cmos schmitt trigger inverter - Week 3: Research Problems and Designs - Grammar for ielts vk - Automatic voltage regulator function - Strategic planning foundations - How to make a 3 generation genogram - Old testament character sketch bibl 104 - Coaching centre near me - Https acrobat adobe com us en sign html - Capstone project - Gun recoil physics problem - Anz merchant services stationery - English - 1.2 5 clock signals the 555 timer - Devry econ 312 week 3 quiz - Hyatt regency hotel walkway - NEED IN 12 HOURS or LESS - Thai health promotion foundation smoking kid - Britannia rescue csma discount - Raspberry pi music player with buttons - Macewan conference & event centre - Ted bundy childhood biography - Claritas mybestsegments zip code lookup - Church of jesus christ finances - Naming ionic compounds practice worksheet - Response - It 210 milestone two technology solutions and recommendations - Homework Question - Wbs for building a bicycle - Pros and cons of code of ethics in journalism - Reading Reflection: CABP - Community legal centres tasmania - Family developmental theory nursing - Our iceberg is melting discussion questions - Examine the genetic code table, shown below. the codon agc codes for the amino acid ______. - Glo bus quiz 1 - Kpiv and kpov template excel - Order of magnitude biology - HI230 Quality Assurance and Statistics in Health - Mkt 421 perceptual map presentation - Deltav m-series wiring diagram - Nike supply and demand analysis - Journal article critique apa format - Translational research graphic organizer template