Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

12. Donations spreadsheet and email Most of the people to whom you sent letters have sent donations to Compton Memorial Hospital. Open the Microsoft Excel

image text in transcribed
image text in transcribed
image text in transcribed
12. Donations spreadsheet and email Most of the people to whom you sent letters have sent donations to Compton Memorial Hospital. Open the Microsoft Excel file CH07 Donations and add three columns to the right of the ZIP Code column. Name the first column Donation. Name the second column Matching Funds. Name the third column Total. Enter the amount shown below for each person in the Donation column. Enter a formula to copy the amounts into the Matching Funds column. Enter a formula in the Total column to add the donation and the matching funds. Sum the Donation column to find the total donations from these patrons. Sum the Total column to find the total donations, including the matching funds. Send an email message to your supervisor, Ms. Tamarick. (Send the message to your instructor.) second column Matching Funds. Name the third column Total. Enter the amount shown below for each person in the Donation column. Enter a formula to copy the amounts into the Matching Funds column. Enter a formula in the Total column to add the donation and the matching funds. Sum the Donation column to find the total donations from these patrons, Sum the Total column to find the total donations, including the matching funds. Send an email message to your supervisor, Ms. Tamarick. (Send the message to your instructor.) Indicate the number of people who sent donations, the total amount donated, and the total including the matching funds. Indicate that she can see the individual donation amounts in the attached spreadsheet Attach the Microsoft Excel file to the email message. (Learning Objective 4) Sheet1 i. 8 Type here to search

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Tools for business decision making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

6th Edition

978-1119191674, 047053477X, 111919167X, 978-0470534779

More Books

Students also viewed these Accounting questions

Question

Relational Contexts in Organizations

Answered: 1 week ago