Wellness center

Anonymous
timer Asked: Oct 22nd, 2018
account_balance_wallet $20

Question Description

using the format from the wellness center where we have to create our own business.

using the format from the wellness center where we have to create our own business.

using the format from the wellness center where we have to create our own business.

using the format from the wellness center where we have to create our own business.

(These file are examples, do not copy those, except format, and there are 4 quarters in the assignment)

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 First Quarter Yuehao Ren 10/22/2018 Council on American Wellness Quarterly Income JanMarch2009 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.SponsorshipCounty Hospital Contest6% Three on Three Basketball 10% ContestDancing for Hearts 12% 1st Quarter 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 Contest-Cabin Fever Break out 14% Seminar- Well Work Place 14% Seminar-Cancer Prevention 8% Seminar-Weight Control 14% Seminar-Stop smoking 16% Page 1 of 5 Second Quarter Yuehao Ren 10/22/2018 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 Corp.SponsorshipSecond Midwest Gas 5% Corp.Sponsorship- Quarter income Midwest 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 Contest -Easter Egg Hunt 10% Page 2 of 5 Third Quarter Yuehao Ren 10/22/2018 Council on American Wellness Quarterly Income 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 Jan-March2009 Date July 5-Jul 21-Jul 15-Jul 8-Aug 23-Aug 1-Sep 15-Sep 30-Sep 24-Sep Aug Corp. Sponsorhip -Southeast Steel 7% Contest- Labour Day Tourney 19% 3rd Quarter Total 270.00 440.00 506.00 $ 1,475.00 Third Quarter income Corp. SponsorshipSoutheast Glass 6% Sep 710.00 495.00 Seminar- Heart Healthy Meals 13% $ 946.00 Contest Idependence Day Bowl 16% Luncheon -Fund Raiser 11% Seminar- Handling the Heat 10% Contest-Swimming 12% Page 3 of 5 820.00 300.00 250.00 585.00 $ 1,955.00 $ Corp. Sponsorhip -Wayne Co 6% 710.00 495.00 270.00 440.00 506.00 820.00 300.00 250.00 585.00 4,376.00 Fourth Quarter Yuehao Ren 10/22/2018 Council on American Wellness Quarterly Income Activity Corp. Sponsorship Seminar -Weight Loss Exercises Contest- Fall Dance Luncheon- Fund raiser Seminar -Heart Healthy Meals Contest- Bowl for Turkeys Contest - Bowl for Christmas Ham Contest - Christmas Party Totals Jan-March2009 Date Oct 1-Oct 6-Oct 11-Oct 10-Nov 14-Nov 22-Nov 13-Dec 22-Dec Nov 730.00 290.00 580.00 670.00 1,175.00 Fourth Quarter income Corp. Sponsorship 3% Contest - Christmas Party 19% Contest - Bowl for Christmas Ham 15% 4th Quarter Total 100.00 345.00 $ Contest- Bowl for Turkeys 16% Dec $ 1,540.00 $ 621.00 761.00 1,382.00 $ Seminar Weight Loss Exercises 8% Contest- Fall Dance 18% Seminar -Heart Healthy Meals 14% Page 4 of 5 LuncheonFund raiser 7% 100.00 345.00 730.00 290.00 580.00 670.00 621.00 761.00 4,097.00 Council on American Wellness Quarterly Income Activity Totals Jan-Dec 2009 1st QTR 2nd Qtr 3rd Qtr 4th QTr Total $ 5,420.00 $ 4,225.00 $ 4,376.00 $ 4,097.00 $ 18,118.00 ...
Purchase answer to see full attachment

Tutor Answer

ProfessorRemirez
School: Duke University

Attached.

1

Wellness Center

Student name:
Institutional affiliation:

2
Wellness Center
The attached excel file addresses the question “Wellness center” as follows:


Demonstrating the ability to create and save a template and to create a multiple-sheet
workbook with 3-D totals.


First Quarter

Yuehao Ren

10/22/2018

Pan AMerican Health Organization (PAHO)
Quarterly Income
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

Jan-March 2016

Date
Jan
Feb
Mar
Total
14-Jan
820.00
820.00
6-Feb
370.00
370.00
5-Mar
700.00
700.00
19-Feb
625.00
625.00
27-Jan
764.00
764.00
12-Feb
650.00
650.00
27-Mar
200.00
200.00
...

flag Report DMCA
Review

Anonymous
Thank you! Reasonably priced given the quality not just of the tutors but the moderators too. They were helpful and accommodating given my needs.

Similar Questions
Hot Questions
Related Tags
Study Guides

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