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 firm$$s donation per employee may not

exceed $$500$ a year.

Don has provided the data on the Excel file, Excel$2$Template.xlsx$,$ to record the firm$$s donations.

Included in this file are the dates the request for a donation was submitted, the employee$$s 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 employee$$s last

name.

$2.$ One worksheet that totals $($use the Subtotal feature$)$ the contribution made per employee for

the month of December.

$3.$ One worksheet that sorts the list by donation valu