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-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.