Microsoft Excel project to track donations. Please include the correct functions.

Apply Your Knowledge Project 4 - Tracking Donations Input boxes in tan Output boxes in yellow Given data in blue Answers in red edge Submitted 12/6/2011 12/16/2011 12/5/2011 12/10/2011 12/6/2011 12/27/2011 12/13/2011 12/27/2011 12/4/2011 11/29/2011 12/2/2011 12/3/2011 12/3/2011 12/2/2011 12/12/2011 12/20/2011 12/5/2011 12/12/2011 12/9/2011 12/6/2011 12/16/2011 12/3/2011 12/14/2011 12/17/2011 2/6/2011 2/16/2011 2/5/2011 2/10/2011 2/6/2011 2/27/2011 2/13/2011 2/27/2011 2/4/2011 1/29/2011 2/2/2011 2/3/2011 2/3/2011 2/2/2011 2/2/2011 2/20/2011 2/5/2011 2/2/2011 2/9/2011 2/6/2011 2/16/2011 2/3/2011 2/14/2011 2/17/2011 6/6/2011 Employee ID Last Name 211 Smith 234 Daniels 243 Bagley 334 Kellee 345 Cross 365 Lee 366 Smith 370 Wills 389 Fisher 432 Ash 454 Cross 456 Butler 499 Cross 543 Fisher 546 Daniels 558 Los 654 Ash 657 Rogers 675 Ash 832 Haitz 867 Daniels 945 Williams 977 Rogers 987 Haim 21 Smith 234 Daniels 243 Bagley 334 Kellee 345 Cross 365 Lee 366 Smith 370 Wills 389 Fisher 432 Ash 454 Cross 456 Butler 499 Cross 543 Fisher 546 Daniels 558 Los 654 Ash 657 Rogers 675 Ash 832 Haitz 867 Daniels 945 Williams 977 Rogers 987 Haim 25 Smith First Name James Julie Bob Pete Roberta Sufeing James Mary Scott Jamie Roberta Amy Roberta Scott Julie Jim Carlin Scott Scott Todd Julie James Scott Gary James Julie Bob Pete Roberta Sufeing James Mary Scott Jamie Roberta Amy Roberta Scott Julie Jim Carlin Scott Scott Todd Julie James Scott Gary James Organization Diabetic Association Make a Wish Foundation Cancer Society Police Federation Leukemia Society Homeless Shelters Habitat for Humanity Habitat for Humanity Cancer Society Habitat for Humanity Make a Wish Foundation Cancer Society Animal Shelter Meals on Wheels Amnesty International Meals on Wheels Diabetic Association Animal Shelter Diabetic Association Cancer Society Make a Wish Foundation Vietnam Veterans Homeless Shelters Diabetic Association Diabetic Association Make a Wish Foundation Cancer Society Police Federation Leukemia Society Homeless Shelters Habitat for Humanity Habitat for Humanity Cancer Society Habitat for Humanity Make a Wish Foundation Cancer Society Animal Shelter Meals on Wheels Amnesty International Meals on Wheels Diabetic Association Animal Shelter Diabetic Association Cancer Society Make a Wish Foundation Vietnam Veterans Homeless Shelters Diabetic Association Diabetic Association Amount $50 $225 $25 $180 $60 $25 $150 $100 $125 $50 $75 $250 $20 $125 $200 $115 $100 $35 $100 $50 $130 $60 $80 $50 $50 $225 $25 $180 $60 $25 $150 $100 $25 $50 $75 $250 $20 $25 $200 $15 $100 $35 $100 $50 $130 $60 $80 $50 $50 6/16/2011 6/5/2011 6/10/2011 6/6/2011 6/27/2011 6/13/2011 6/27/2011 6/4/2011 5/29/2011 6/2/2011 6/3/2011 6/3/2011 6/2/2011 6/6/2011 6/20/2011 6/5/2011 6/6/2011 6/9/2011 6/6/2011 6/16/2011 6/3/2011 6/14/2011 6/17/2011 9/9/2011 9/19/2011 9/8/2011 9/10/2011 9/9/2011 9/27/2011 9/13/2011 9/27/2011 9/4/2011 8/29/2011 9/2/2011 9/3/2011 9/3/2011 9/2/2011 9/9/2011 9/20/2011 9/8/2011 9/9/2011 9/9/2011 9/9/2011 9/19/2011 9/3/2011 9/14/2011 9/17/2011 234 Daniels 243 Bagley 334 Kellee 345 Cross 365 Lee 366 Smith 370 Wills 389 Fisher 432 Ash 454 Cross 456 Butler 499 Cross 543 Fisher 546 Daniels 558 Los 654 Ash 657 Rogers 675 Ash 832 Haitz 867 Daniels 945 Williams 977 Rogers 987 Haim 28 Smith 234 Daniels 243 Bagley 334 Kellee 348 Cross 398 Lee 399 Smith 370 Wills 389 Fisher 432 Ash 484 Cross 489 Butler 499 Cross 843 Fisher 849 Daniels 888 Los 984 Ash 987 Rogers 978 Ash 832 Haitz 897 Daniels 948 Williams 977 Rogers 987 Haim Julie Bob Pete Roberta Sufeing James Mary Scott Jamie Roberta Amy Roberta Scott Julie Jim Carlin Scott Scott Todd Julie James Scott Gary James Julie Bob Pete Roberta Sufeing James Mary Scott Jamie Roberta Amy Roberta Scott Julie Jim Carlin Scott Scott Todd Julie James Scott Gary Make a Wish Foundation Cancer Society Police Federation Leukemia Society Homeless Shelters Habitat for Humanity Habitat for Humanity Cancer Society Habitat for Humanity Make a Wish Foundation Cancer Society Animal Shelter Meals on Wheels Amnesty International Meals on Wheels Diabetic Association Animal Shelter Diabetic Association Cancer Society Make a Wish Foundation Vietnam Veterans Homeless Shelters Diabetic Association Diabetic Association Make a Wish Foundation Cancer Society Police Federation Leukemia Society Homeless Shelters Habitat for Humanity Habitat for Humanity Cancer Society Habitat for Humanity Make a Wish Foundation Cancer Society Animal Shelter Meals on Wheels Amnesty International Meals on Wheels Diabetic Association Animal Shelter Diabetic Association Cancer Society Make a Wish Foundation Vietnam Veterans Homeless Shelters Diabetic Association $225 $25 $180 $60 $25 $150 $100 $65 $50 $75 $250 $20 $65 $200 $55 $100 $35 $100 $50 $130 $60 $80 $50 $80 $228 $28 $180 $90 $28 $180 $100 $98 $80 $78 $280 $20 $98 $200 $88 $100 $38 $100 $80 $130 $90 $80 $80 Donation Sent 12/19/2011 12/29/2011 12/6/2011 12/14/2011 12/19/2011 12/30/2011 12/23/2011 12/29/2011 12/10/2011 12/1/2011 12/4/2011 12/10/2011 12/5/2011 12/26/2011 12/21/2011 12/22/2011 12/6/2011 12/15/2011 12/18/2011 12/14/2011 12/21/2011 12/13/2011 12/19/2011 12/22/2011 2/19/2011 2/29/2011 2/6/2011 2/14/2011 2/19/2011 2/30/2011 2/23/2011 2/29/2011 2/10/2011 2/1/2011 2/4/2011 2/10/2011 2/5/2011 2/26/2011 2/21/2011 2/22/2011 2/6/2011 2/15/2011 2/18/2011 2/14/2011 2/21/2011 2/13/2011 2/19/2011 2/22/2011 6/19/2011 6/29/2011 6/6/2011 6/14/2011 6/19/2011 6/30/2011 6/23/2011 6/29/2011 6/10/2011 6/1/2011 6/4/2011 6/10/2011 6/5/2011 6/26/2011 6/21/2011 6/22/2011 6/6/2011 6/15/2011 6/18/2011 6/14/2011 6/21/2011 6/13/2011 6/19/2011 6/22/2011 9/19/2011 9/29/2011 9/9/2011 9/14/2011 9/19/2011 9/30/2011 9/23/2011 9/29/2011 9/10/2011 9/1/2011 9/4/2011 9/10/2011 9/8/2011 9/29/2011 9/21/2011 9/22/2011 9/9/2011 9/18/2011 9/18/2011 9/14/2011 9/21/2011 9/13/2011 9/19/2011 9/22/2011 TOTAL DONATIONS PER ORGANIZATION Organization Amnesty International Total Animal Shelter Total Cancer Society Total Diabetic Association Total Habitat for Humanity Total Homeless Shelters Total Leukemia Society Total Make a Wish Foundation Total Meals on Wheels Total Police Federation Total Vietnam Veterans Total Grand Total Amount AVERAGE DONATION PER ORGANIZATION Organization Amnesty International Total Animal Shelter Total Cancer Society Total Diabetic Association Total Habitat for Humanity Total Homeless Shelters Total Leukemia Society Total Make a Wish Foundation Total Meals on Wheels Total Police Federation Total Vietnam Veterans Total Grand Average Amount