055 - Receipts

Page 55—Application: Receipts Formatting your receipt (so that it looks like one) Column = 10

Column = 14

Column = 40

Insert > Picture Text Box: Where’s the textbox icon? Click on Tools > Customize. Select the Toolbars Tab and make sure Drawing is checked!

Number Formatting:

All fonts in this itemized list are Arial 15PT

If you want these boxes to display Money, you have to format them to do so.

Dark Boxes around the totals Make the Grand Total LARGE

Highlight the cells you want to have dollar signs and click on Format >Cells and choose Number and select ACCOUNTING

Entering the FORMULAS:

1. Total Column What Formula would you insert into these cells that would Multiply the Unit Cost by the Quantity or Weight?

2. SubTotal 3. Taxes

The Total of the Total Column

Subtotal x Tax%

4. Grand Total Subtotal + Tax + Grand Total

Tip: (Shortcut) Use the FILL DOWN method

Receipt Assignment Sheet #1: I DO, YOU DO In Mr. Aguda’s dreams, he wins the lottery. Because he is now rich, he wants to treat all his friends to Cheesecake Factory. He tells all his friends to order anything they want on the menu. Here’s what they order.

Andrew: B.B. Chicken and Shrimp ($16.97) ICED TEA ($2.49)

Ferlay: Southwest Chicken Salad ($15.99) Iced Tea ($2.49)

Chloe: B.B. Chicken and Shrimp ($16.97) Iced Tea ($2.49)

Jack: Chicken Marsala ($15.99) Iced Tea ($2.49)

Dan: Tons of Fun Burger ($9.99) ROOT BEER ($2.49)

Mari: Ceasar Salad w/ Chicken ($12.99) Diet Coke ($2.49)

Me: Filet Mingon ($22.99) Iced Tea ($2.49) Cheesecake ($5.95)

Jewel: Filet Mingon ($22.99) Diet Coke ($2.49) Cheesecake ($5.95)

In your receipt, include: 1. Quantity 2. Description 3. Unit Price 4. Sub Total 5. Tax (8.50%) 6. Grand Total

YOU ARE HAVING A BIRTHDAY PARTY!!! Sheet #2: BDAY FOOD You have $450 to spend for Food. You are expecting 45 people to attend. Decide what kinds of foods you will be serving and look through the Grocery Circular to find the items you wish to buy. SPEND AS CLOSE TO $450 as POSSIBLE without going OVER! On your receipt, same as above, include the QTY, Description, Unit Price, Unit totals, Sub Total, Tax, Grand Total. Sales tax will be 8.50%

Per Pound? In the QTY Column, put how many pounds of meat you want to have. 1/2 to 1 pound per person if you’re going to have a BBQ.

2 for 1 Specials Whenever you see these, you need to figure out the unit price for 1. If you just bought of these (NOT 2) how much would it cost? In the UNIT COST box figure COST divided by the #

=(5/2)