iii
15
INPUT
DATA
The GAP®
7
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
A
B
C
D
E
F
Activity 7 Student Name
THE GAP
Markup Schedule December 2010
ITEM
UNIT
SELLING
NUMBER ITEM
STYLE
COST
PRICE
Men's wear
715503
Denim Jacket
Well-worn
30
79.5
772336
Classic Khaki
Straight Fit
22
49.5
737510
Boot Fit Jeans
Vintage Wash
32
64.5
768710
Waffle Knit T
Camo
10
24.5
768699
City Cycle Graphic T
11
24.5
750454
Cardigan
Hooded
16
49.99
750202
Rugby Polo
Striped
15
32.99
539875
Cargo Shorts
Camo
8
17.99
783492
Leather Belt
Distressed Buckle 13
39.5
Women's wear 770646
Leather Jacket
Funnel Neck
89
298
768458
Denim Jacket
Elbow Pad
28
69.5
770836
Puffer Vest
30
59.5
768454
Legging Jeans
True Black Wash 32
69.5
770608
Mini Skirt
Plaid
21
44.5
749450
Sweater Hoodie
22
44.99
772219
Shoulder Link Tank
14
29.5
790947
Zipper T
17
34.5
771999
Double Layer T
12
24.5
776518
Leather Tassel Tote
49
98
776546
Skinny Belt
Pyramid Studded 13
29.5
ACTIVITY
Source: http://www.gap.com
93
39
Music Genres
Activity 39 Answer Key
MUSIC GENRES
4/21/2011
PAGE 1
Music Genres
Artist
Album
Genre
Weezer
Death to False Metal
Pop/Rock
Brian Eno
Small Craft on a Milk Sea Electronic
N.E.R.D.
Nothing
Pop/Rock
Huey Lewis
Soulsville
Pop/Rock
Neil Diamond
Dreams
Pop/Rock
Good Charlotte
Cardiology
Pop/Rock
Taylor Swift
Speak Now
Pop/Rock
Bryan Ferry
Olympia
Pop/Rock
Brad Paisley
Hits Alive
Country
Sunshine Anderson The Sun Shines Again
R&B
Charlotte Church
Back to Scratch
Pop/Rock
Matt & Kim
Sidewalks
Pop/Rock
Kings of Leon
Come Around Sundown
Pop/Rock
Shakira
Sale el Sol
Latin
Buddy Guy
Living Proof
Soul
Instructions: Type the data exactly as shown below using a program that allows you to save the
file as a "text only" file (.TXT file extension). Save the file as MUSIC GENRES.txt.
TABLE
39 1
Music Genres
Artist, Album, Genre
Weezer, Death to False Metal, Pop/Rock
Brian Eno, Small Craft on a Milk Sea, Electronic
N.E.R.D., Nothing, Pop/Rock
Huey Lewis, Soulsville, Pop/Rock
Neil Diamond, Dreams, Pop/Rock
Good Charlotte, Cardiology, Pop/Rock
Taylor Swift, Speak Now, Pop/Rock
Bryan Ferry, Olympia, Pop/Rock
Brad Paisley, Hits Alive, Country
Sunshine Anderson, The Sun Shines Again, R&B
Charlotte Church, Back to Scratch, Pop/Rock
Matt & Kim, Sidewalks, Pop/Rock
Kings of Leon, Come Around Sundown, Pop/Rock
Shakira, Sale el Sol, Latin
Buddy Guy, Living Proof, Soul
TABLE
39 2
SKIP ONE LINE HERE USING THE< ENTER> KEY
SEPARATE EACH LINE
USING THE <ENTER>
KEY
ACTIVITY
S
our
c
e: h
ttp://w
w
w
.allmusic
.c
om
14
1. Format cells as
numbers.
2. Increase a cell's
decimal places.
T
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®
7
NEW SKILL
NEW SKILL
ACTIVITY
Acti vity Layout
New Skills
lists the new skill or skills
being reinforced.
Input Data Spreadsheets
Provides the reader with a hard copy
of the spreadsheet that coincides with
each activity.
Input Frames
Provides the data to be typed
and formatted into the fi nished
spreadsheet.
New Skill Indicator
identifi es an instruction that
includes a new skill reinforced
in an activity.
Activity Overview
Provides a description of each activity,
highlighting the spreadsheet(s) to be
produced.
Instructions
Provides the step-by-step instructions
for completing each activity.
Format Sample
illustrates the spreadsheet and data
with proper formatting.
For Evaluation Purposes Only