Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I just need assistance on what to click thank you ! 1. 2. 3. 4. Dee Amytha is the coordinator for the Reclaim the River,

I just need assistance on what to click thank you !
image text in transcribed

1. 2. 3. 4. 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:CIO, using Friday _ Afternoon as the range name. View the comment associated with cell A 10. 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.] ssignment Waterfront Cleanup River Cleanup Landscaping Material Transport Refreshments Total Friday - May 17, 2018 Morning Voluntel Afternoon Volunte Saturday- May 18, 2018 Total Tot Event Totals Assignment Total Voluntee Waterfront Cleanup River Cleanup Landscaping Material Transport Refreshments Total ssignment Morning Voluntel Afternoon Volunte Waterfront Cleanup River Cleanup Landscaping Material Transport Refreshments Total 24 ssignment Waterfront Cleanup River Cleanup Landscaping Material Transport Refreshments Total 235 Sunday - May 19, 2018 Morning Voluntel Afternoon Volunte Tot 202 New Perspectives Excel 2016 | Module 7: SAM Project la 5. 6. 7. 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_VoIunteers. Use the defined range Total Volunteers in your formula.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Of Electronic And Digital Media

Authors: Alan B. Albarran

6th Edition

1305077563, 978-1305077560

More Books

Students also viewed these General Management questions

Question

Describe t he t wo m ain t ypes of ex ercise. (p. 1 84)

Answered: 1 week ago