Case Study - Better World Recycling
In 2010, Maria Guzman and Edward McKay, a couple of college friends, opened Better World Recycling, a collection site for recyclable plastics. Since then, they have expanded the business to accept other types of recyclable items, including paper, glass, metal, Styrofoam, and plastic. The company also expanded from the original location in Columbia, Kansas, to two additional locations-Richmond, Indiana, and Marion, Iowa. With the expansion, Maria assumed the duties and title of COO (Chief Operating Officer) and Edward became the CEO (Chief Executive Officer).
Maria, working in Columbia, is responsible for analyzing collections at all locations. Each recycling site tracks the amount of each material it collects during each quarter. Each site enters this information in a workbook, which is sent to Maria to consolidate and analyze. Maria has received the workbooks with the quarterly collections data for the past year from all three locations-Columbia, Richmond, and Marion. She wants you to create a worksheet in each workbook that summarizes the collection totals.
Grouping Worksheets
Workbook data is often placed in several worksheets. Using multiple worksheets makes it easier to group and summarize data. For example, a company such as Better World Recycling with branches in different geographic regions can place collection information for each region in separate worksheets. Rather than scrolling through one large and complex worksheet that contains data for all regions, users can access collection information for a specific region simply by clicking a sheet tab in the workbook. Using multiple worksheets enables you to place summarized data first. Managers interested only in an overall picture can view the first worksheet of summary data without looking at the details available in the other worksheets. Others, of course, might want to view the supporting data in the individual worksheets that follow the summary worksheet. In the case of Better World Recycling, Maria used separate worksheets to summarize the amount of each item collected at the Columbia location for each quarter of the 2016 fiscal year.
1. Download all Excel Tutorial 6 files from Blackboard. Open the Kansas workbook and then save the document as Columbia in your
newly created Excel Tutorial 6 folder; located in your class folder.
2. In the Documentation worksheet, enter your name and the date.
3. Go to the Quarter 1 worksheet, and then view the recycling data for the first quarter of the year.
4. Review the Quarter 2, Quarter 3, and Quarter 4 worksheets. The layout for all four worksheets are identical.
In the Columbia workbook, you'll group an adjacent range of worksheets-the Quarter 1 worksheet through the Quarter 4 worksheet.
To group the quarterly worksheets:
1. Click the Quarter 1 sheet tab to make the worksheet active. This is the first worksheet you want to include in the group.
2. Press and hold the Shift key, and then click the Quarter 4 sheet tab. This is the last worksheet you want to include in the group.
3. Release the Shift key. The sheet tabs are white, the green border at the bottom of the sheet tab extends across all the tabs, and the sheet tab labels, Quarter 1 through Quarter 4, are in bold, indicating they are all selected. The text "[Group]" appears in the title bar to remind you that a worksheet group is selected in the workbook.
You can change which worksheet in a worksheet group is active. Just click the sheet tab of the worksheet you want to make active. If a worksheet group includes all the worksheets in a workbook, you cannot change which worksheet is the active sheet because clicking a sheet tab ungroups the worksheets.
Attachment:- New WinRAR archive.rar