Give 2 The Troops Worksheet

• •

Scenario: Your group raised $345.00 to purchase items for the troops. Needed items are listed below. You will purchase the items at Walgreens. You will later box and send. Your task: Create a list of the items to purchase as well as their prices. Determine the total dollar amount – do not go over $345.00. Spend wisely. • Visit Walgreens.com and locate items from the list. Start listing the items and their prices. You must pick at least 12 different items. You may purchase up to a quantity of 5 per item – but no more.

You will need to use a formula to problem solve in this worksheet. A sample worksheet is located on page 2. Creating Simple Formulas Excel uses standard operators for equations, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents. The key thing to remember when writing formulas for Excel is that all formulas must begin with an equal sign (=). This is because the cell contains, or is equal to, the formula and its value. To Create a Simple Formula in Excel: Select the cell where the answer will appear Type the equal sign (=). Type in the formula you want Excel to calculate. (Include the cell location in the formula) Press Enter. The formula will be calculated and the value will be displayed in the cell. **Hint, Title of Worksheet – Give 2 The Troops Column A – List the items Column B – List the price Column C – List Quantity (how many of each) Column D - Determine Cost = Price * Quantity Total Cost = Auto Sum the totals from Column D (use AutoSum feature)

Items To Choose From Food, Snacks and Drinks: • Protein Bars (Top Request) • Powder Drink Mix (Kool-Aid) • Beef Jerky • Sunflower Seeds and Pumpkin Seeds

Toiletries:  Lip Balm / Chap Stick / Carmex / Blistex  Body Wash, Liquid Soap, Facial Cleanser  Combs / Brushes  Hand & Body Lotion / Moisturizer  Sunblock, SPF 45, Zinc, Vitamin E, Aloe Vera Gel  Bug Spray  Mouthwash  Breath Mints / Breath Strips  Lozenges / Cough Drops  Tylenol, Motrin, Advil or Aspirin Packets Eye Drops (i.e. Visine)  Nasal Spray

ď&#x201A;§

Vitamins

Turn static files into dynamic content formats.

Create a flipbook

Give 2 The Troops Worksheet

Published on Nov 20, 2013

PDrake

Using Excel 2010 Scenario: Your group raised $345.00 to purchase items for the troops. Needed items are listed below. You will purchase the items at Walgreens. You will later box and send. Your task: Create a list of the items to purchase as well as their prices. Determine the total dollar amount – do not go over $345.00. Spend wisely. • Visit Walgreens.com and locate items from the list. Start listing the items and their prices. • You must pick at least 12 different items. • You may purchase up to a quantity of 5 per item – but no more. You will need to use a formula to problem solve in this worksheet. A sample worksheet is located on page 2. Creating Simple Formulas Excel uses standard operators for equations, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents. The key thing to remember when writing formulas for Excel is that all formulas must begin