Nahor Excel 4

Documentation

Projects Office 2010

%(1B885A789636ED21-DE5F3402B00DBDB2)%

SAM Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper

Emerge EXCEL 2010 CP4a – Screaming Ice Cream Shoppes

DO NOT DELETE–>

%(1B885A789636ED21-DE5F3402B00DBDB2)%

Author

Kenya Sheard

Note: Do not edit this sheet. If your name does not appear in cell B4, please download a new copy of the start file from the SAM web site.

nhqbdvkhdug

Age Group Data

s Purchased by Age Group
for the dates: 6/1/2013 to 8/31/2013

Flavor

Adults

188 218

Total

	Flavor
Kids & Teens	Young	Adults	Seniors		Total
IceC 1	248	321	311	290	859
IceC 2	195	425	395	278	898
IceC 3	617	921	875	345	1,883
IceC 4	1,022	2,877	2,104	1,298	5,197
IceC 5	3,861	4,211	3,721	3,467	11,539
IceC 6	4,288	4,994	2,865	1,012	10,294
IceC 7	2,691		218	458		188	3,097
IceC 8	944	2,044	3,498	1,911	4,899
IceC 9	534	718	1,124
14,054	16,229	14,761	9,507	39,790

Emerge excel 2010

CUmulative Project 4

screaminG Ice cream

Skills

2 SAM PROJECTS 2010 – CENGAGE LEARNING

SAM PROJECTS 2010 – CENGAGE LEARNING 3

Save a workbook with a new name

Create a column chart

Move a chart to a new worksheet

Reorder worksheets

Apply a style to a chart

Insert a chart title

Format a chart title

Remove the legend from a chart

Insert a vertical axis title

Rotate and tilt a 3-D chart

Modify the depth axis

Insert a chart data table

Format a data series

Select non-adjacent cells

Create a 3-D pie chart

Move a chart as an object to a different sheet

Add data labels

Format a chart area

Resize a chart

Position a chart

Add data bars to a range of cells

Edit a conditional formatting rule

Project overview

Aurora DuMont is the Director of Marketing at Screaming Ice Cream Shoppes, a privately owned gourmet ice cream shop that has stores in five beach towns in Suffolk County, NY. Last summer, she decided to do some in store market research on which customers where buying which flavors. She programmed the registers so that the clerks could record two facts about each purchase; the type of customer and the flavor ice cream bought. Customers were divided into four approximate age groups: Kids and teens under 20, Young Adults 21-40, Adults 41-60, and Seniors 61 and over. The same nine flavors were available in each store during the survey months. She wants to create a chart sheet that displays the ice cream flavor and purchase data. She has transferred the data into an Excel workbook. Ice cream flavors are coded IceC 1 to IceC 9 to keep the survey unbiased. She compiled the data from all five stores. She asks you to present this data in a 3-D Pyramid chart for an upcoming meeting with the company owners. She wants the chart to show the flavor purchase totals organized by age group. She also wants an exploded 3-D pie chart superimposed on the column chart and a table of ice cream flavor purchase data.

STUDENT start FILE

Emerge_Excel2010_ CP4a_FirstLastName_1.xlsx
(Note: Download your personalized start file from www.cengage.com/sam2010)

Instructions

Open the file Emerge_Excel2010_ CP4a_FirstLastName_1.xlsx and save the file as Emerge_Excel2010_ CP4a_FirstLastName_2.xlsx before you move to the next step. Verify that your name appears in cell B4 of the Documentation sheet. (Note: Do not edit the Documentation sheet. If your name does not appear in cell B4, please download a new copy of the start file from the SAM Web site.)

In the Age Group Data worksheet, select the range A3:E12, and then insert the 3-D Pyramid chart (the last chart in the Pyramid section in the Charts gallery).

Move the chart to a chart sheet named Survey Charts. (Note: Be sure to choose the “New sheet” option button rather than the “Object in” option button.) Move the Survey Charts chart sheet to be the last sheet in the workbook.

Change the style of the chart to Style 10 (the second column in the second row in the Chart Styles gallery).

Insert the chart title using the Above Chart Title format, change the title to Screaming Ice Cream Summer Survey, and then set its font size to 28 points. Remove the legend from the chart.

Add the title Scoops Purchased to the vertical axis, using the Rotated Title option. Set the font size to 20 points.

Rotate the 3-D chart using the following parameters: x-axis rotation 40°, y-axis rotation 30°, perspective 25°, and depth to 140. (Hint: If necessary, uncheck the Right Angle Axes check box in the Chart Scale section to make the Perspective box active.)

Modify the depth axis so the values are displayed in reverse order. (Hint: Use the Axes button in the Axes group on the Chart Tools Layout tab to modify the depth axis using the Show Reverse Axis option.)

Insert a data table without legend keys below the 3-D chart to provide the data values for the different columns. (Hint: Use the Data Table button in the Labels group on the Chart Tools Layout tab.)

Change the fill color of the Seniors series to standard Yellow.

In the Age Group Data worksheet, select the range B3:E3; B13:E13, and then insert a Pie in 3-D chart. Move the chart to be an object in the Survey Charts chart sheet.

Insert a chart title using the Above Chart Title format with the text Total Scoops, and set its font size to 14 points and its font color to Black, Text 1, Lighter 25%.

Change the fill color of the Seniors slice to standard Yellow.

Remove the chart legend from the pie chart.

Add data labels to the Center of the pie chart, displaying each slice’s value.

Change the shape fill of the pie chart to No Fill (removing the fill color) and change the shape outline to No Outline (removing the border). Resize and move the embedded pie chart to the lower-left of the column chart so that the chart sheet matches Figure 1 below.

FIGURE 1 (Chart Sheet)

Go to the Age Group Data worksheet, and then add Gradient Fill – Orange Data Bar data bars to the range B4:E12. Modify the rule for the data bars so that the maximum data bar length matches a value of 10,000. Your completed Age Group Data worksheet should look like the Figure 2 below.

Save your changes, close the workbook and exit Excel. Follow the directions on the SAM Web site to submit your completed project.

FIGURE 2 (Age Group Data worksheet)