Directions for Module 3 Excel Assignment

Directions for Module 3 Excel Assignment

Lazarus Consulting is a large computer consulting company in New York. Pete Lazarus, the CEO and founder, is well known for his philanthropic efforts. Pete knows that most of his employees contribute to nonprofit organizations and wants to reward them for their efforts while encouraging others to contribute to charities. Pete began a program that matches 50 percent of each employee donation. The only stipulations are that the charity must be a nonprofit organization and the company will match only up to $2,000 per year per employee.

Assignment Directions

1. You will follow the Module 3 Excel Assignment link in Canvas to begin the assignment
2. Download the Module 3 Excel Start File and modify it using Microsoft Excel according to instructions below
3. You will upload your completed file to the link provided in the assignment

2. Excel technical help can be located in several places.
3. Tech Plugins 2, 3 and 4 from the textbook
4. Microsoft Office Help and Training: https://support.office.com/
5. YouTube videos

3. This assignment includes several Excel skills you must learn
4. Creating and naming a new tab
5. Copying and pasting data from one tab to another
6. Sorting data
7. Subtotal function (https://www.youtube.com/watch?v=H_cHbbVwvPQ)
8. 3D cell references

4. Excel Directions (Points)
5. Put your name in cell A1 of the Answers tab (0.5)
6. Create a separate tab to calculate each group of answers. (1.0)
7.       Create the tabs: “Sort”, “Total Donation”, “Average Donation “
8. Copy the data of the table from the Tracking Donation tab into the Sort tab (0.5)
9. Sort the table in the “Sort” tab on Organization (2.0)
10. Copy the sorted data from the Sort tab into the Total Donation tab (2.5)
11.       In the Total Donation tab Use the Subtotal function to sum Amount at each change in Organization
12.       Hide the details
13. Copy the sorted data from the Sort tab into the Average Donation tab (2.5)
14.       In the Average Donation tab Use the Subtotal function to find the average amount at each change in Organization
15.       Hide the details
16. Use a 3D cell reference to display the answers from the Total Donation and Average Donation tabs in the Answers tab (1.0)
17. Save the completed assignment file to your desktop and submit it using the link in the assignment

 

Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"