Excel It! 2nd Edition Page 24

1. Format cells as

numbers.

2. Increase a cell's

decimal places.

he Gap® is a worldwide retail clothing store that off ers premium clothing
and accessories. They provide consumers with a wide assortment of fresh,

casual, and American style clothing. The Gap® has everything people need to
express a personal style. From jeans and T's, to khakis and oxfords, the Gap®
has fashion at great prices for adults, teens, kids, and babies.
The following acti vity illustrates how spreadsheets can be used by a retail
clothing store to list the cost of merchandise (unit cost) and its selling price.

1. Create a NEW spreadsheet.

Unless otherwise stated, the font should be 10 point Arial.
2. Type the data as shown.
3. Bold cell A2 and change the font size to 14 point.
4. Bold cells A3, A9, and A20.

5. Bold rows 6 and 7.
6. Format the width of column A to 14.0 and left align.

7. Format the width of column B to 14.0 and center align.

8. Format the width of columns C and D to 20.0 and left align.
9. Format the width of columns E and F to 9.0 and center align.

10. Select column B and format it as numbers displaying 0 decimal places.

11. Select columns E and F and format them as numbers displaying 2 decimal

places.

12. Carefully proofread your work for accuracy.
13. Save the spreadsheet as THE GAP.
14. Analyze the changes made to the data in the spreadsheet.
15. Set the Print Area to include all cells containing data in the spreadsheet.
16. Print Preview and adjust the Page Setup so that the spreadsheet fi ts on one

page.

17. Print a copy of the spreadsheet if required by your instructor.

The GAP®

NEW SKILL

ACTIVITY

For Evaluation Purposes Only