Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

RedRocks Consulting is a large computer consulting firm in Denver, Colorado. Don McCubbrey, the CEO and founder of the firm, is well-known for his philanthropic

RedRocks Consulting is a large computer consulting firm in Denver, Colorado. Don McCubbrey, the CEO and founder of the firm, is well-known for his philanthropic efforts. He believes that many of his employees also contribute to nonprofit organizations and wants to reward them for their efforts while encouraging others to contribute to charities. He started a program in which RedRocks Consulting matches 50 percent of each donation an employee makes to the charity of his or her choice. The only guidelines are that the charity must be a nonprofit organization and the firms donation per employee may not exceed $500 a year. Don has started an Excel file, T3_RedRocks_Data.xlsx, to record the firms donations. Included in this file are the dates the request for a donation was submitted, the employees name and ID number, the name of the charity, the dollar amount contributed by the firm, and the date the contribution was sent. Don wants you to help him create several worksheets with the following criteria:

1. One worksheet that sorts the list alphabetically by organization and then by employees last name.

2. One worksheet that totals the contribution made per employee for the month of December.

3. One worksheet that sorts the list by donation value by lowest amount to highest amount.

Please help me with the steps to be able to create these three different worksheets. I am confused.

Submitted Employee ID Last Name First Name Organization Amount Donation Sent
11/29/21 688 Abbs Don Habitat for Humanity $ 50 12/1/21
12/5/21 08T Adams David Red Cross $ 100 12/6/21
12/9/21 Y7CA Ascott Karen Red Cross $ 100 12/18/21
12/5/21 M5NA Bagby Sharon Rotary Club $ 25 12/6/21
12/3/21 39N Butler Barry Rotary Club $ 250 12/10/21
12/3/21 0NNA Clark Jolene Toastmasters $ 20 12/5/21
12/2/21 0NNA Clark Jolene Make a Wish Foundation $ 75 12/4/21
12/6/21 0NNA Clark Jolene Leukemia Society $ 60 12/19/21
12/16/21 CT8A Donovan Gary Make a Wish Foundation $ 130 12/21/21
12/12/21 1XBA Doster Glenn Amnisty International $ 200 12/21/21
12/16/21 L3H Dunn Elaine Make a Wish Foundation $ 225 12/29/21
12/4/21 56NA Foster Scott Rotary Club $ 125 12/10/21
12/2/21 56NA Foster Scott Meals on WHeels $ 125 12/26/21
12/17/21 1F9A Hughes Gary Red Cross $ 50 12/22/21
12/27/21 J5M Johnson Les Foster Children's Fund $ 25 12/30/21
12/10/21 44JA Kelleher George Romania Relief $ 180 12/14/21
12/20/21 57XA Lomstein Thomas Meals on WHeels $ 115 12/22/21
12/12/21 FA5A Peters Roger Toastmasters $ 35 12/15/21
12/14/21 FA5A Peters Roger Foster Children's Fund $ 80 12/19/21
12/6/21 R9M Simpson Joseph Red Cross $ 50 12/19/21
12/13/21 R9M Simpson Jospeh Habitat for Humanity $ 150 12/23/21
12/6/21 08A Thimsen Timothy Rotary Club $ 50 12/14/21
12/3/21 C3P Warren James Lion's Club $ 60 12/13/21
12/27/21 R45A Womak Anthony Habitat for Humanity $ 100 12/29/21

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_2

Step: 3

blur-text-image_3

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

Supply Chain For Startups Building Your Business From Zero To Scale

Authors: Jonathan Biddle

1st Edition

173757280X, 978-1737572800

More Books

Students also viewed these General Management questions