Challenge Project 3-9

For this project, you create a worksheet and accompanying bar chart to illustrate zoo animal categories and the number of adopter families.

[Student Learning Outcomes 3.1, 3.2, 3.3, 3.4, 3.5]

File Needed: None

Completed Project File Name: [your initials] Excel 3-9.xlsx

Create a new workbook and save it as [your initials] Excel 3-9. Modify your workbook according to the following guidelines:

• In cells A3:A7, type the category name for five animal groups such as lions, orangutans, and monkeys.
• In cells B3:B7, type a value to represent how many zoo patrons have “adopted” an animal in that category.
• Create a 2-D bar chart object and place it below the data.
• Change the layout or apply a chart style.
• Edit the chart title placeholder to display an appropriate title.
• Review the icons available [Insert tab]; select the Animal category. Select a worksheet cell and insert an icon that represents one of your categories. Copy the icon to the Clipboard and then use it as fill for the appropriate bar.
• Insert and copy additional icons as desired.
• Format chart elements to complete your work.
• Type a main label in cell A1 for the worksheet data.
• Format the data in rows 1:7 to complement the chart.