Before You Begin: Start Microsoft Excel 2013. When the Welcome screen appears, open 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
in Cell D2 =B2*C2
3. Copy and paste the formula
into the rest of Column D
4. Enter the following
formula inCell 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. Select the area of the
spreadsheet with Data and apply Cell Style
Neutral
8. Insert a blank row between
T-Shirts and Balloons. Add the following information: Children’s
Shirts, cost $3.00, mark up 150%
9. Copy and Paste the retail
and profit formulas in the row for Children’s Shirts
11. Format the data labels in
Row A to be Bold and 14 point font
12. Format the Column for Mark
Up to be Percentage.
13. Correct the numbers in the
Mark Up column to read 150% (not 15000%)
14. Format the Cost, Retail
and Profit columns to be Accounting.
15. Change the mark up on
T-Shirts, Sweatshirts, and Children’s T-Shirts to be 125%
Save your work as Excel
Practice Activity 1 |
|||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||
