Projects Excel® worksheet.

1. Follow the directions below to create an Excel® worksheet.
• Open a new workbook and save it as Homework Plan.xlsx in the drive and folder where your Data Files are stored.
• Create a worksheet based on the table given below, which indicates hours of study for each course throughout the week.

 Biology Chemistry Anthro. History Total Study Time Mon. 1 0 1 0 Tues. 0 1 0 1 Wed. 0 1 1 1 Thurs. 1 0 1 1 Fri. 1 1 0 0

• Enter formulas to calculate the Total Study Time for the last column.
• Save the file as part of the zipped folder to be uploaded to iBoard.

1. Your company, Delicious Scoops, is a retailer of all-natural ice cream. The following table lists sales for the best-selling flavors over a one-year period. Open a new workbook and save it as Delicious Scoops.xlsx in the drive and folder where your Data Files are stored. Plan and build a worksheet based on the table shown here.

 Flavor Quarter 1 Quarter 2 Quarter 3 Quarter 4 Chocolate 570 620 375 452 Vanilla 315 420 178 315 Coffee 425 576 535 489 Butter Pecan 520 589 492 670

• Think about where you want the totals and averages for each flavor and each quarter. Where do you want totals to appear? Where do you want averages to appear?
• Enter the data shown in the table in the workbook.
• Calculate totals for sales of each flavor and each quarter.
• Calculate averages for sales of each flavor and each quarter.
• On a separate worksheet, calculate the impact of a 35% increase in sales for each flavor in each quarter.
• Enter your name in a cell in each sheet, save your work, and then preview each worksheet.
1. You manage a local toy store, Magical Beginnings. Because you learned how to use Excel®, you decide to use a workbook to calculate on-hand inventory values for products in the following table. Open a new workbook and save it as Magical Beginnings.xlsx in the drive and folder where your Data Files are stored. Plan and build a worksheet based on the table shown here.

 Product Wholesale Price On-Hand Total Value Retail Price Super Pets Action Figure 12.35 26 Rocketship Adventure Set 25.73 51 Ninja Ants 16.22 85 Baby Sleeps-a-lot 22.67 42

• Think about where you want the on-hand totals for all products to appear. Where do you want the average price to appear?
• Enter the data shown in the table in the workbook.
• Calculate the retail price of each product, assuming a 2.3% markup of the wholesale price.
• Calculate the average retail price of all the products.
• Calculate the total value for each product (hint: use the retail price, not the wholesale price).
• Enter you name in a cell, save your work, and then preview the worksheet.

PART II: Essay

• Directions:Write an essay that summarizes what you have learned in this section of your textbook and lecture notes. Your paper should be at least 2 pages in length, utilize APA style, and include a cover page and a bibliography.

Your summary must include all of the following topics: