practice workbook chapter 03
.xlsx
keyboard_arrow_up
School
Central New Mexico Community College *
*We aren’t endorsed by this school
Course
101
Subject
History
Date
Dec 6, 2023
Type
xlsx
Pages
13
Uploaded by ChancellorSnow12162
Item
Pints sold
Pilsner
38
Belgian Style Dubbel
27
Amber ale
16
Classic IPA 61
Special Edition DIPA
43
Porter
18
Imperial Stout
35
Total Served
Use the spreadsheet tools to calculate the percentage of each style of beer sold at your taproom for this day. % of total served
Click here to check your work
Click here to go to the next activity
You will need t
the total--by th
anchor functio
=D9/$C$17
. . . and use the
to divide each of the beer styles--as well as he total served in cell C17, so you can use the on in cell D10 by typing: e fill handle to drag down to row 17.
% of total served
Item
Pints sold
Pilsner
38
16.0%
0.0%
Belgian Style Dubbel
27
11.3%
0.0%
Amber ale
16
6.7%
0.0%
Classic IPA 61
25.6%
0.0%
Special Edition DIPA
43
18.1%
0.0%
Porter
18
7.6%
0.0%
Imperial Stout
35
14.7%
0.0%
Total Served (correct)
238
100.0%
0.0%
Your answer
0
Click on the shaded cells below to see how each cell was calculated. If you used the anchor function for column D, you would have been able to use the fill handle to calculate the numbers for the whole column. Correct answer
Your answer
Click here to go back and review your answers
Click here to go to the next activity
Item
Popularity index
Pilsner
16.0%
72
Belgian Style Dubbel
11.3%
Amber ale
6.7%
Classic IPA 25.6%
Special Edition DIPA
18.1%
Porter
7.6%
Imperial Stout
14.7%
Total Served
100.0%
450
Assuming customer preferences remain steady, we can use the popularity index we calculated in the previous exercise to predict future sales. If we project 450 beers sold for the next day, use the spreadsheet tools to calculate the percentage of each style of beer you would be likely to sell. Projected Sales
Click here to check your work
Click here to go to the next activity
click here to go to the previous activity
Hint: Use the "ROUNDU
next-highest who
Use the anchor fu
UP" function and round to the ole number. unction to speed up your work.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help