Question
Your company, Flavoricious, is a retailer of all-natural ice cream. The following table lists sales for the best-selling flavors over a one-year period. Flavor Quarter
Your company, Flavoricious, is a retailer of all-natural ice cream. The following table lists sales for the best-selling flavors over a one-year period.
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
Open a new workbook and save it as Flavoricious in the drive and folder where your Data Files are stored. Plan and build two worksheets based on the table shown here.
1. Think about where you want the totals and averages for each flavor and each quarter.
2. Enter the data shown in the table on the worksheet
3. Calculate totals for sales of each flavor and each quarter.
4. Calculate averages for sales of each flavor and each quarter.
5. On a separate worksheet, calculate the impact of a 35% increase in sales for each flavor in each quarter.
6. Enter your name in a cell on each sheet, save your work, and then preview each worksheet.
7. Close the workbook and complete the Access project below.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started