Business Driven Technology 6th Edition by Paige Baltzan

تمرين 76

Tracking Donations
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.
Project Focus
Open the data file AYK4_Data.xlsx and determine the following:
What was the total donation amount per organization
What were the average donations per organization
Data File: AYK4_Data.xlsx