Where do you want the average price to appear?

Projects Excel® worksheet.

Directions: Please complete the following tasks. Be sure to read the directions carefully.

 

 

  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 your changes and preview your worksheet.
  • 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:

  • Understand spreadsheet software
  • Tour the Excel® 2013 window
  • Understand formulas
  • Enter labels and values and use the Sum button
  • Edit cell entries
  • Enter and edit a simple formula
  • Switch worksheet views
  • Choose print options

Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.