Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started