Creating a Template and Quarterly Reports

Anonymous
timer Asked: Oct 16th, 2018
account_balance_wallet $9.99

Question Description

Purpose: To demonstrate the ability to create and save a template and to create a multiple-sheet workbook with 3-D totals.

Problem: You have been performing some volunteer work for a not-for-profit organization called the Council on American Wellness. The council specializes as a clearinghouse that provides information and services to corporations of all sizes on healthy living and well workplace environments. The council’s income is derived from seminars, contests, fund-raising luncheons, and corporate sponsorships. The board of director wishes to see the income generated each quarter by the various activities and to have this data available on the World Wide Web. You have agreed to create a spreadsheet that will set up the data entry for the four quarters.

Unformatted Attachment Preview

Creating a Template and Quarterly Reports Purpose: To demonstrate the ability to create and save a template and to create a multiple-sheet workbook with 3-D totals. Problem: You have been performing some volunteer work for a not-forprofit organization called the Council on American Wellness. The council specializes as a clearinghouse that provides information and services to corporations of all sizes on healthy living and well workplace environments. The council’s income is derived from seminars, contests, fund-raising luncheons, and corporate sponsorships. The board of director wishes to see the income generated each quarter by the various activities and to have this data available on the World Wide Web. You have agreed to create a spreadsheet that will set up the data entry for the four quarters. Instructions: Perform the following tasks: 1. 2. 3. 4. 5. 6. 7. Create the template shown in Figure E6A – 1. Bold all the cells. Change the font in the template title to Comic Sans MS (or a similar font) 16 point. Place a dark red border around the first row title along with a black border around the column headings and the total rows. Place a black border down the left and right sides of the spreadsheet from rows 3 through 11. Italicize the column headings in row 2. Format cells C3 through F11 as comma style with two decimal places. Format the Total row as currency with a floating dollar sign and two decimal places. Enter the data for the 1st Quarter as shown in Figure E6A – 1. Use the sum function to determine the totals in columns C through F. Use the sum function to determine the totals for rows 3 through 11. Create the 3-D pie chart that shows the percentage of each contribution for the quarter. Use the chart ranges A3:A11 and F3:F11. Rename Sheet 1, 1st Quarter. Save the template using the file name, Yourname - Excel Chapter 6 – Lab Test A Template, where Yourname is your own last name. Page 1 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. Make sure the Save as File Type box is set to Template. Close the template. Open the template, insert Sheet 4, and copy the template to Sheet 2, Sheet 3, and Sheet 4. Save the workbook using the filename, Yourname - Excel Chapter 6 – Lab Test A. Rename Sheet 2 to 2nd Quarter, Sheet 3 to 3rd Quarter, and Sheet 4 to 4th Quarter. Delete the data in the 2nd, 3rd, and 4th quarters. Insert the data for the 2nd Quarter sheet using the data in Table E6A – 1. Insert the data for the 3rd Quarter sheet using the data in Table E6A – 2. Insert the data for the 4th Quarter sheet using the data in Table E6A – 3. Make sure the chart range on each sheet refers to the data on the same sheet. Save the workbook. Select all four sheets. Change the header to include your name and the sheet name. Change the footer to include the page number and total number of pages. Print the workbook. Insert a fifth sheet at the end of the workbook and name it Totals. Use the Fifth sheet to sum the data from all four quarters as shown in Figure E6A – 2. Print the Totals Sheet and save the workbook. Save the First Quarter Sheet as a PDF. Make sure to click the Options button in the PDF dialog box and then select entire workbook. Publish it as Lab Test A - Excel Chapter 6.pdf. With both Excel files open, save the workspace as Lab Test A Workspace.xlw. Page 2 Activity Apr Seminar - HMO or PPO Insurance? 8-Apr Contest - Easter Egg Hunt 19Apr Seminar - Fit or Fat with Covert Bailey May Jun 660.00 445.00 13Jun 830.00 Seminar - Diabetes Awareness 9-May 390.00 Seminar - Hypertension Contest - Softball Tourney 30Apr 680.00 17May Corp. Sponsorship - Midwest Elect. 2-Jun Corp. Sponsorship - Midwest Gas 5-May 770.00 250.00 200.00 Table E6A – 1 Activity Jul Contest - Independence Day Bowl 5-Jul Luncheon - Fund-raiser 21-Jul Aug Sep 710.00 495.00 Corp. Sponsorship - Wayne Co. 15-Jul 270.00 Seminar - Handling the Heat 8-Aug 440.00 Contest – Swimming Contest - Labor Day Tourney 23Aug 506.00 1-Sep 820.00 Corp. Sponsorship – Southeast 15Steel Sep 300.00 Corp. Sponsorship – Southeast 30Glass Sep 250.00 Seminar - Heart Healthy Meals 24Sep 585.00 Table E6A – 2 Page 3 Activity Corp. Sponsorship Oct Nov Dec 1-Oct 100.00 Seminar - Weight Loss Exercises 6-Oct Contest - Fall Dance 11Oct Luncheon - Fund-raiser 345.00 730.00 10Nov 290.00 Seminar - Heart Healthy Meals 14Nov 580.00 Contest - Bowl for Turkeys 22Nov 670.00 Contest - Bowl for Christmas Ham 13Dec 621.00 Contest – Christmas Party 22Dec 761.00 Table E6A – 3 Page 4 Figure E6A – 1 Page 5 Figure E6A – 2 Page 6 ...
Purchase answer to see full attachment

Tutor Answer

Bacote
School: Carnegie Mellon University

Attached.

First Quarter

Student-Name

Council on American Wellness
Quarterly Income
Jan-March2009
Activity
Seminar- Well Work Place
Seminar-Cancer Prevention
Seminar-Weight Control
Seminar-Stop smoking
Contest-Cabin Fever Break out
Contest-Dancing for Hearts
Contest- Three on Three Basketball
Corp.Sponsorship-County Hospital
Corp.Sponsorship-Southeast Bell
Totals

Corp.SponsorshipSoutheast Bell
6%
Corp.SponsorshipContestCounty Hospital
Three on
6%
Three
Basketball
10%

Date
Jan
Feb
Mar
Total
14-Jan
760.00
760.00
6-Feb
430.00
430.00
5-Mar
740.00
740.00
19-Feb
890.00
890.00
27-Jan
780.00
780.00
12-Feb
670.00
670.00
27-Mar
550.00
550.00
3-Feb
300.00
300.00
3-Mar
300.00
300.00
$ 1,540.00 $ 2,290.00 $ 1,590.00 $ 5,420.00

First Quarter income

Seminar- Well
Work Place
14%

Seminar-Cancer
Prevention
8%
Seminar-Weight
Control
14%

ContestDancing
for Hearts
12%

1st Quarter

Contest-Cabin
Fever Break out
14%

Seminar-Stop
smoking
16%

Page 1 of 4

First Quarter

Student-Name

Council on American Wellness
Quarterly Income
Jan-March2009
Totals
Date
Apr
May
Jun
Total
Seminar- HMO orPPO Insurance
8-Apr
660.00
660.00
445.00
Contest -Easter Egg Hunt
14-Apr
445.00
Seminar-Fit or Fat with Covert Bailey
13-Jun
830.00
830.00
Seminar-Diabetes Awareness
9-May
390.00
390.00
Seminar- Hypertension
30-Apr
680.00
680.00
Contest -Softball Tourney
17-May
770.00
770.00
Corp.Sponsorship-Midwest Elect
2-Jun
250.00
250.00
Corp.Sponsorship-Midwest Gas
5-May
200.00
200.00
Totals
$ 1,785.00 $ 1,360.00 $ 1,080.00 $ 4,225.00

Second Quarter income
Corp.SponsorshipMidwest Elect
6%

Contest -Softball
Tourney
18%

Seminar- HMO
orPPO Insurance
16%

Seminar-Fit or Fat
with Covert Bailey
20%

SeminarHypertension
16%

Seminar-Diabetes
Awareness
9%

2nd Quarter

Corp.SponsorshipMidwest Gas
5%

Page 2 of 4

Contest -Easter
Egg Hunt
10%

First Quarter

Student-Name

Council on American Wellness
Quarterly Income
Jan-March2009
Activity
Contest -Idependence Day Bowl
Luncheon -Fund Raiser
Corp. Sponsorhip -Wayne Co
Seminar- Handling the Heat
Contest-Swimming
Contest- Labour Day Tourney
Corp. Sponsorhip -Southeast Steel
Corp. Sponsorship- Southeast Glass
Seminar- Heart Healthy Meals
Totals

Date

July

5-Jul
21-Jul
15-Jul
8-Aug
23-Aug
1-Sep
15-Sep
30-Sep
24-Sep

Aug

Corp.
Sponsorhip
-Southea...

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors