Business Technology
Where’s the Beef Burger Barn
Instructions:
1. Enter your full name(left aligned), block & grade (centered), and date (right aligned) in the header (Under the drop-down menu ‘VIEW’
2. Save file as: WheresTheBeef
3. Enter the formula for cells D3 to D12 to show the total cost of each item ordered which is the Number of items * Unit Cost (for example: =B3*C3)
4. Use autoSum to subtotal the total cost of the items sold in cell D15 (=sum(D3:D12))
5. Enter the formula in D16 for amount of tax to charge (=D15*.07)
6. Enter the formula in D17 for the grand total the subtotal + tax (=D15+D16)
7. Enter the formula in D19 for the Change from amount tendered (=D17–D16)
8. Name the four types of information you can put in a spreadsheet cell:
a. ______
b. ______
c. ______
d. ______
9. a. What number type is in cell C7? ______
b. Which of the four cell types is it? ______
10. If you change the value in cell C3, what other cell(s) will change too? ______
11. Which of the four cell types is in cell A4? ______
12. Which column has just labels in it? ______
13. What is the formula for cell D14? ______
14. What is the formula for cell D15? ______
15. What is the formula for cell D16? ______
16. What is the formula for cell D17? ______
17. What is the formula for cell D18? ______
18. If the following items were ordered:
· 3 garden burgers
· 1 grilled veggie chick
· 3 baked fries
· 2 very berry juice
· 1 herbal teas
a. What was the total cost of the food (including tax)? ______
b. What was the amount ofchange if the customer paid $20.00? ______
Please clear the cell contents of the Numbers Column (B) before working on this question
19. If the following items were ordered:
· 1 garden burgers
· 1 mock tuna melt
· 2 baked fries
· 1 very berry juice
· 1 soy milk
a. What was the total cost of the food (including tax)? ______
b. What was the amount of change if the customer paid $15.00? ______
Please clear the cell contents of the Numbers Column (B) before working on this question
20. If the following items were ordered:
· 1 tofu ‘cheez’burgers
· 2 mock tuna melt
· 2 onion rings
· 1 very berry juice
· 1 soy milk
· 1 herbal tea
a. What was the total cost of the food (including tax)? ______
b. What was the amount of change if the customer paid $25.00? ______
Please clear the cell contents of the Numbers Column (B) before working on this question
21. If the following items were ordered:
· 3 grilled veggie chicks
· 1 onion rings
· 1 very berry juice
· 2 very berry juice
· 2 herbal tea
a. What was the total cost of the food (including tax)? ______
b. What was the amount of change if the customer paid $18.00? ______
22. If the following items were ordered:
· 3 baked fries
· 2 onion rings
· 2 lemon spritzs
· 3 herbal tea
c. What was the total cost of the food (including tax)? ______
d. What was the amount of change if the customer paid $10.00? ______
23. If the following items were ordered:
· 3 grilled veggie chicks
· 1 onion rings
· 1 very berry juice
· 2 very berry juice
· 2 herbal tea
e. What was the total cost of the food (including tax)? ______
f. What was the amount of change if the customer paid $18.00? ______
24. If the following items were ordered:
· 1 garden burgers
· 1 tofu ‘cheez’burger
· 2 mock tuna melt
· 3 grilled veggie chicks
· 3 onion rings
· 3 baked fries
· 2 lemon spritz
· 2 very berry juice
· 2 herbal tea
· 1 soy milk
g. What was the total cost of the food (including tax)? ______
h. What was the amount of change if the customer paid $30.00? ______
21. If the following items were ordered:
· 2 herbal teas
i. What was the total cost of the food (including tax)? ______
j. What was the amount of change if the customer paid $5.00? ______