New York University The TicketSales Spreadsheet Excel Task

If you are using a version of Excel other than2013, this screen may appear different
If you are using a version of Excel other than
2013, this screen may appear different
If you are using a version of Excel other than
2013, this screen may appear different
If you are using a version of Excel other than
2013, this screen may appear different
If you are using a version of Excel other than
2013, this screen may appear different
inventory
INUSE
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
307
STORED ITEM
MAKE
MONITOR IBM
MONITOR IBM
MONITOR IBM
MONITOR IBM
MONITOR IBM
MONITOR IBM
MONITOR IBM
MONITOR IBM
MONITOR IBM
MONITOR IBM
MONITOR IBM
MONITOR IBM
MONITOR IBM
MONITOR IBM
MONITOR IBM
MONITOR IBM
MONITOR IBM
COMPUTER
IBM
COMPUTER
IBM
COMPUTER
IBM
COMPUTER
IBM
COMPUTER
IBM
COMPUTER
IBM
COMPUTER
IBM
COMPUTER
IBM
COMPUTER
IBM
COMPUTER
IBM
COMPUTER
IBM
COMPUTER
IBM
COMPUTER
IBM
COMPUTER
IBM
COMPUTER
IBM
COMPUTER
IBM
COMPUTER
IBM
KEYBOARDIBM
KEYBOARDIBM
KEYBOARDIBM
KEYBOARDIBM
KEYBOARDIBM
KEYBOARDIBM
KEYBOARDIBM
KEYBOARDIBM
KEYBOARDIBM
KEYBOARDIBM
KEYBOARDIBM
KEYBOARDIBM
KEYBOARDIBM
KEYBOARDIBM
KEYBOARDIBM
KEYBOARDIBM
KEYBOARDIBM
MODEL
8512-001
8512-001
8512-001
8512-001
8512-001
8512-001
8512-001
8512-001
8512-001
8512-001
8512-001
8512-001
8512-001
8512-001
8512-001
8512-001
8512-001
80-286
30-286
30-286
30-286
30-286
30-286
30-286
30-286
30-286
30-286
30-286
30-286
30-286
30-286
30-286
30-286
30-286
SERIAL
IA
72-0856581I
72-0875744I
72-0875772I
72-0875677I
72-0875532I
72-0878333I
72-0878337I
72-0878334I
72-0865684I
72-0633749I
72-0880871I
72-0875754I
72-0875305I
72-0878331I
72-0865680I
72-0865524I
72-0875288I
72-6053457I
23-9061785I
23-9068221I
23-9068685I
23-9068928I
23-9068226I
23-9068653I
23-9061782I
23-9061654I
23-9061116I
23-9061929I
23-9061136I
23-9061839I
23-9068831I
23-9061662I
23-9061526I
23-9068681I
5166175 I
6199169 I
6198852 I
6199168 I
6191988 I
6199170 I
5524166 I
6199186 I
6199191 I
6199183 I
6198851 I
6199171 I
5524146 I
5524028 I
5524029 I
6199178 I
5524014 I
Page 1
CONDITION
ORDERDATE
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
NEW
5/31/1991
inventory
204
600
202
101
BSMT
202
202
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
B01
101
101
101
101
302
PRINTER IBM
4201-002 113573137 I
PRINTER IBM
4019-001 110036964 I
COMPUTER
T ANDON TM7004 AAD0A400058
A
PRINTER PANOSONIC
1624-001 OFMATJF8047
A
SCANNER NCS
3000
C11928
A
MONITOR PACKARD-BE
1422-EG MC-81003804
A
KEYBOARDBTC
5339
594280295 A
KEYBOARDBTC
5339
71202008 A
MONITOR PACKARD-BE
PB-1272-A 60311966 A
COMPUTER
T ANDON TM6001A 341812
A
TYPEWRITER
SWINTEC 640-SC
1Y300698UI
TYPEWRITER
SWINTEC 640-SC
1Y300937UI
TYPEWRITER
SWINTEC 640-SC
1Y300065UI
TYPEWRITER
SWINTEC 640-SC
1Y300948UI
TYPEWRITER
SWINTEC 640-SC
1Y300946UI
TYPEWRITER
SWINTEC 640-SC
1Y300695UI
TYPEWRITER
SWINTEC 640-SC
1Y300699UI
TYPEWRITER
SWINTEC 640-SC
1Y300672UI
TYPEWRITER
SWINTEC 640-SC
1Y300700UI
TYPEWRITER
SWINTEC 640-SC
19301430UI
TYPEWRITER
SWINTEC 640-SC
1Y300693UI
TYPEWRITER
SWINTEC 640-SC
1Y300915UI
TYPEWRITER
SWINTEC 640-SC
1Y300687UI
TYPEWRITER
SWINTEC 640-SC
19301438UI
TYPEWRITER
SWINTEC 640-SC
1Y300941UI
TYPEWRITER
SWINTEC 640-SC
1Y300711UI
TYPEWRITER
SWINTEC 640-SC
1Y300657UI
TYPEWRITER
SWINTEC 640-SC
1Y300694UI
TYPEWRITER
SWINTEC 640-SC
1Y300680UI
TYPEWRITER
SWINTEC 640-SC
19301203UI
TYPEWRITER
SWINTEC 640-SC
1Y300652UI
TYPEWRITER
SWINTEC 640-SC
19301435UI
TYPEWRITER
SWINTEC 640-SC
19301215UI
TYPEWRITER
SWINTEC 640-SC
1Y300686UI
TYPEWRITER
SWINTEC 640-SC
19301204UI
TYPEWRITER
SWINTEC 640-SC
1Y300949UI
TYPEWRITER
SWINTEC 640-SC
1Y300688UI
TYPEWRITER
SWINTEC 640-SC
1Y300678UI
TYPEWRITER
SWINTEC 640-SC
1Y300678UI
TYPEWRITER
SWINTEC 640-SC
193012101U
I
TYPEWRITER
SWINTEC 640-SC
1Y300660UI
TYPEWRITER
SWINTEC 640-SC
19301206UI
TYPEWRITER
SWINTEC 640-SC
1Y300696UI
TYPEWRITER
SWINTEC 640-SC
1Y300927UI
TYPEWRITER
SWINTEC 640-SC
1Y300926UI
TYPEWRITER
SWINTEC 640-SC
19301205UI
MONITOR IBM
8513
23-YXK51 A
COMPUTER
IBM
8560-071 72-9149695A
KEYBOARDIBM
1391401 5686078 A
MOUSE IBM
6450350 23-24099 A
PRINTER IBM
4019-001 11-G5577 A
MONITOR IBM
8512-001 72-1197623A
Page 2
NEW
USED
5/31/1991
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
1/22/1993
inventory
BSMT
302
302
302
BSMT
101
101
101
600
600
204
204
301
301
101
101
101
101
BSMT
600
VJZ
VJZ
204
202
204
B01
204
204
204
204
204
204
600
204
204
COMPUTER
IBM
8555-061 23-1265548A
KEYBOARDIBM
1390120 2242879 A
DISK DRIVE
IBM
4869-002 86-B-088741
A
PRINTER PANOSONIC
1595-006 8JMAJJ9521
A
KEYBOARDBTC
5339R
49904037 A
MONITOR PACKARD PB1452CGH
90505541 A
COMPUTER
T ANDON TM7004 AAD01A400697
A
PRINTER IBM
4216-031 A1-6111-A A
COMPUTER
IBM
5710
7624282 A
KEYBOARDIBM
1390131 1260591 A
MONITOR IBM
5154001 0296U55 A
PRINTER PRINTRONIX
P3000
NLD1235C A
MODEM PARADYNE2496-01 836-4200-0011
A
COMPUTER
T ANDON TM7004 AADO1A400527
A
PRINTER PANOSONIC
1180-002 9BKARJ64455
A
MONITOR PACKARD-BE
PB1452CGH
90505327 A
KEYBOARDBTC
5339
595110280 A
MONITOR IBM
8513
23-YY837 A
COMPUTER
IBM
8560-071 72-9149656A
MOUSE IBM
6450350 23-244088 A
PRINTER IBM
4019-001 11-G0826 I
COMPUTER
IBM
8525-004 23-0422105A
KEYBOARDIBM
1391401 23-45820 A
KEYBOARDIBM
1391472 2206331 A
COMPUTER
IBM
8555-061 23-1265636A
MONITOR IBM
8512-001 72-1202973A
CONTROLLER
MEMOREX1174-60R 1044013632A
MODEM AT&T
3610
3047837 A
DISK DRIVE
IBM
5489-002 86-B-102153
A
COMPUTER
IBM
8555-001 23-CTVA4 A
MONITOR IBM
8515-001 23-LG622 A
KEYBOARDIBM
1391401 5960655 A
PRINTER IBM
4019-001 11-F8172 A
PRINTER IBM
4202-003 11-3058927A
PRINTER IBM
4207-002 112062856 A
KEYBOARDBTC
5339
594280293 A
COMPUTER
IBM
8525-004 25-0421953A
COMPUTER
IBM
8525-004 23-0422093A
KEYBOARDIBM
2231239 1391473 A
COMPUTER
T ANDON TM-6001-A341899
A
PRINTER PANOSONIC
1180-001 8LKARE34007
A
MONITOR PACKARD-BE
PB1272-A 80700340 A
KEYBOARDBTC
5339
71202556 A
COMPUTER
T ANDY
OMNI 425SX
TC323076287
I
COMPUTER
T ANDY
OMNI 425SX
TC324075717
I
COMPUTER
T ANDY
OMNI 425SX
TC324076340
I
COMPUTER
T ANDY
OMNI 425SX
TC324076298
I
COMPUTER
T ANDY
OMNI 425SX
TC323076297
I
COMPUTER
T ANDY
OMNI 425SX
TC324076295
I
COMPUTER
T ANDY
OMNI 425SX
TC323076284
I
COMPUTER
T ANDY
OMNI 425SX
TC324075544
I
COMPUTER
T ANDY
OMNI 425SX
TC324075736
I
Page 3
GOOD
POOR
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
inventory
600
600
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
204
600
204
204
204
204
204
204
204
204
204
204
204
204
204
204
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
COMPUTER
T ANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
MONITOR TANDY
OMNI 425SX
TC324076302
I
OMNI 425SX
TC324075560
I
OMNI 425SX
TC324075554
I
OMNI 425SX
TC323076286
I
OMNI 425SX
TC324075737
I
OMNI 425SX
TC324076290
I
OMNI 425SX
TC324076261
I
OMNI 425SX
TC323076304
I
OMNI 425SX
TC324076275
I
OMNI 425SX
TC323076292
I
OMNI 425SX
TC323076269
I
OMNI 425SX
TC323076300
I
OMNI 425SX
TC323076289
I
OMNI 425SX
TC323076291
I
OMNI 425SX
TC323076301
I
OMNI 425SX
TC324076268
I
OMNI 425SX
TC320076303
I
OMNI 425SX
TC324076294
I
OMNI 425SX
TC323076288
I
OMNI 425SX
TC323076252
I
OMNI 425SX
TC323076256
I
OMNI 425SX
TC323076296
I
OMNI 425SX
TC324075537
I
OMNI 425SX
TC323076254
I
OMNI 425SX
TC323076299
I
VGM 340 H1GBC00204
I
VGM 340 H1GBC00186
I
VGM 340 H1GBC00223
I
VGM 340 H1GBC00213
I
VGM 340 H1GBC00267
I
VGM 340 H1GBC00217
I
VGM 340 H1GBC00249
I
VGM 340 H1GBC00260
I
VGM 340 H1GBC00229
I
VGM 340 H1GBC00246
I
VGM 340 H1GBC00194
I
VGM 340 H1GBC00272
I
VGM 340 H1GBC00286
I
VGM 340 H1GBC00274
I
VGM 340 H1GBC00184
I
VGM 340 H1GBC00270
I
VGM 340 H1GBC00218
I
VGM 340 H1GBC00275
I
VGM 340 H1GBC00256
I
VGM 340 H1GBC00221
I
VGM 340 H1GBC00273
I
VGM 340 H1GBC00232
I
VGM 340 H1GBC00180
I
VGM 340 H1GBC00418
I
VGM 340 H1GBC00269
I
VGM 340 H1GBC00193
I
VGM 340 H1GBC00258
I
Page 4
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
inventory
204
204
204
204
204
307
204
204
204
204
204
204
204
101
204
204
B01
204
600
204
100
101
101
101
101
204
100
100
100
300
300
300
300
300
100
204
600
204
MONITOR TANDY
VGM 340 H1GBC00266
I
MONITOR TANDY
VGM 340 H1GBC00024
I
MONITOR TANDY
VGM 340 H1GBC00234
I
MONITOR TANDY
VGM 340 H1GBC00235
I
MONITOR TANDY
VGM 340 H1GBC00182
I
MONITOR TANDY
VGM 340 H1GBC00253
I
PRINTER TANDY
DMP 2104 3103
I
PRINTER TANDY
LP800
1072
I
COMPUTER
T ANDY
4866 LX/T 811831
I
MONITOR TANDY
VGM-100 H8ZB201059
I
UPS
APC
900
B93040315951
I
COMPUTER
T ANDY
4833 LX/T 811839
I
MONITOR TANDY
VGM 450 H3NBB03661
I
SCANNER AVR
8000 CLX 113087
I
PRINTER IBM
4019-001 11-M5665 A
PRINTER HEWLETT-PACKARD
33459A
3221J41396A
OH PROJECTOR
EIKI
OHP4100A12913
I
LCD PROJECTION
PROXIMA A822C
2930
I
SCANNER NCS
3000
C10587
A
MONITOR SAMTRONSC-428TX 9401108105I
MONITOR TANDY
25-4047 H1GBC00179
I
KEYBOARDIBM
IBM PC
NONE
A
MONITOR PACKARD-BE
PB1431EG 81030718 A
COMPUTER
T ANDON TM-7004 AAD01A400616
A
PRINTER HEWLETT-PACKARD
HP33481A 320BJL4B3X
A
MOUSE NEC
MS-28
LC0541002812
A
KEYBOARDNEC
RT101
80240294 A
COMPUTER
NEC
PM12902461
3434A01640
A
MONITOR NEC
JC1536VMA
4Y00966EEA
MODEM SUPRA FAX
34E
288
210337
I
COMPUTER
T ANDON TM-7004 LR54776 A
MONITOR PACKARD-BELL
PB1431EG 81030718 A
KEYBOARDIBM
263102569 NONE
COMPUTER
NEC
PM12902461
450210UB A
MONITOR NEC
JC1535VMA
4500328MMA
KEYBOARDNEC
RT101
91532114 A
MOUSE NEC
M5286MD LC1741001815
A
PRINTER HEWLETT-PACKARD
C3941A
VSCB087407
A
MONITOR PACKARD-BELL
PB1452CGH
A3L9QTWNA
COMPUTER
NEC
9616
6520377UNA
PRINTER HEWLETT-PACKARD
5P
USHB001089
A
MONITOR NEC
XV15
6302917EFA
MONITOR SAMSUNGCQA4147 H7EG601604
I
MONITOR SAMSUNGCQA4147 H7EG601605
I
Page 5
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
NEW
USED
NEW
NEW
USED
USED
USED
NEW
NEW
NEW
NEW
NEW
NEW
USED
USED
USED
NEW
NEW
NEW
NEW
NEW
USED
NEW
NEW
NEW
NEW
NEW
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
3/8/1993
2/16/1994
5/12/1994
6/9/1974
6/24/1994
6/24/1994
########
########
inventory
ORDERNUM
FUNDING DEPARTMENT
DESPOSEDSTATION
MAC/PCEN
1
MAC/PCEN
2
MAC/PCEN
3
MAC/PCEN
4
MAC/PCEN
5
MAC/PCEN
6
MAC/PCEN
7
MAC/PCEN
8
MAC/PCEN
9
MAC/PCEN
10
MAC/PCEN
11
MAC/PCEN
12
MAC/PCEN
13
MAC/PCEN
14
MAC/PCEN
15
MAC/PCEN
16
MAC/PCEN
17
MAC/PCEN
1
MAC/PCEN
2
MAC/PCEN
3
MAC/PCEN
4
MAC/PCEN
5
MAC/PCEN
6
MAC/PCEN
7
MAC/PCEN
8
MAC/PCEN
9
MAC/PCEN
10
MAC/PCEN
11
MAC/PCEN
12
MAC/PCEN
13
MAC/PCEN
14
MAC/PCEN
15
MAC/PCEN
16
MAC/PCEN
17
MAC/PCEN
1
MAC/PCEN
2
MAC/PCEN
3
MAC/PCEN
4
MAC/PCEN
5
MAC/PCEN
6
MAC/PCEN
7
MAC/PCEN
8
MAC/PCEN
9
MAC/PCEN
10
MAC/PCEN
11
MAC/PCEN
12
MAC/PCEN
13
MAC/PCEN
14
MAC/PCEN
15
MAC/PCEN
16
MAC/PCEN
17
USER
REPAIR
FILESERVER3
FALSE
NORTH
FALSE
ARIES
FALSE
TAURUS
FALSE
EAST
FALSE
GEMINI
FALSE
CANCER
FALSE
LEO
FALSE
VIRGO
FALSE
LIBRA
FALSE
SCORPIO FALSE
SAGITARIUSFALSE
CAPRICORNFALSE
SOUTH
FALSE
AQUARIUS FALSE
PISCES
FALSE
WEST
FALSE
FILESERVER3
FALSE
NORTH
FALSE
ARIES
FALSE
TAURUS
FALSE
EAST
FALSE
GEMINI
FALSE
CANCER
FALSE
LEO
FALSE
VIRGO
FALSE
SCORPIO FALSE
LIBRA
FALSE
SAGITARIUSFALSE
CAPRICORNFALSE
SOUTH
FALSE
AQUARIUS FALSE
PISCES
FALSE
WEST
FALSE
FILESERVER3
FALSE
NORTH
FALSE
ARIES
FALSE
TAURUS
FALSE
EAST
FALSE
GEMINI
FALSE
CANCER
FALSE
LEO
FALSE
VIRGO
FALSE
LIBRA
FALSE
SCORPIO FALSE
SAGITARIUSFALSE
CAPRICORNFALSE
SOUTH
FALSE
AQUARIUS FALSE
PISCES
FALSE
WEST
FALSE
Page 6
PROBLEM INCIDENT
inventory
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
517552
MAC/PCEN
MAC/PCEN
TAX-LEVY
TAX-LEVY
MDB HS
TAKEN BY NCS
TAX-LEVY
TAX-LEVY
MDB HS
MDB HS
MDB HS
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
TAX-LEVY
TAX-LEVY
TAX-LEVY
TAX-LEVY
TAX-LEVY
VTAM
LPT1
FALSE
CO-OP
FALSE
KEN
FALSE
JEFF
FALSE
ATTENDANCE
FALSE
KEN
FALSE
KEN
FALSE
FALSE
CUSTODIANFALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
JEFF
FALSE
JEFF
FALSE
JEFF
FALSE
JEFF
FALSE
JAMILLAH FALSE
VTAM
FALSE
Page 7
inventory
VTAM
VTAM
VTAM
TAX-LEVY
TAX-LEVY
TAX-LEVY
TAX-LEVY
TAX-LEVY
MDB HS
MDB HS
MDB HS
MDB HS
MDB HS
TAX-LEVY
TAX-LEVY
TAX-LEVY
TAX-LEVY
TAX-LEVY
TAX-LEVY
TAX-LEVY
TAX-LEVY
IBM
TAX-LEVY
VTAM
VTAM
VTAM
VTAM
VTAM
VTAM
TAX-LEVY
TAX-LEVY
TAX-LEVY
TAX-LEVY
VTAM
TAX-LEVY
TAX-LEVY
IBM
IBM
IBM
MDB HS
TAX-LEVY
MDB HS
MDB HS
VTEA
BUSINESS
VTEA
BUSINESS
VTEA
BUSINESS
VTEA
BUSINESS
VTEA
BUSINESS
VTEA
BUSINESS
VTEA
BUSINESS
VTEA
BUSINESS
VTEA
BUSINESS
VTAM
VTAM
VTAM
ED
ED
ED
ED
ED
ED
ED
ED
ED
1
2
3
4
5
6
28
8
9
FALSE
FALSE
FALSE
FALSE
JAMILLAH FALSE
JAMILLAH FALSE
JAMILLAH FALSE
FALSE
RJE
FALSE
RJE
FALSE
RJE
FALSE
RJE
FALSE
RJE
FALSE
EMILY
FALSE
CUSTODIANFALSE
EMILY
FALSE
EMILY
FALSE
CO-OP
FALSE
CO-OP
FALSE
TONY
FALSE
TONY
FALSE
MICHAEL T FALSE
MICHAEL T FALSE
GATEWAY FALSE
GATEWAY FALSE
GATEWAY FALSE
GATEWAY FALSE
GATEWAY FALSE
GATEWAY FALSE
JEFF
FALSE
JEFF
FALSE
JEFF
FALSE
JEFF
FALSE
FALSE
TONY
FALSE
CAROLYN FALSE
FALSE
FALSE
TONY
FALSE
CAROLYN FALSE
KEN
FALSE
FALSE
FALSE
1
FALSE
2
FALSE
3
FALSE
4
TRUE
5
TRUE
6
FALSE
28
FALSE
8
FALSE
9
FALSE
Page 8
NONFUNCTIONING
226087 DISKETTE DRIVE
NONFUNCTIONING
226087 DISKETTE DRIVE
inventory
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
VTEA
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS TAKEN
ED
BY OTS
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS 165950
ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS ED
BUSINESS REPLACED
ED
10
27
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
1
2
3
4
5
6
7
8
9
11
12
13
27
15
16
17
19
20
21
22
23
24
25
26
27
28
CO-OP
FALSE
27
FALSE
12
FALSE
13
TRUE
14
FALSE
15
FALSE
16
FALSE
17
FALSE
18
FALSE
19
FALSE
20
FALSE
21
FALSE
22
FALSE
23
FALSE
24
TRUE
25
FALSE
26
FALSE
TEACHER STA
FALSE
TEACHER STA
FALSE
29
FALSE
30
FALSE
31
FALSE
32
FALSE
33
FALSE
34
FALSE
1
FALSE
2
FALSE
3
FALSE
4
FALSE
5
FALSE
6
FALSE
7
FALSE
8
FALSE
9
FALSE
11
FALSE
12
FALSE
13
FALSE
27
FALSE
15
FALSE
16
FALSE
17
FALSE
FALSE
19
FALSE
20
FALSE
21
FALSE
22
FALSE
23
FALSE
24
FALSE
25
FALSE
26
FALSE
27
FALSE
28
FALSE
Page 9
DISK DRIVE
226087
MALFUNCTION
DISK DRIVE
226087
MALFUNCTION
inventory
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS TAKEN
ED
BY OTS
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
VTEA
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTEA
BUSINESS ED
VTAM
TAX-LEVY
A22512
VTEA
BUSINESS NEW
ED ITEM
5940
VTEA
BUSINESS NEW
ED ITEM
NCS REPAIR
NCS
TESTING
REPLACEMT
TANDY
BUSINESS
TANDY
VTEA
BUSINESS
TAX-LEVY
TAX-LEVY
TAX-LEVY
TAX-LEVY
TAX-LEVY
TAX-LEVY
TAX-LEVY
TAX-LEVY
TAX-LEVY BUSINESS ED
TAX-LEVY ATTENDANCE
TAX-LEVY ATTENDANCE
TAX-LEVY ATTENDANCE
TAX-LEVY GUIDANCE
TAX-LEVY GUIDANCE
TAX-LEVY GUIDANCE
TAX-LEVY GUIDANCE
TAX-LEVY GUIDANCE
ATTENDANCE
TAX-LEVY BUSINESS ED
VTEA
BUSINESS ED
TAX-LEVY BUSINESS ED
OTS
BUSINESS ED
2040
OTS
BUSINESS ED
18
30
31
32
33
34
1
21
28
34
29
18
FALSE
30
FALSE
31
FALSE
32
FALSE
33
FALSE
34
FALSE
LPT1
FALSE
LPT2
FALSE
FILESERVER2
FALSE
FILESERVER2
FALSE
FILESERVER2
FALSE
TEACHER FALSE
TEACHER FALSE
TEACHER FALSE
VTAM
FALSE
DONIA
FALSE
TEACHER FALSE
TEACHER FALSE
FALSE
21
FALSE
28
FALSE
CUSTODIANFALSE
FALSE
CUSTODIANFALSE
PATRICE
FALSE
DONIA
FALSE
DONIA
FALSE
DONIA
FALSE
DONIA
FALSE
TEACHER FALSE
EMILY
FALSE
EMILY
FALSE
EMILY
FALSE
VIRGINIA
FALSE
VIRGINIA
FALSE
VIRGINIA
FALSE
VIRGINIA
FALSE
VIRGINIA
FALSE
EMILY
FALSE
TONY
FALSE
LPT2
FALSE
TONY
FALSE
CO-OP
FALSE
29
FALSE
Page 10
Date Sold
2/15/2011
3/3/2011
1/28/2011
1/15/2011
3/6/2011
2/1/2011
4/5/2011
2/11/2011
2/9/2011
1/19/2011
1/30/2011
2/27/2011
3/13/2011
4/13/2011
4/1/2011
3/28/2011
3/16/2011
4/22/2011
4/5/2011
4/9/2011
3/6/2011
2/2/2011
1/23/2011
3/3/2011
1/2/2011
1/19/2011
4/2/2011
4/12/2011
4/1/2011
3/16/2011
3/11/2011
2/11/2011
2/19/2011
2/19/2011
4/15/2011
SalespersonDestinationTickets Sold
Lisa
France (Paris and Nice)
3
Bob
Hungary and Poland 2
Lisa
Thailand or Indonesia4
Bob
Japan
2
Vivien
India
3
John
Middle East (UAE, Qatar
1 and Oman)
Andrew
Egypt and South Africa
1
Bob
India
2
John
Egypt and South Africa
2
John
Thailand or Indonesia3
Heather
Hungary and Poland 3
Vivien
Middle East (UAE, Qatar
4 and Oman)
John
Japan
3
Lisa
Japan
2
John
France (Paris and Nice)
1
Lisa
Egypt and South Africa
2
John
India
4
Vivien
Thailand or Indonesia6
John
Hungary and Poland 2
Vivien
France (Paris and Nice)
1
Vivien
Egypt and South Africa
2
Lisa
India
3
Vivien
Hungary and Poland 1
Andrew
Middle East (UAE, Qatar
3 and Oman)
Andrew
Japan
2
Andrew
France (Paris and Nice)
2
Bob
France (Paris and Nice)
1
Lisa
Hungary and Poland 3
Lisa
Middle East (UAE, Qatar
3 and Oman)
Vivien
Japan
3
Bob
Egypt and South Africa
2
Andrew
India
1
Bob
Middle East (UAE, Qatar
2 and Oman)
Heather
Egypt and South Africa
1
Heather
Thailand or Indonesia1
Total Tickets Sold
Most Tickets Sold
Least Tickets Sold
Average Number of Tickets Sold
On the TicketSales spreadsheet, I looked at [what were you looking at?]. In looking at the data,
I see that a total number of [sum] tickets were sold and an average number of [average] were
sold. I can see that the most number of tickets were sold by [salesperson] and to the destination
of [Destination]. I can see that the most number of tickets to one single destination were sold by
[Salespersons] to [Destinations]. I can also see that the least number of tickets were sold by
[Salesperson].
Based on my observations, I would advise [who would you advise?] to [what decision would you
advise them to make or action to take?] This is because [give the exact data that is shown in the
spreadsheet to support your recommendation].
In completing this lab, I learned that a table enables me to quickly group data according to
similar characteristics. I create table by [your answer]. A pivot table and pivot chart enables me
to [your answer]. I create a pivot table by [your answer]. I create a pivot chart by [your answer].
On the inventory spreadsheet, I looked at [what were you looking at?]. In looking at the data, I
see [your answer]. Based on my observations, I would advise [who would you advise?] to [what
decision would you advise them to make or action to take?] This is because [give the exact data
that is shown in the spreadsheet to support your recommendation].
Excel Lab 3
Excel Tables, Pivot Tables & Pivot Charts
Development Exercise
DIRECTIONS:
1. Download the TicketSales file and save it on your device with your first and last name.
2. Upload it to Office 360 and open it with Microsoft Excel
3. Create a table for the data
4. Sort the table data by the date, oldest to newest
5. Create a pivot table on a new spreadsheet. The report filter field should be the Date. The
row fields should be the Destination. The Column field should be the Salesperson. The
Value should be Tickets Sold. It should always be a number.
6. Apply one of the fancy styles to the pivot table. Re-name the sheet tab to Ticket Sales
Pivot Table
7. Create a Column Type Pivot Chart based on the pivot table. Move it to another sheet.
Re-name that chart Ticket Sales Chart
8. At the bottom of the spreadsheet right next to the labels, find the Total, Maximum,
Minimum, and Average number of tickets sold
9. Print the entire workbook file as a PDF. and download it to your device for submission to
the instructor on Blackboard. Use the file name, Ticket Sales followed by your first and
last name.
10. Download the write-up file for this Lab from Blackboard and save it on your device.
11. Upload the writeup file to Office 360 and open it with Microsoft Word
12. Use the different sheets and filter features to help you complete it.
Copyright © 1985-2020 by Anthony V. Romano. All rights reserved. Page 1 of 2
Excel Lab 3
Excel Tables, Pivot Tables & Pivot Charts
Practice Exercise
DIRECTIONS:
13. Download the inventory file and save it on your device with your first and last name.
14. Upload it to Office 360 and open it with Microsoft Excel
15. Create a table for the data
16. Create a pivot table on a new spreadsheet. The report filter field should be IA. The Row
Labels should contain the Items and the Column Labels should contain InUse. The values
should contain the Serial Numbers.
17. Apply one of the fancy styles to the pivot table. Re-name the sheet tab to Hardware
Pivot.
18. Create a Column Type Pivot Chart based on the pivot table. Move it to another sheet.
Pick a chart style that enables you to clearly view all the elements and that enable to type
in a chart title. The chart title should be Inventory Locations. Re-name that sheet tab
Hardware Pivot Chart.
19. Print the entire workbook file as a PDF. and download it to your device for submission to
the instructor on Blackboard. Use the file name, Ticket Sales followed by your first and
last name.
20. Use the different sheets and filter features to help you complete it.
21. Print a PDF copy of the writeup file. Save the file on your device as Excel Lab 3
Write-Up, followed by your first and last name. Submit the PDF write-up to your
instructor on Blackboard.
Copyright © 1985-2020 by Anthony V. Romano. All rights reserved. Page 2 of 2