Before You Begin: Start Microsoft Excel 2010. You
should see a new, blank spreadsheet.
Try This: Do the following steps
1. Enter the following data
into your spreadsheet.
Item Cost Mark Up Retail Profit Mugs 2.00 150% T-Shirts 5.00 150% Balloons 0.50 150% Hats 3.50 150% Sweatshirts 8.00 150% Tote Bags 10.00 150%
2. Enter the following formula
into cell D2 =B2*C2
3. Copy and paste the formula
into the rest of column D
4. Enter the formula following
formula in cell E2 =D2-B2
5. Copy and paste the formula
into the rest of column E
6. Use the AutoSum tool to
find the sum of the Profit Column
7. Use the AutoSum: Average
command in the Profit Column—remember to adjust the suggested range so
it does NOT include E8
8. Use the AutoSum: Average
command in the Cost column
9. Select the area of the
spreadsheet with Data and apply Cell Style
Neutral
10. Insert a blank row between
T-Shirts and Balloons. Add the following information: Children’s
Shirts, cost $3.00, mark up 150%
11. Copy and paste the retail
and profit formulas in the row for Children’s Shirts
12. Format the data labels in
row A to be Bold and 14 point font
13. Format the column for Mark
Up to be Percentage.
14. Correct the numbers in the
Mark Up column to read 150% (not 15000%)
15. Format the Cost, Retail
and Profit columns to be Accounting
16. Change the mark up on
T-Shirts, Sweatshirts, and Children’s T-Shirts to be 125%
Save your work as Excel
Practice Activity 1 |
||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||
