ABC Company

Income Statement (Consolidated)

(in mUSD, except per share amounts) Dec-16 Dec-17 Dec-18

Net sales 149,184 145,588 147,049
Cost of sales 129,801 127,184 132,771
Gross profit 19,383 18,404 14,278

Selling, general and administrative expenses 8,783 8,254 7,985

Other (income) expense, net 25 50 75
EBIT 10,575 10,100 6,218
Non-service related postretirement costs 221 201 197
Interest expense, net 381 309 320

EBT 9,973 9,590 5,701

Provision for income taxes 2,739 2,765 1,867
Net income including noncontrolling interests 7,234 6,825 3,834
Less: Net income attributable to noncontrolling interests 159 18 9
Net income attributable to ABC Company 7,075 6,807 3,825
Earnings per common share, basic 4.59 4.65 2.71
Earnings per common share, diluted 4.51 4.56 2.67

Basic Weighted Average Shares 1,540.0 1,465.0 1,411.0

Diluted Weighted Average Shares 1,570.0 1,492.0 1,431.0

EBITDA

Vertical Analysis Dec-16 Dec-17 Dec-18

Net sales 100.0% 100.0% 100.0%
Cost of sales 87.0% 87.4% 90.3%
Gross profit Margin 13.0% 12.6% 9.7%

Selling, general and administrative expenses 5.9% 5.7% 5.4%

Other (income) expense, net 0.0% 0.0% 0.1%
Operating profit Margin (EBIT Margin) 7.1% 6.9% 4.2%
Non-service related postretirement costs 0.1%
Interest expense, net 0.3% 0.2% 0.2%

Income before income taxes (EBT Margin) 6.7% 6.6% 3.9%

Provision for income taxes 1.8% 1.9% 1.3%
Net income Margin including noncontrolling interests 4.8% 4.7% 2.6%
Less: Net income attributable to noncontrolling interests (% 2.2% 0.3% 0.2%
Net income Margin 4.7% 4.7% 2.6%

Effective Tax Rates 27.5% 28.8% 32.7%

Horizontal Analysis Dec-16 Dec-17 Dec-18
Net sales -2.4% 1.0%
Cost of sales -2.0% 4.4%
Gross profit -5.1% -22.4%

Selling, general and administrative expenses -6.0% -3.3%

Other (income) expense, net 100.0% 50.0%
Operating profit -4.5% -38.4%
Interest expense, net -18.9% 3.6%

Income before income taxes -3.8% -40.6%

Provision for income taxes 0.9% -32.5%
Net income including noncontrolling interests -5.7% -43.8%
Less: Net income attributable to noncontrolling interests -88.7% -50.0%
Net income attributable to ABC Company -3.8% -43.8%

Trend Analysis Dec-16 Dec-17 Dec-18

Sales 149,184 145,588 147,049
Net Profit 7,075 6,807 3,825
2016 2017 2018
Sales 100.0% 97.6% 98.6%
Net Profit 100.0% 96.2% 54.1%

Automobiles
North America $ 62,603 $ 60,290
% growth (yoy) -3.7%

Latin America 46,588 33,821

% growth (yoy) -27.4%

Europe/South Pacific 18,926 29,410

% growth (yoy) 55.4%

Asia 8,735 11,764

% growth (yoy) 34.7%

Africa/Eurasia 5,824 5,882

% growth (yoy) 1.0%

Total Automobiles 0 142,676 141,167

-1.1%

Trucks 2,912 5,882

% growth (yoy) 102.0%

Total Net sales $ - $ 145,588 $ 147,049

 Dec-19 Dec-20 Dec-21 Dec-22 Dec-23 Dec-24 Dec-25
137,237 122,485 126,319 131,298 138,216 147,751 158,777
122,759 107,983 111,792 116,199 122,321 130,759 140,517
14,478 14,502 14,527 15,099 15,895 16,991 18,259

7,559 5,943 6,948 7,221 7,602 8,126 8,733

100 10 - - - - -
6,819 8,549 7,579 7,878 8,293 8,865 9,527
201 188 - - - - -
353 857 379 394 415 443 476

6,265 7,504 7,200 7,484 7,878 8,422 9,050

1,911 2,004 2,021 2,101 2,211 2,364 2,540
4,354 5,500 5,179 5,383 5,667 6,058 6,510
65 106 88 92 96 103 111
4,289 5,394 5,091 5,292 5,571 5,955 6,399
3.01 3.76 3.26 3.40 3.61 3.92 4.29
2.98 3.74 3.25 3.39 3.61 3.92 4.28

1,424.0 1,433.0 1,563.3 1,558.3 1,541.2 1,518.3 1,493.0

1,439.0 1,442.0 1,565.1 1,560.0 1,542.9 1,520.1 1,494.7

Dec-19 Dec-20 Dec-21 Dec-22 Dec-23 Dec-24 Dec-25

100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
89.5% 88.2% 88.5% 88.5% 88.5% 88.5% 88.5%
10.5% 11.8% 11.5% 11.5% 11.5% 11.5% 11.5%

5.5% 4.9% 5.5% 5.5% 5.5% 5.5% 5.5%

0.1% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
5.0% 7.0% 6.0% 6.0% 6.0% 6.0% 6.0%
0.1% 0.2% 0.0% 0.0% 0.0% 0.0% 0.0%
0.3% 0.7% 0.3% 0.3% 0.3% 0.3% 0.3%

4.6% 6.1% 5.7% 5.7% 5.7% 5.7% 5.7%

1.4% 1.6% 1.6% 1.6% 1.6% 1.6% 1.6%
3.2% 4.5% 4.1% 4.1% 4.1% 4.1% 4.1%
1.5% 1.9% 1.7% 1.7% 1.7% 1.7% 1.7%
3.1% 4.4% 4.0% 4.0% 4.0% 4.0% 4.0%

30.5% 26.7% 22.0% 22.0% 22.0% 22.0% 22.0%

 Dec-19 Dec-20 Dec-21 Dec-22 Dec-23 Dec-24 Dec-25
-6.7% -10.7% 3.1% 3.9% 5.3% 6.9% 7.5%
-7.5% -12.0% 3.5% 3.9% 5.3% 6.9% 7.5%
1.4% 0.2% 0.2% 3.9% 5.3% 6.9% 7.5%

-5.3% -21.4% 16.9% 3.9% 5.3% 6.9% 7.5%

33.3% -90.0% -100.0% 0.0% 0.0% 0.0% 0.0%
9.7% 25.4% -11.3% 3.9% 5.3% 6.9% 7.5%
10.3% 142.8% -55.8% 3.9% 5.3% 6.9% 7.5%

9.9% 19.8% -4.0% 3.9% 5.3% 6.9% 7.5%

2.4% 4.9% 0.9% 3.9% 5.3% 6.9% 7.5%
13.6% 26.3% -5.8% 3.9% 5.3% 6.9% 7.5%
622.2% 63.1% -16.9% 3.9% 5.3% 6.9% 7.5%
12.1% 25.8% -5.6% 3.9% 5.3% 6.9% 7.5%

Dec-19 Dec-20 Dec-21 Dec-22 Dec-23 Dec-24 Dec-25

137,237 122,485 126,319 131,298 138,216 147,751 158,777
4,289 5,394 5,091 5,292 5,571 5,955 6,399
2019 2020 2021 2022 2023 2024 2025
92.0% 82.1% 84.7% 88.0% 92.6% 99.0% 106.4%
60.6% 76.2% 72.0% 74.8% 78.7% 84.2% 90.4%

$ 53,522 $ 47,769 $ 49,202 $ 51,662 $ 55,279 $ 60,254 $ 66,279

-11.2% -10.7% 3.0% 5.0% 7.0% 9.0% 10.0%

34,309 30,621 31,234 32,171 33,458 35,130 37,238

1.4% -10.7% 2.0% 3.0% 4.0% 5.0% 6.0%

21,958 19,598 20,577 21,401 22,257 23,592 24,772

-25.3% -10.7% 5.0% 4.0% 4.0% 6.0% 5.0%

13,724 13,473 14,012 14,433 15,010 15,760 16,548

16.7% -1.8% 4.0% 3.0% 4.0% 5.0% 5.0%

8,234 4,899 5,046 5,198 5,458 5,785 6,132

40.0% -40.5% 3.0% 3.0% 5.0% 6.0% 6.0%

131,748 116,361 120,072 124,864 131,460 140,522 150,970

-6.7% -11.7% 3.2% 4.0% 5.3% 6.9% 7.4%

5,489 6,124 6,247 6,434 6,756 7,229 7,807

-6.7% 11.6% 2.0% 3.0% 5.0% 7.0% 8.0%

$ 137,237 $ 122,485 $ 126,319 $ 131,298 $ 138,216 $ 147,751 $ 158,777

Country
Algeria
Bangladesh
Canada
Denmark
Estonia
Finland
Germany
Hungary
Iceland
Japan
Kenya
Luxembourg
Maldives
Nigeria
Portugal
United States
Zambia
 Module 1-03: Data Types in Excel
Company City
Intel Budapest
General Motors London
Microsoft Helsinki
Google Washington
Ford Motor Company Paris
Alibaba Berlin
el
 Module 2-01: Vie
January February March
Revenue 80 130 225
Expenses 114 231 105
Profit
Account Id Account Name Profit (2016) Profit (2017)
200327000561788000 Granite Heavy Equipment Repair 80 67
200327000561359000 RSB Logistic Inc 90 33
200327000561106000 PassTime GPS 110 18
200327000560860000 Zancon Group of Companies 55 25
200327000560860000 A1 Bonding Co-Operative 45 37
200327000560860000 Martin Grove Volkswagen 33 44
200327000560698000 Capital City Renewables 23 61
200327000560063000 US1 Transport Inc 14 12
200327000560038000 Sister Towing (T-Mobile Client) 17 18
200327000560030000 Good Guys Of Chattanooga Inc. (T-Mobile Client) 8 22
dule 2-01: Viewing, entering and copying data
April May June
300 325 500
150 167 400
Total Profit
Main Contact Email Main Fleet Contact Name
(2016+2017)
147 granite@[Link]
123 Brian@[Link] Brian Nolan
128 vcambell@[Link] Vince Cambell
80 strif@[Link]
82 imanimens@[Link]
77 jake@[Link] Jake Rockwell
84 klozan@[Link]
26 transport@[Link] John Andrews
35 day@[Link]
30
Currency
USD
CAD
USD
USD
USD
USD
USD
USD
USD
USD
 Module 2-02: Filling and form
Financial data January February March April
Revenue 80 130 225 300
Expenses 114 231 105 150

Financial data
January February March April
Revenue 80 130 225 300
Expenses 114 231 105 150

Date Issued Ticket number Customer Sales Associate Amount

3/26/2021 973454 Jill Hadlee Mike $25
4/1/2021 845465 Marissa May Jack $50
4/3/2021 343223 John Donavan Andi $25

Umar 17
3-Oct
17:55
3:55 PM
02: Filling and formatting cells
May June
325 500
167 400

May June
325 500
167 400

Date Redeemed Days Since Issue

1111
4/15/2021 1105
1103
 Module 2-03: Excel Formula B
Jan Feb Mar Apr May Jun Jul Aug Sep
Revenue 97 45 33 63 21 110 115 107 103
Expenses 57 65 33 17 28 74 67 71 81
Net Profit 40 -20 0 46 -7 36 48 36 22
Excel Formula Basics
Oct Nov Dec Total Average
86 91 103 974 81.16667
62 47 55
24 44 48
 Module 2-04: Exploring Excel
Jan Feb Mar Apr May Jun Jul Aug

Revenue 77 45 33 63 21 110 115 107

1st Quarter 155

2nd Quarter 194

3rd Quarter 325

4th Quarter 280

Units sold by country Jan Feb Mar Apr May Jun

Canada 13 21 13 17 18 25

Germany 11 12 10 15 14 17

India 14 17 16 13 15 19

Brazil 5 11 7 11 9 13

Employee First Name Employee ID Department 1 2 3 4 5 6

Account
John 1 Management - - - - - -
Jack 2 Marketing 127.91 218.85 474.41 26.32 355.85 172.31
Rohan 3 Marketing 410.65 344.86 210.84 32.9 303.14 -
Account
Emily 4 Management 416.94 403.9 374.08 412.63 414.94 316.42
Account
Robert 5 Management - - - - - -
Account
Sanchez 6 Management - - - - - -
Junlyn 7 HR 297.07 292.65 290.77 251.65 147.02 292.47
Paul 8 Sales 469.06 462.09 459.1 458.48 413.24 461.8
Maricynth 9 Finance 469.58 462.6 459.61 458.99 459.67 462.31
Nenad 10 Marketing 407.17 112.31 248.68 531.71 440.03 545.18
Yaroslav 11 Legal 38.01 651.41 900.14 416.03 476.16 748.28
Product
Florian 12 Development 2605.88 2567.15 2550.58 2547.1 3446.9 2725.89
Gundogdu 13 Marketing - - - - - -
Raheem 14 Success 469.06 462.09 380.04 387.16 91.83 379.7
Augustin 15 Support 842.57 778.7 450.6 416.03 493.18 803.87
Deepti 16 HR - - - - - -
Michael 17 Management - 1963.87 - 1840.28 - -
Marianne 18 Support 260.59 256.71 255.06 254.71 255.09 256.55
Sheldon 19 Support 260.59 256.71 255.06 254.71 255.09 256.55
Mary 20 Support 260.59 256.71 255.06 254.71 255.09 256.55
Product
Ibraheem 21 Development 643.65 670.67 520.96 629.13 779.52 763.67
Product
Shakib 22 Development 57.85 56.99 56.62 56.55 56.63 56.96
Jonathan 23 Support 1302.94 1283.57 1275.29 1273.55 1275.45 1282.77
Product
Jure 24 Development - - - - - -
Product
NikolaI 25 Development 948.54 965.46 979.42 978.09 979.54 985.17
Product
Andrey 26 Development 2006.53 1896.61 2414.54 2139.56 2244.79 2078.09
Product
Denis 27 Development 534.21 526.26 522.87 522.16 522.93 420.75
Product
Alex 28 Development 1511.41 1677.41 1785.4 1782.97 1785.63 1795.88
Rupam 29 Management - - - - - -
Arpit 30 Marketing - - - - - -
Kamal 31 Support 905.54 - - - 886.44 -
Marnelie 32 Management - - - - - -
Account
Muhammad 33 Management - - - - - -
Product
Mahesh 34 Development - - - - - -
Product
Oscar 35 Development - - - - - -
Product
Diego 36 Development - - - - - -
Muzammil 37 Sales - - - - - -
Igor 38 Sales - - - - - -
Product
Andreea 39 Development - - - - - -
Daiane 40 Marketing - - - - - -
Ihor 41 Marketing - - - - - -
Gracie 42 Support - - - - - -
 Product
Dmitry 43 Development - - - - - -
Ashish 44 Marketing - - - - - -
Vida 45 Support - - - - - -
Renu 46 Marketing - - - - - -
Product
Giuseppe 47 Development - - - - - -
Mihaly 48 Sales - - - - - -
Product
Paras 49 Development - - - - - -
Alexis 50 Marketing 117.26 77.01 191.29 152.83 153.05 153.93
Shubham 51 HR 203.58 200.56 199.26 198.99 199.29 200.43
Prem 52 HR 144.41 37.44 87.78 93.61 43.15 -
Krunal 53 HR - - - - - -
Product
Neelam 54 Development 240.39 346.56 344.33 343.86 344.37 207.81
Ajay 55 HR 325.74 320.89 318.82 318.39 318.86 320.69
Dhruv 56 HR 312.71 308.06 306.07 305.65 306.11 307.87
Seb 57 Support 351.79 346.56 344.33 - 344.37 346.35
Product
Masandiswe 58 Development - 366.88 - - - -
Nensi 59 HR 17.37 192.54 191.29 191.03 191.32 192.42
Product
Kaosara 60 Development - - - - - 45.96
Rachel 61 Support - - - - - -
Ivy 62 Marketing - - - - - 64.14
Product
Gurgen 63 Development 625.41 - - - - -
Katherina 64 HR - - - - - -
Product
Joseph 65 Development - - - - - -
Product
Milan 66 Development - - - - - -
Mubariz 67 Marketing - - - - - -
Anne 68 HR - - - - - -
Josan 69 HR - - - - - -
Jairo 70 Legal - - - - - -
Sazidur 71 Marketing - - - - - -
Usman 72 Finance - - - - - -
Product
Sladjan 73 Development - - - - - -
Arman 74 Marketing - - - - - -
Aleksandar 75 Marketing - - - - - -
Victor 76 HR - - - - - -
xploring Excel Functions
Sep Oct Nov Dec Total

103 86 91 103

13

23

13 14 18 36

72

7 8 9 10 11 12 Total salary ID

- - - - - - - 12
133.43 33.66 467.88 116.03 13.53 75.5 2,216 11
100.08 - - 34.12 81.21 116.69 1,634 1

325.41 396.14 418.23 406.88 169.41 421.59 4,477 7

- - - - - - - 6

- - - - - - -
294.42 297.11 299.23 - - - 2,462
464.87 469.12 472.47 475.57 471.57 478.28 5,556
 465.39 501.89 524.97 528.41 523.97 531.42 5,849
455.19 283.43 597.15 607.68 553.44 534.74 5,317
1009.38 243.25 222.02 454.66 351.49 309.99 5,821

2744.05 2769.1 204.52 2807.2 2783.58 2823.17 30,575

- - - - - - -
464.87 57.34 - - - - 2,692
344.36 373.56 419.98 202.55 96.06 35.43 5,257
- - - - - - -
- - - - - - 3,804
258.26 260.62 262.49 264.21 261.98 265.71 3,112
232.44 260.62 262.49 264.21 261.98 265.71 3,086
258.26 260.62 262.49 257.6 261.98 265.71 3,105

678.81 764.56 527.32 783.11 750.64 735.06 8,247

57.33 57.86 58.27 58.65 58.16 58.99 691

1205.22 1303.11 1312.43 1321.03 1309.92 - 14,145

- - - - - - -

991.73 1000.79 1007.94 1014.55 1006.02 1020.33 11,878

2117.76 2371.65 2336.12 2298.6 2095.87 2391.39 26,392

529.44 534.27 538.1 541.62 - - 5,193

1807.84 1867.22 1910.9 1923.43 1907.24 1934.37 21,690

- - - - - - -
- - - - - - -
- - - 918.12 - - 2,710
- - - - - - -

- - - - - - -

- - - - - - -

- - - - - - -

- - - - - - -
- - - - - - -
- - - - - - -

- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -

- - - - - - -
- - - - - - -

- - - - - - -
116.22 97.73 177.18 178.34 196.49 99.64 1,711
201.77 203.61 205.07 247.69 245.61 249.1 2,555
25.61 18.24 107.19 16.95 32.09 1.55 608
- - - - - - -

348.66 351.84 143.71 71.34 320.27 324.83 3,388

322.83 325.78 328.11 330.26 327.48 272.35 3,830
309.92 312.75 314.98 317.05 314.38 318.85 3,734
348.66 351.84 - - - - 2,434

- - - - - - 367
193.7 195.47 196.86 198.16 196.49 199.28 2,156

85.01 47.78 26.25 77.06 36.02 63.11 381

451.96 326.86 643.09 624.19 519.61 - 2,566
- - - - - - 64

- - - - - - 625
- - - 118.89 261.98 159.43 540

- - - 99.08 98.24 - 197

- - - - 392.98 - 393
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -

- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
First Name ID Total Salary

Florian 33 0
Yaroslav 15 5256.89
John 2 2215.68

Junlyn 7 2462.39

Sanchez 17 3804.15
 Module 2-05: Referencing
Monthly Revenues
2020 2021
January $ 351,716 $ 258,421 Jan-21 $ 258,421
February $ 327,119 $ 415,872 Q4 $ 952,877
March $ 384,640 $ 405,097 Q1 and Q4 $ 2,016,352
April $ 385,927 $ 302,800 2020 $ 4,266,324
May $ 343,478 $ 445,228 September $ 716,407
June $ 321,405 $ 420,308
July $ 516,736 $ 378,508
August $ 248,127 $ 514,149
September $ 434,300 $ 282,107
October $ 404,345 $ 348,363
November $ 290,859 $ 327,310
December $ 257,673 $ 335,811

Growth Rate 3%
Headcount 21,020
2016 21,651
2017 22,300
2018 22,969
2019 23,658
2020 24,368
2021 25,099
2022 25,852
2023 26,628
2024 27,426
05: Referencing Data in Formulas
 Module 02-06: E
Question 1 of 2: Apply XLOOKUP to identify the employee ID and the department per employee in Table 2

TABLE 1 TABLE 2
Employee ID Department Employee Employee
10154 Sales Jack Johnson Mike Johnston
10155 Sales Robert Speck Robert Blume
10156 Sales Peter Daniels Andrew Cairns
10157 Sales Robert Andrew Robert Muller
10158 Sales Andrew Cairns Richard Elliot
10159 R&D Bettina Gurtler Cristopher Doyle
10160 R&D Paul Schwab Robert Blume
10161 R&D Alessandro Trani Chris Pike
10162 R&D Victor Meier Dan Ziegler
10163 R&D Aaron Ramsy Wolfgang Klaus
10164 R&D Wolfgang Klaus
10165 R&D Jason Bond
10166 R&D Maria Tot
10167 Logistics Natalie Porter
10168 Logistics Andrey Cooper
10169 Logistics Robert Muller
10170 Logistics Anne Withers
10171 Logistics Corinna Schmidh
10172 Logistics Mike Johnston
10173 Operations Gary Miller
10174 Operations Richard Elliot
10175 Operations Roger Mund
10176 Operations Richard Garrett
10177 Operations Paul Hill
10178 Operations Cristopher Doyle
10179 Operations Betina Bauer
10180 Finance Daniela Schreiber
10181 Finance Dan Ziegler
10182 Finance Robert Richardson
10183 Finance Robert Blume
10184 Finance Lukas Williams
10185 Sales Steven Robinson
10186 Sales Chris Pike
10187 Sales Roberta Davies
10188 Sales Phil Salt
10189 Sales Claire Munsey
Question 2 of 2: Identify and fix the error in the highlighted cells below

Investment Rate 3%
Initial investment 1,150,000
2016 1,184,500
2017 1,220,035
2018 1,256,636
2019 1,294,335
2020 1,333,165
2021 1,373,160
2022 1,414,355
2023 1,456,786
2024 1,500,489
Module 02-06: Exercise 1

ID Department
10172 Logistics
#NAME? Finance
#NAME? Sales
#NAME? Logistics
#NAME? Operations
#NAME? Operations
#NAME? Finance
#NAME? Sales
#NAME? Finance
#NAME? R&D
 Module 3-01: Introduction

Full Office Date Age Customer Contract

Name Phone of birth since Value
John Ibraheem 7139074515 22-Jul-87 36 4/11/2014 - Present 73470.16129
Jack Shakib 8025785964 30-Jan-88 36 1/15/1997 - 10/26/2014 79708.06452
Rohan Jonathan 9403905923 22-Jan-88 36 10/6/1998 - 7/24/2013 83478.22581
Emily Jure 4434970018 28-Jan-89 35 6/18/1997 - 1/7/2009 97832.25806
Robert NikolaI 7133919698 15-Sep-89 34 9/29/1997 - 3/19/2009 182558.0645
Sanchez Andrey (916) 755-4598 4-Jul-93 30 9/6/1996 - 12/10/2013 166791.9355
Junlyn Denis 706-699-7043 11-Jun-95 28 5/14/2003 - 6/17/2013 67314.51613

Paul Alex 763-784-4022 27-Jul-95 28 3/18/2003 - 4/21/2013 41787.09677

Maricynth Rupam 405-670-5338 14-May-95 28 1/19/2003 - 11/6/2014 197666.129
Nenad Arpit 503-761-2038 8-Sep-95 28 10/11/1998 - 8/26/2015 206056.4516
Yaroslav Kamal 479-474-8668 0
Florian Marnelie 218-326-9637 24-Jan-97 27 10/11/2000 - 7/27/2015 205206.4516
Gundogdu Muhammad 204-637-2429 26-Oct-98 25 12/20/2001 - 7/8/2009 84396.77419
Raheem Mahesh 636-528-5863 8-Nov-99 24 11/1/2003 - 5/8/2015 57979.80769
Augustin Oscar 830 741 9019 2-Nov-00 23 1/26/2004 - 11/12/2009 161336.5385
Deepti Diego 573-474-2065 4-Aug-01 22 12/10/2004 - Present 139073.0769
Michael Muzammil 775-786-2677 18-May-03 20 3/6/2007 - Present 123151.9231

Marianne Igor 847-447-3222 11-Feb-05 19 9/6/2008 - 7/25/2015 190563.4615

Sheldon Andreea 507-299-2122 9-Apr-06 18 1/11/2013 - Present 34771.53846
Mary Daiane 502-810-9979 30-May-07 16 6/26/2007 - 7/13/2009 238098.0769
Introduction to Data Quality
Module 3-02: Importing File D
Importing File Data
 Module 3-03: Removing dupli
Last Name First Name Email Start Date Age
Andrews John JohnAndrews@[Link] 24-Jan-97 27
Robert Jack JackRobert@[Link] 26-Oct-98 44
Patel Rohan RohanPatel@[Link] 8-Nov-99 21
Robinson Emily EmilyRobinson@[Link] 2-Nov-00 19
Johnson Robert RobertJohnson@[Link] 4-Aug-01 43
Junior Sanchez SanchezJunior@[Link] 18-May-03 57
Xi Junlyn JunlynXi@[Link] 19-May-03 31
McFadden Paul PaulMcFadden@[Link] 11-Feb-05 33
Jacob Maricynth MaricynthJacob@[Link] 9-Apr-06 38
Jovick Nenad NenadJovick@[Link] 30-May-07 45
Raslow Yaroslav YaroslavRaslow@[Link] 14-Oct-12 19
Leslie Florian FlorianLeslie@[Link] 14-Jul-06 25
Kemal Gundogdu GundogduKemal@[Link] 22-Aug-18 22
Sorinson Raheem RaheemSorinson@[Link] 8-Nov-99 54
Andrews John JohnAndrews@[Link] 24-Jan-97 27
Delgado Augustin AugustinDelgado@[Link] 2-Nov-00 51
Sharma Deepti DeeptiSharma@[Link] 4-Aug-01 27
Rampaul Michael MichaelRampaul@[Link] 18-May-03 44
Stevenson Marianne MarianneStevenson@[Link] 11-Feb-05 21
Cooper Sheldon SheldonCooper@[Link] 11-Feb-05 19
Alfonso Mary MaryAlfonso@[Link] 14-Oct-12 59
Khan Ibraheem IbraheemKhan@[Link] 14-Jul-06 33
Robinson Emily EmilyRobinson@[Link] 2-Nov-00 19
Hassan Shakib ShakibHassan@[Link] 22-Aug-18 41
Tremlett Jonathan JonathanTremlett@[Link] 19-Sep-22 40
Rinkaul Jure JureRinkaul@[Link] 19-Sep-22 39
Prem NikolaI NikolaIPrem@[Link] 19-Sep-22 27
Krunal Andrey AndreyKrunal@[Link] 19-Sep-22 44
Neelam Denis DenisNeelam@[Link] 19-Sep-22 21
Ajay Alex AlexAjay@[Link] 19-Sep-22 19
Dhruv Rupam RupamDhruv@[Link] 19-Sep-22 47
Seb Arpit ArpitSeb@[Link] 19-Sep-22 44
Masandiswe Kamal KamalMasandiswe@[Link] 19-Sep-22 32
Nensi Marnelie MarnelieNensi@[Link] 19-Sep-22 23
Muhamma
Kaosara d MuhammadKaosara@[Link] 19-Sep-22 31
Rachel Mahesh MaheshRachel@[Link] 19-Sep-22 33
Ivy Oscar OscarIvy@[Link] 8-Nov-99 38
Gurgen Diego DiegoGurgen@[Link] 2-Nov-00 24
Katherina Muzammil MuzammilKatherina@[Link] 4-Aug-01 28
Joseph Igor IgorJoseph@[Link] 8-Nov-99 27
Milan Andreea AndreeaMilan@[Link] 2-Nov-00 44
Mubariz Daiane DaianeMubariz@[Link] 4-Aug-01 21
Anne Ihor IhorAnne@[Link] 8-Nov-99 19
Josan Gracie GracieJosan@[Link] 2-Nov-00 29
Jairo Dmitry DmitryJairo@[Link] 4-Aug-01 31
Sazidur Ashish AshishSazidur@[Link] 8-Nov-99 33
Usman Vida VidaUsman@[Link] 2-Nov-00 38
Sladjan Renu RenuSladjan@[Link] 4-Aug-01 27
Arman Giuseppe GiuseppeArman@[Link] 8-Nov-99 44
Aleksandar Mihaly MihalyAleksandar@[Link] 2-Nov-00 21
Victor Paras ParasVictor@[Link] 4-Aug-01 19
: Removing duplicates and inaccurate data
 Module 03-04: Ident
Last Name First Name Email Start Date Age Department
Andrews John JohnAndrews@[Link] 24-Jan-97 27 Operations
Robert Jack JackRobert@[Link] 26-Oct-98 44 Operations
Patel Rohan RohanPatel@[Link] 8-Nov-99 21 Sales
Robinson Emily EmilyRobinson@[Link] 2-Nov-00 19 Finance
Johnson Robert RobertJohnson@[Link] 4-Aug-01 43 HR
Junior Sanchez SanchezJunior@[Link] 18-May-03 57 Finance
Xi Junlyn JunlynXi@[Link] 19-May-03 31 Logistics
McFadden Paul PaulMcFadden@[Link] 11-Feb-05 33 Operations
Jacob Maricynth MaricynthJacob@[Link] 9-Apr-06 38 Finance
Jovick Nenad NenadJovick@[Link] 30-May-07 45 Sales
Raslow Yaroslav YaroslavRaslow@[Link] 14-Oct-12 19 Sales
Leslie Florian FlorianLeslie@[Link] 14-Jul-06 25 Logistics
Kemal Gundogdu GundogduKemal@[Link] 22-Aug-18 22 HR
Sorinson Raheem RaheemSorinson@[Link] 8-Nov-99 54 Finance
Andrews John JohnAndrews@[Link] 24-Jan-97 27 Operations
Delgado Augustin AugustinDelgado@[Link] 2-Nov-00 51 Sales
Sharma Deepti DeeptiSharma@[Link] 4-Aug-01 27 Logistics
Rampaul Michael MichaelRampaul@[Link] 18-May-03 44 Sales
Stevenson Marianne MarianneStevenson@[Link] 11-Feb-05 21 Operations
Cooper Sheldon SheldonCooper@[Link] 11-Feb-05 19 Sales
Alfonso Mary MaryAlfonso@[Link] 14-Oct-12 59 Finance
Khan Ibraheem IbraheemKhan@[Link] 14-Jul-06 33 Logistics
Robinson Emily EmilyRobinson@[Link] 2-Nov-00 19 Finance
Rampaul Michael MichaelRampaul@[Link] 18-May-03 44 Sales
Hassan Shakib ShakibHassan@[Link] 22-Aug-18 41 Sales
Tremlett Jonathan JonathanTremlett@[Link] 19-Sep-22 40 Finance
Rinkaul Jure JureRinkaul@[Link] 19-Sep-22 39 Logistics
Prem NikolaI NikolaIPrem@[Link] 19-Sep-22 27 Operations
Krunal Andrey AndreyKrunal@[Link] 19-Sep-22 44 Sales
Neelam Denis DenisNeelam@[Link] 19-Sep-22 21 Operations
Ajay Alex AlexAjay@[Link] 19-Sep-22 19 Finance
Dhruv Rupam RupamDhruv@[Link] 19-Sep-22 47 Logistics
Seb Arpit ArpitSeb@[Link] 19-Sep-22 44 Sales
Masandiswe Kamal KamalMasandiswe@[Link] 19-Sep-22 32 Logistics
Nensi Marnelie MarnelieNensi@[Link] 19-Sep-22 23 Finance
Muhamma
Kaosara d MuhammadKaosara@[Link] 19-Sep-22 31 Logistics
Rachel Mahesh MaheshRachel@[Link] 19-Sep-22 33 HR
Ivy Oscar OscarIvy@[Link] 8-Nov-99 38 Operations
Gurgen Diego DiegoGurgen@[Link] 2-Nov-00 24 Operations
Ajay Alex AlexAjay@[Link] 19-Sep-22 19 Finance
Katherina Muzammil MuzammilKatherina@[Link] 4-Aug-01 28 Finance
Joseph Igor IgorJoseph@[Link] 8-Nov-99 27 Sales
Milan Andreea AndreeaMilan@[Link] 2-Nov-00 44 HR
Mubariz Daiane DaianeMubariz@[Link] 4-Aug-01 21 Finance
Anne Ihor IhorAnne@[Link] 8-Nov-99 19 Operations
Josan Gracie GracieJosan@[Link] 2-Nov-00 29 Logistics
Jairo Dmitry DmitryJairo@[Link] 4-Aug-01 31 Finance
Sazidur Ashish AshishSazidur@[Link] 8-Nov-99 33 Sales
Usman Vida VidaUsman@[Link] 2-Nov-00 38 Sales
Sladjan Renu RenuSladjan@[Link] 4-Aug-01 27 Logistics
Arman Giuseppe GiuseppeArman@[Link] 8-Nov-99 44 HR
Aleksandar Mihaly MihalyAleksandar@[Link] 2-Nov-00 21 Sales
Victor Paras ParasVictor@[Link] 4-Aug-01 19 HR
le 03-04: Identifying Data Attributes
ID Salary
0300-113 63,000
0300-569 59,000
500-345 58,000
0200-111 61,000
0800-1 67,000
0200-100 83,000
600-345 55,000
0300-512 77,000
0200-124 113,000
500-114 79,000
500-190 60,000
600-35 73,000
0800-7 69,000
0200-119 67,000
0300-113 63,000
500-145 103,000
600-333 59,000
500-098 107,500
0300-217 83,000
500-045 60,000
0200-137 63,000
600-217 54,500
0200-111 61,000
500-098 107,500
500-871 62,300
0200-265 78,000
600-234 60,000
0300-187 65,000
500-750 115,000
0300-176 88,000
0200-891 61,000
600-786 62,300
500-158 107,000
600-547 62,100
0200-453 63,000

600-548 60,000
0800-11 63,000
0300-111 73,000
0300-157 74,000
0200-891 61,000
0200-515 67,500
500-118 93,000
0800-19 64,000
0200-657 72,000
0300-110 71,000
600-114 70,000
0200-733 73,000
500-119 90,000
500-187 97,000
600-308 77,000
0800-23 60,000
500-116 91,000
0800-37 62,000
 Module 03-0
Last Name First Name Email Start Date Age Department
andrews JOHN JohnAndrews@[Link] 24-Jan-97 27 Operations
robert JACK JackRobert@[Link] 26-Oct-98 44 Operations
patel ROHAN RohanPatel@[Link] 8-Nov-99 21 Sales
robinson EMILY EmilyRobinson@[Link] 2-Nov-00 19 Finance
johnson ROBERT RobertJohnson@[Link] 4-Aug-01 43 HR
junior SANCHEZ SanchezJunior@[Link] 18-May-03 57 Finance
xi JUNLYN JunlynXi@[Link] 19-May-03 31 Logistics
mcfadden PAUL PaulMcFadden@[Link] 11-Feb-05 33 Operations
jacob MARICYNTH MaricynthJacob@[Link] 9-Apr-06 38 Finance
jovick NENAD NenadJovick@[Link] 30-May-07 45 Sales
raslow YAROSLAV YaroslavRaslow@[Link] 14-Oct-12 19 Sales
leslie FLORIAN FlorianLeslie@[Link] 14-Jul-06 25 Logistics
kemal GUNDOGDU GundogduKemal@[Link] 22-Aug-18 22 HR
sorinson RAHEEM RaheemSorinson@[Link] 8-Nov-99 54 Finance
andrews JOHN JohnAndrews@[Link] 24-Jan-97 27 Operations
delgado AUGUSTIN AugustinDelgado@[Link] 2-Nov-00 51 Sales
sharma DEEPTI DeeptiSharma@[Link] 4-Aug-01 27 Logistics
rampaul MICHAEL MichaelRampaul@[Link] 18-May-03 44 Sales
stevenson MARIANNE MarianneStevenson@[Link] 11-Feb-05 21 Operations
cooper SHELDON SheldonCooper@[Link] 11-Feb-05 19 Sales
alfonso MARY MaryAlfonso@[Link] 14-Oct-12 59 Finance
khan IBRAHEEM IbraheemKhan@[Link] 14-Jul-06 33 Logistics
robinson EMILY EmilyRobinson@[Link] 2-Nov-00 19 Finance
rampaul MICHAEL MichaelRampaul@[Link] 18-May-03 44 Sales
hassan SHAKIB ShakibHassan@[Link] 22-Aug-18 41 Sales
tremlett JONATHAN JonathanTremlett@[Link] 19-Sep-22 40 Finance
rinkaul JURE JureRinkaul@[Link] 19-Sep-22 39 Logistics
prem NIKOLAI NikolaIPrem@[Link] 19-Sep-22 27 Operations
krunal ANDREY AndreyKrunal@[Link] 19-Sep-22 44 Sales
neelam DENIS DenisNeelam@[Link] 19-Sep-22 21 Operations
ajay ALEX AlexAjay@[Link] 19-Sep-22 19 Finance
dhruv RUPAM RupamDhruv@[Link] 19-Sep-22 47 Logistics
seb ARPIT ArpitSeb@[Link] 19-Sep-22 44 Sales
masandiswe KAMAL KamalMasandiswe@[Link] 19-Sep-22 32 Logistics
nensi MARNELIE MarnelieNensi@[Link] 19-Sep-22 23 Finance
kaosara MUHAMMAD MuhammadKaosara@[Link] 19-Sep-22 31 Logistics
rachel MAHESH MaheshRachel@[Link] 19-Sep-22 33 HR
ivy OSCAR OscarIvy@[Link] 8-Nov-99 38 Operations
gurgen DIEGO DiegoGurgen@[Link] 2-Nov-00 24 Operations
ajay ALEX AlexAjay@[Link] 19-Sep-22 19 Finance
katherina MUZAMMIL MuzammilKatherina@[Link] 4-Aug-01 28 Finance
joseph IGOR IgorJoseph@[Link] 8-Nov-99 27 Sales
milan ANDREEA AndreeaMilan@[Link] 2-Nov-00 44 HR
mubariz DAIANE DaianeMubariz@[Link] 4-Aug-01 21 Finance
anne IHOR IhorAnne@[Link] 8-Nov-99 19 Operations
josan GRACIE GracieJosan@[Link] 2-Nov-00 29 Logistics
jairo DMITRY DmitryJairo@[Link] 4-Aug-01 31 Finance
sazidur ASHISH AshishSazidur@[Link] 8-Nov-99 33 Sales
usman VIDA VidaUsman@[Link] 2-Nov-00 38 Sales
sladjan RENU RenuSladjan@[Link] 4-Aug-01 27 Logistics
arman GIUSEPPE GiuseppeArman@[Link] 8-Nov-99 44 HR
aleksandar MIHALY MihalyAleksandar@[Link] 2-Nov-00 21 Sales
victor PARAS ParasVictor@[Link] 4-Aug-01 19 HR
Module 03-05: Cleaning Data
ID Salary
0300-113 63,000
0300-569 59,000
500-345 58,000
0200-111 61,000
0800-1 67,000
0200-100 83,000
600-345 55,000
0300-512 77,000
0200-124 113,000
500-114 79,000
500-190 60,000
600-35 73,000
0800-7 69,000
0200-119 67,000
0300-113 63,000
500-145 103,000
600-333 59,000
500-098 107,500
0300-217 83,000
500-045 60,000
0200-137 63,000
600-217 54,500
0200-111 61,000
500-098 107,500
500-871 62,300
0200-265 78,000
600-234 60,000
0300-187 65,000
500-750 115,000
0300-176 88,000
0200-891 61,000
600-786 62,300
500-158 107,000
600-547 62,100
0200-453 63,000
600-548 60,000
0800-11 63,000
0300-111 73,000
0300-157 74,000
0200-891 61,000
0200-515 67,500
500-118 93,000
0800-19 64,000
0200-657 72,000
0300-110 71,000
600-114 70,000
0200-733 73,000
500-119 90,000
500-187 97,000
600-308 77,000
0800-23 60,000
500-116 91,000
0800-37 62,000
 M
Question: Using the "Sort" and "Unique" formula combination, find the number of unique sub-categories in the list.

CATEGORY SUB-CATEGORY ITEM

Other Business Materials Ad Boards
Recreation Travel Adaptor plugs, electrical
Other Cleaning Air freshener(s)
Other Cleaning Air freshener(s)
Recreation Camping Air mattress(es)
Recreation Camping Air pump
Other Cleaning All-purpose cleaner, liquid
Other Cleaning All-purpose cleaner, spray
Recreation Camping Altimeters
Recreation R&D Altimeters
Other Cleaning Ammonia
Other Career Development Articles
House Collectibles Artificial fruit
Other Career Development Audio Programs
Other Career Development Audio Programs
Other Career Development Audio Programs
Other Career Development Audio Programs
Other Career Development Audio Programs
Other Career Development Audio Programs
Other Career Development Audio Programs
Other Career Development Audio Programs
Other Career Development Audio Programs
Other Career Development Audio Programs
Other Career Development Audio Programs
Other Career Development Audio Programs
Other Career Development Audio Programs

Other Career Development Audio Programs

Other Career Development Audio Programs
Other Career Development Audio Programs
Recreation Camping Ax
Recreation Travel Backpack(s)
Recreation Camping Backpack, external
Recreation Camping Backpack, internal
House Dishes & Table setting Baking Pan
Recreation Toys Balls
House Collectibles Baseball trading cards

House Collectibles Baseball trading cards

House Collectibles Baseball trading cards
Other Cleaning Bathroom cleaner(s)
Food Beverages Beer(s)
Recreation Travel Belt(s)
Other Car Personal Property Bicycle rack
Other Car Personal Property Bicycle rack
Other Car Personal Property Blanket
Other Car Personal Property Blanket
Recreation Camping Blankets, insulated
Recreation Toys Blast a ball
Appliances Appliance Small Blender
Appliances Appliance Small Blender-Hand
Other Business Materials Books
Recreation Toys Boomerang
Recreation Camping Bottle Bags
Recreation Camping Bottle Holster
Recreation Camping Bottled fuel

Food Beverages Bottled water

Food Beverages Bottled water
Recreation Camping Bottles

House Dishes & Table setting Bowl(s)

House Dishes & Table setting Bowl(s)
House Dishes & Table setting Bowl(s)
House Dishes & Table setting Bowl(s)
House Dishes & Table setting Bowl(s)
House Dishes & Table setting Bowl(s)
House Dishes & Table setting Bowl(s)
Recreation Camping Bowl(s), unbreakable
House Dishes & Table setting Bowl, dip
House Dishes & Table setting Bowl, fruit
House Dishes & Table setting Bowl, miscellaneous
House Dishes & Table setting Bowl, mixing
House Dishes & Table setting Bowl, nesting
House Dishes & Table setting Bowl, Rice
House Dishes & Table setting Bowl, Rice
House Dishes & Table setting Bowl, salad
House Dishes & Table setting Bowl, serving
House Dishes & Table setting Bowl, serving
House Dishes & Table setting Bowl, sugar
House Dishes & Table setting Bowl, sugar
Other Car Personal Property Bra
Appliances Appliance Gourmet Bread making machine
Other Cleaning Brillo pads
Other Cleaning Broom(s)
Recreation Camping Broom, small
Recreation Crafts Brushes
Other Car Personal Property Bucket
Other Cleaning Bucket(s)
House Dishes & Table setting Butter dish
House Dishes & Table setting Butter dish, covered
House Electronics Cables
House Electronics Cables

Recreation Travel Camera Accessories

Recreation Travel Camera film
Recreation Travel Camera lens
Recreation Travel Camera lens
Recreation Travel Camera lens
Recreation Travel Camera lens
Recreation Travel Camera, case
Recreation Travel Camera, case
Recreation Travel Camera, digital
Recreation Travel Camera, digital
Recreation Travel Camera, digital
Recreation Travel Camera, digital
Recreation Travel Camera, disposable
Recreation Travel Camera, polaroid
Recreation Travel Camera, SLR
Recreation Travel Camera, underwater
Recreation Travel Camera, video
Recreation Travel Camera, video, case
Recreation Camping Can opener
Appliances Appliance Small Can opener-electric
Food Beverages Canned juices
Other Car Personal Property Car battery charger
Other Car Personal Property Car chamois
Other Car Personal Property Car first aid kit
Other Car Personal Property Car inverter
Other Car Personal Property Car license plate bracket
Other Car Personal Property Car rugs
Other Car Personal Property Car shampoo
Other Car Personal Property Car sponge
Other Car Personal Property Car stereo
Other Car Personal Property Car stereo
Other Car Personal Property Car towels
Other Car Personal Property Car Wash Mitt
Other Car Personal Property Car wax
House Electronics Card Scan
Other Car Personal Property Cargo cover for Lexus
Other Cleaning Carpet shampoo
Other Cleaning Carpet spotter
Recreation Travel Case(s), jewelry
House Dishes & Table setting Casseroles
Food Condiments Catsup
House Electronics Cell phone, A/C charger
House Electronics Cell phone, Bluetooth, charger
House Electronics Cell phone, car charger
House Electronics Cell phone, earpiece, Bluetooth
House Electronics Cell phone, synch cord
House Dishes & Table setting Chafing dish
Appliances Appliance Gourmet Chafing Dishes
Recreation Camping Chair, Trail
House Dishes & Table setting Chargers
House Electronics Charging Stations
Appliances Appliance Small Chopper
Food Condiments Chutney
Other Car Personal Property Cigarette lighter adapter
Other Car Personal Property Cleaners
Other Cleaning Cleanser, cook top
Recreation Camping Clothing
Recreation Camping Clothing
Recreation Camping Clothing
Recreation Camping Clothing
Recreation Camping Clothing
Recreation Camping Clothing
Recreation Camping Clothing
Recreation Camping Clothing
Recreation Camping Clothing
Recreation Camping Clothing
Recreation Camping Clothing
Recreation Camping Clothing
Recreation Camping Clothing
Recreation Camping Clothing
Food Beverages Coffee
Food Beverages Coffee
Appliances Appliance Small Coffee Grinder
Appliances Appliance Small Coffee maker
Appliances Appliance Small Coffee maker
Appliances Appliance Gourmet Coffee maker, Espresso
House Collectibles Coins
House Collectibles Coins
House Collectibles Coins
Recreation Camping Compass
Recreation Camping Compass
Recreation Camping Compression Sack
House Electronics Computer battery
House Electronics Computer headset
House Electronics Computer Software
House Electronics Computer Software
House Electronics Computer Software
House Electronics Computer Software
House Electronics Computer Software
House Electronics Computer Software
House Electronics Computer Software
House Electronics Computer Software
House Electronics Computer Software
House Electronics Computer Software
House Electronics Computer Software
House Electronics Computer Software
House Electronics Computer Software
House Electronics Computer Software
House Electronics Computer Software
House Electronics Computer Software
House Electronics Computer, desktop
House Electronics Computer, laptop
House Electronics Computer, laptop
House Electronics Computer, laptop
House Electronics Computer, laptop
House Electronics Computer, speakers
House Dishes & Table setting Condiment dishes, bowls
Recreation Camping Container(s)
Recreation Camping Container(s)
Recreation Travel Containers, travel-sized
Recreation Travel Containers, travel-sized
Recreation Travel Containers, travel-sized
Recreation Camping Cook stove
Recreation Camping Cook stove
Food Condiments Cooking wine
Food Condiments Cooking wine
Food Condiments Cooking wine
Food Condiments Cooking wine
Recreation Camping Cookware
Recreation Travel Cosmetic bag(s)
Recreation Camping Cot(s)
Recreation Crafts Craft containers
House Dishes & Table setting Creamer
House Dishes & Table setting Creamer
Appliances Appliance Small Crock pot
Appliances Appliance Small Crock pot
House Dishes & Table setting Cruet set
Recreation Camping Cup
House Dishes & Table setting Cups, demitasse
House Dishes & Table setting Cups, Styrofoam
House Dishes & Table setting Cups, tea
Recreation Camping Day Packs
House Dishes & Table setting Decanter(s)
House Dishes & Table setting Decanter(s)
House Dishes & Table setting Decanter(s)
Other Cleaning Degreaser
Medical Emergency Supplies Detailed area maps
Recreation Camping Detergent
Recreation Camping Detergent
House Dishes & Table setting Dip and Chip set
Recreation Camping Dish pan
House Dishes & Table setting Dish set, formal
House Dishes & Table setting Dish set, Kitchen
House Dishes & Table setting Dish set, Kitchen
House Dishes & Table setting Dish set, semi-formal
Recreation Camping Dish towels
House Dishes & Table setting Dishes
Appliances Appliance Large Disposer wrench
Recreation Camping Ditty Bags
Other Cleaning Drain Maintenance
House Electronics Drive, flash
House Electronics Drive, hard
House Electronics Drive, hard, portable
Appliances Appliance Large Dryer
Recreation Camping Duffle Bags
Other Cleaning Dust mop
Other Cleaning Dust pan
Other Cleaning Duster, feather
Other Cleaning Duster, with extension
Other Business Materials DVD's
Other Business Materials DVD's
Appliances Appliance Gourmet Electric Grill
Appliances Appliance Gourmet Electric knife
Recreation Crafts Fabric
Appliances Appliance Small Fabric steamer
Recreation Travel Fanny pack
Recreation Camping First Aid kit
Recreation Camping Flashlight(s)
Recreation Camping Flashlight(s)
Recreation Crafts Floral supplies
Other Car Personal Property Fluid, coolant
Recreation Crafts Foam Board
Appliances Appliance Gourmet Fondue set
Appliances Appliance Gourmet Fondue set
Appliances Appliance Gourmet Fondue set
Recreation Camping Food
Recreation Camping Food
Medical Emergency Supplies Food [5 day supply/person]
Appliances Appliance Small Food processor
Appliances Appliance Small Food processor
Appliances Appliance Small Food processor-Mini
Recreation Camping Food storage bags
Medical Emergency Supplies Food, pets
Food Beverages Frozen juices
Other Cleaning Furniture polish, spray
Recreation Travel Games, travel-sized
Other Car Personal Property Gas cans
House Dishes & Table setting Glasses, beer
House Dishes & Table setting Glasses, champagne
House Dishes & Table setting Glasses, champagne
House Dishes & Table setting Glasses, champagne
House Dishes & Table setting Glasses, champagne
House Dishes & Table setting Glasses, cordial
House Dishes & Table setting Glasses, everyday
House Dishes & Table setting Glasses, flutes
House Dishes & Table setting Glasses, highball
House Dishes & Table setting Glasses, Margharita
House Dishes & Table setting Glasses, martini
House Dishes & Table setting Glasses, martini
House Dishes & Table setting Glasses, old fashion
House Dishes & Table setting Glasses, shot glasses
House Dishes & Table setting Glasses, snifter
House Dishes & Table setting Glasses, snifter
House Dishes & Table setting Glasses, wine
House Dishes & Table setting Glasses, wine
House Dishes & Table setting Glasses, wine
House Dishes & Table setting Glassware
Recreation Crafts Glitter
Other Cleaning Gloves
Recreation Crafts Glue
House Dishes & Table setting Goblets
House Dishes & Table setting Goblets
House Dishes & Table setting Goblets
House Electronics GPS
House Electronics GPS
Other Cleaning Granite Cleaner
Other Cleaning Granite Cleaner
House Dishes & Table setting Gravy boat
House Dishes & Table setting Gravy ladle
House Dishes & Table setting Gravy ladle
Food Condiments Gravy master
Recreation Toys Guns
Recreation Camping Hat
Medical Emergency Supplies Heavy-duty aluminum foil
Recreation Camping Hiking Poles
Food Condiments Honey
Food Condiments Horseradish
Recreation Camping Hydration
Recreation Camping Hydration
Recreation Camping Hydration
Recreation Camping Hydration
Recreation Camping Hydration
Recreation Camping Hydration
House Dishes & Table setting Ice Bucket
House Dishes & Table setting Ice Bucket
Recreation Camping Ice chest
Appliances Appliance Gourmet Ice cream maker
Appliances Appliance Gourmet Ice crusher
Appliances Appliance Small Iced Tea maker
Other Cleaning Insect baits
Recreation Camping Insect Repellent
Other Cleaning Insect spray
Food Condiments Jam
Food Condiments Jelly
Appliances Appliance Gourmet Juicer

Food Beverages Juices

Other Car Personal Property Jumper cables
Food Condiments Ketchup
House Electronics Keyboard
House Electronics Keyboard, wireless
Appliances Appliance Gourmet Knife Sharpener
Recreation Camping Knives
House Dishes & Table setting Knives, butter
Food Beverages Kool-aid mixes
Recreation Crafts Lacquers
Recreation Camping Lantern
House Electronics Laser pointer
House Electronics Laser pointer
House Electronics Laser pointer
Food Beverages Lemonade
Recreation Camping Lighter
Recreation Camping Lighting
Recreation Camping Lighting
Recreation Camping Lighting
Recreation Camping Lighting
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor

Food Beverages Liquor

Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Food Beverages Liquor
Recreation Travel Luggage
Recreation Travel Luggage
Recreation Travel Luggage
Recreation Travel Luggage
Recreation Travel Luggage
Recreation Travel Luggage
Recreation Travel Luggage
Recreation Travel Luggage
Recreation Travel Luggage
Recreation Travel Luggage
Recreation Travel Luggage
Recreation Travel Luggage
Recreation Travel Luggage
Recreation Travel Luggage
Recreation Travel Luggage
Recreation Travel Luggage
Recreation Travel Luggage

Recreation Travel Luggage

Recreation Travel Luggage Tags
Recreation Travel Luggage, le Sport Sac
Recreation Travel Luggage, le Sport Sac
Recreation Travel Luggage, le Sport Sac
Food Condiments Maple syrup
Food Condiments Maple syrup
Food Condiments Maple syrup
Appliances Appliance Small Massager
Appliances Appliance Small Massager
Recreation Camping Mat(s)
Recreation Camping Matches
Recreation Camping Matches
Recreation Camping Matches, waterproof tin
Food Condiments Mayonnaise
Appliances Appliance Gourmet Meat grinder
House Collectibles Memorabilia, sports
House Collectibles Memorabilia, sports
House Collectibles Memorabilia, television
Other Cleaning Metal polish
Other Cleaning Metal polish, silver
Other Cleaning Metal polish, silver
Recreation Toys Micro machines
Recreation Travel Mirror
Appliances Appliance Small Mixer, grinder attachment
Appliances Appliance Small Mixer, hand-held
Appliances Appliance Small Mixer, stand
Food Beverages Mixers
Food Beverages Mixers
House Electronics Modem, cable
Food Condiments Molasses
House Electronics Monitor, LCD
Other Cleaning Mop
Recreation Camping Mosquito netting
Recreation Crafts Mounting boards
House Electronics Mouse
House Electronics Mouse pad(s)
House Electronics Mouse, Travel
House Electronics Mouse, wireless
House Dishes & Table setting Mug(s)
House Dishes & Table setting Mug(s), beer
House Dishes & Table setting Mug(s), beer
House Dishes & Table setting Mug(s), coffee
House Dishes & Table setting Mug(s), coffee
House Dishes & Table setting Mug(s), coffee
Food Condiments Mustard
Food Condiments Mustard
Food Condiments Mustard
Recreation Camping Nalgene Bottles
Recreation Camping Nalgene Bottles
House Dishes & Table setting Napkin rings
House Dishes & Table setting Napkins
House Dishes & Table setting Napkins
House Dishes & Table setting Napkins
House Dishes & Table setting Napkins, cloth
Recreation Toys Nerf guns
House Electronics Network antennae
Other Cleaning Oil soap for wood
Food Condiments Oil, canola
Other Car Personal Property Oil, motor
Food Condiments Oil, olive, extra virgin
Food Condiments Oil, olive, extra virgin
Food Condiments Oil, olive, extra virgin
Food Condiments Oil, olive, extra virgin
Food Condiments Oil, other
Food Condiments Oil, sesame
Food Condiments Oil, vegetable
Food Condiments Oil, walnut
Food Condiments Olives
Food Condiments Olives
Other Cleaning Oven cleaner
Other Car Personal Property Paint, touch up
Recreation Crafts Paints
Recreation Crafts Paints
Recreation Crafts Paints
House Dishes & Table setting Pan
Recreation Crafts Paper
Recreation Crafts Paper pads
Appliances Appliance Gourmet Pasta maker
Recreation Crafts Pencils

Recreation Crafts Pens

House Electronics Personal Digital Assistant
House Electronics Personal Digital Assistant
Food Condiments Pickle relish
Food Condiments Pickles, banana peppers
Food Condiments Pickles, dill
Food Condiments Pickles, jalapanas
Food Condiments Pickles, sweet
Recreation Travel Pill container(s)
Recreation Travel Pillow case(s)
Recreation Travel Pillow(s)
Recreation Camping Pillows, Camping
Food Condiments Pimentos, sliced
House Dishes & Table setting Pitcher(s)
House Dishes & Table setting Placemats
House Dishes & Table setting Placemats
House Dishes & Table setting Plates
House Dishes & Table setting Plates
House Dishes & Table setting Plates
House Dishes & Table setting Platter, carving
House Dishes & Table setting Platters
House Dishes & Table setting Platters
House Dishes & Table setting Platters
House Dishes & Table setting Platters
House Dishes & Table setting Platters
House Dishes & Table setting Platters
House Dishes & Table setting Platters
Appliances Appliance Small Portable fan
Appliances Appliance Small Portable heater
Recreation Crafts Poster board
House Electronics Presentation pointer
House Electronics Printer
House Electronics Printer, all-in-one
House Electronics Printer, ink cartridge
House Electronics Printer, ink cartridge, color
House Electronics Printer, laserjet
House Electronics Printer, laserjet
House Electronics Printer, photograph
House Electronics Printer, toner cartridge
Other Business Materials Programs
Other Business Materials Programs
Other Career Development Programs
Other Career Development Programs
Other Career Development Programs
Food Beverages Protein drinks
Recreation Toys Puzzles
Other Business Materials Reference
Other Business Materials Reference
Other Business Materials Reference
Other Business Materials Reference
Other Business Materials Reference
Other Business Materials Reference
Other Business Materials Reference
Other Business Materials Reference
Appliances Appliance Large Refrigerator
Appliances Appliance Large Refrigerator
Appliances Appliance Large Refrigerator, wine
Recreation Crafts Ribbons
Appliances Appliance Gourmet Rice cooker
House Electronics Router
Food Condiments Salad dressing
Food Condiments Salad dressing
House Dishes & Table setting Salad Servers
House Dishes & Table setting Salad Servers

House Dishes & Table setting Salad serving set

Appliances Appliance Gourmet Salad spinner
Food Condiments Salsa
House Dishes & Table setting Salt and pepper shakers
House Dishes & Table setting Salt and pepper shakers
House Dishes & Table setting Salt and pepper shakers
House Dishes & Table setting Salt and pepper shakers
Recreation Crafts Sand art
Food Condiments Sauce, A-1
Food Condiments Sauce, barbecue
Food Condiments Sauce, Cocktail
Food Condiments Sauce, hoisin
Food Condiments Sauce, horseradish
Food Condiments Sauce, hot
Food Condiments Sauce, hot
Food Condiments Sauce, hot
Food Condiments Sauce, Liquid Smoke
Food Condiments Sauce, Mint
Food Condiments Sauce, Potsticker
Food Condiments Sauce, soy
Food Condiments Sauce, Tabasco
Food Condiments Sauce, taco
Food Condiments Sauce, Tartar
Food Condiments Sauce, teriyaki
Food Condiments Sauce, Worcestershire
Recreation Camping Saw, folding
House Electronics Scanner
Recreation Crafts Scrapbook materials
Recreation Crafts Scrapbooks
Recreation Crafts Scrapbooks
Other Cleaning Scratch remover, cover-up
Other Cleaning Scrub brushes
Other Career Development Seminar materials

Other Career Development Seminar materials

Other Career Development Seminar materials
House Dishes & Table setting Server, tea
House Dishes & Table setting Serving bowls, covers
House Dishes & Table setting Serving plates, platters
Recreation Travel Sewing kit, travel
Recreation Travel Shaving kit
Recreation Travel Shoe bags
Other Cleaning Shoe water repellant
Other Cleaning Shoe, boot polish, creams
Recreation Travel Shower cap
House Dishes & Table setting Silverware storage chest
House Dishes & Table setting Silverware, Stainless Steel

House Dishes & Table setting Silverware, Sterling silver

House Dishes & Table setting Silverware, sterling silver
Other Car Personal Property Ski rack
Recreation Camping Sleeping bags
Recreation Camping Sleeping bags
Recreation Travel Small tissue packets
Recreation Toys Snow toy, saucer
Recreation Travel Soap dish
Food Beverages Soft drinks
Food Beverages Soft drinks
Other Cleaning Sponges
House Dishes & Table setting Spoon, grapefruit
House Dishes & Table setting Spoon, large serving
House Dishes & Table setting Spoons, Chinese soup
Other Cleaning Squeegee
Other Cleaning Squeegee
Appliances Appliance Gourmet Sterno fuel
Recreation Camping Stool, trail
Recreation Camping Stuff Sack
Recreation Camping Stuff Sacks
Recreation Camping Stuff Sacks
Recreation Toys Stuffed animals
Recreation Toys Stuffed animals
Other Cleaning Sweeper, "Swifter"
Other Cleaning Sweeper, "Swifter"
Recreation Camping table cloth
House Dishes & Table setting Table cloths
House Dishes & Table setting Table cloths
House Dishes & Table setting Table cloths
House Dishes & Table setting Table pads
House Dishes & Table setting Table runner
House Dishes & Table setting Table runner
House Dishes & Table setting Table runner
Furniture Tables Table, bedside
Furniture Tables Table, bedside
Furniture Tables Table, cocktail
Furniture Tables Table, cocktail
Furniture Tables Table, Dining
Furniture Tables Table, end
Furniture Tables Table, end
Furniture Tables Table, end
Furniture Tables Table, end
Furniture Tables Table, end
Furniture Tables Table, folding
Furniture Tables Table, folding
Furniture Tables Table, kitchen
Furniture Tables Table, sofa
Furniture Tables Tables, nesting
House Dishes & Table setting Tablespoons
House Dishes & Table setting Tea service

Food Beverages Tea(s)

House Dishes & Table setting Teaspoons
House Electronics Telephone cord
House Electronics Telephone(s)
House Electronics Telephone(s)
House Electronics Telephone(s)
House Electronics Telephone(s)
House Electronics Telephone(s)
House Electronics Telephone(s)

House Electronics Telephone(s)

House Electronics Telephone(s)

House Electronics Telephone(s)
House Electronics Telephone(s)
Recreation Camping Tent
Recreation Camping Tent
Recreation Camping Tent
Recreation Camping Tent
Recreation Camping Tent, floorsavers
Other Car Personal Property Tire chains
Other Car Personal Property Tire gauge
Appliances Appliance Small Toaster
Other Cleaning Toilet bowl brush
Recreation Camping Toilet paper
Other Cleaning Toilet plunger
Recreation Travel Toiletries, travel-sized
Recreation Travel Toiletry Case
Recreation Travel Toiletry Case
Food Condiments Tomatoes, sun dried
Recreation Camping Topo Maps
Other Car Personal Property Torque Wrench
Recreation Travel Totes
Recreation Travel Towelettes
Recreation Camping Towels
Recreation Toys Toys, Legos
Recreation Toys Toys, trucks
Recreation Toys Train set
Appliances Appliance Large Trash compactor bags
Recreation Travel Travel clock
House Dishes & Table setting Tray
House Dishes & Table setting Tray
House Dishes & Table setting Tray, relish
House Dishes & Table setting Trivets
Other Car Personal Property Trouble Light
Recreation Camping Trowel
Other Car Personal Property Trunk organizer
Other Cleaning TSP Tri-sodium phosphate
Recreation Travel Umbrella, folding
Recreation Travel Umbrellas
House Electronics USB extender
Recreation Camping Utensils, unbreakable
Other Cleaning Vacuum cleaner
Other Cleaning Vacuum cleaner
Other Cleaning Vacuum cleaner attachments
Other Cleaning Vacuum cleaner bags
Appliances Appliance Small Vibrator
Appliances Appliance Small Vibrator
Food Condiments Vinegar, apple cider
Food Condiments Vinegar, balsamic
Food Condiments Vinegar, balsamic
Food Condiments Vinegar, balsamic
Food Condiments Vinegar, balsamic
Food Condiments Vinegar, champagne
Food Condiments Vinegar, other
Food Condiments Vinegar, red wine
Food Condiments Vinegar, white
Food Condiments Vinegar, white wine
Recreation Travel Visor, sun
Appliances Appliance Small Waffle iron
Recreation Toys Wagon
Recreation Camping Waist Pack
Recreation Camping Waist Pack
Medical Emergency Supplies Walkie-talkies
Appliances Appliance Small Warming buffet
Appliances Appliance Small Warming tray, electric
Appliances Appliance Large Washer
Food Beverages Water
Food Beverages Water
Food Beverages Water
Recreation Camping Water Purifier
Recreation Camping Water Purifier
Medical Emergency Supplies Water, bottled [1 gal/person/day]
Recreation Camping Web Strapping
Other Car Personal Property Whisk broom
Recreation Camping Whistles
Other Cleaning White toothpaste
Other Cleaning Window cleaner
Other Car Personal Property Windshield scraper
House Dishes & Table setting Wine coaster
House Dishes & Table setting Wine coaster
Recreation Travel Wine opener
Food Beverages Wine(s) [LIST]
Appliances Appliance Small Wok, electric
Recreation Crafts Yarn
Appliances Appliance Gourmet Yogurt maker
House Electronics Zip discs
House Electronics Zip Drive
 Module 03-06: Exercise 2
on, find the number of unique sub-categories in the list.

DESCRIPTION Unique Count

MTC trade show #NAME? 1
International set #NAME?
Febreze #NAME?
Plugins #NAME?
Queen #NAME?
#NAME?
Pinesol #NAME?
409 #NAME?
Suunto #NAME?
Casio #NAME?
#NAME?
Copies. Ave 4 pgs ea #NAME?
beaded pieces #NAME?
Sandler Managers Set #NAME?
Sandler Pro Summit Complete Sets #NAME?
Sandler Selling System #NAME?
Covey--Let's Get Real Set #NAME?
Sandler Close the Deal #NAME?
RAC Managerial set--4 volumes #NAME?
Time Mangement Program
Objective Management System
Positive Changes Program
Sandler No Guts - No Gain
Sandler Corporate Selling
Sandler Quarterly Schools taped sessions
Vocab Improvement--Verbal Advantage

Sandler President's Club Materials incl book

Sandler Quick start Book and tapes
Elementary School Visual Perception set
Gerber
School
Jansport
Kelty
Denby Regency Green med
small stuffed
Valuable Individual
Unopened packages--400 packs. Box of12
packs
Individual cards
Tiles
4 cases--Miller Lite; Heineken;
Luggage
2 bike hitch mount rack
4 bike hitch mount rack
Green Fleece & Red Fleece
Wool Indian
Space
Pair
Oster
Cuisinart
MTC student books
wooden
outdoor products
Ultimate Direction
Primus & Coleman

4 cases--Arrowhead
gallons
Nalgene Travel Bottle Kit
cut Glass and crystal: thick sides with
ripples
Crystal fern
bone china turine with cover
glass bowl set for cooking
Herend Q Victoria soup turine
pyrex with covers, various sizes
ceramic, various

wicker & metal

copper
Stainless--All Clad
set
Chinese rice, blue.
Denby Regency Green
Extra large wooden
misc. some with metal stands and covers
Denby Regency Green med
White
Denby Regency Green
Genuine Mazda 3 Full-Front
Cuisinart
SOS

and dust pan

pkg of 9
6 gallon

glass
Denby Regency
USB 16'
CAT5e 25'
Lens paper, hoods, vv filters, lens cleaners,
[Link], etc.
35 mm
Sigma wide angle 28-70mm
Sigma telephoto 70-210mm
Canon SLR normal 50mm
Canon 28-135 telephoto lens
Lowe bags for digital
Lowe bag for SLR cameras
Nikon Coolpix 885
Powershot 5500
Olympus SP-700
Canon XSI 12 mp body only
Kodak fun saver
EF
Canon EOS SLR Body
Pentax
Canon HD Digital Camcorder
Tamrac bag

Cuisinart
apple; pinneapple
Craftsman Diehard
Natural

DC to AC

for Lexus, set of 4

Half-Gallon

AIWA CD changer
JBL speakers

Meguiar liquid
business card scanner

Corning ware set with covers

64oz
PC synch cord
2 tone metal

Crazy Creek
Silver-set of 4
wooden
Mini chopper--Krups
8oz
Adapter 1x3
Armor-All Upholstery, Tire
Bar Keepers
Raingear-Northface (pants and jacket)
Mosquito suit--Pants & Shirt Buzzoff
Hiking pants with buzzoff
Fleece zip jacket--Patagonia
Packframe poncho
Poncho
Hiking Hat--Columbia
Gaiters
Fleece gloves
Convertible pants
Hiking Socks
Hiking Sock Liners
Hiking Shirts
Buss off shirts
decaf beans
Reg drip
Cuisinart, Burr Mill
Cuisinart
Mr. Coffee
Krups
New State Quarters
Proof sets 1960-2009 1 each
Penny, nickel, dime, quarter sets
Santo
Silva
Granite Gear
Spare laptop battery for IBM laptops
USB headset with microphone
MS Office Std
PowerPoint
Adobe Acrobat Pro
Adobe Pagemaker
Adobe Acrobat Std
Photoshop Elements
Paperport
Quicken
Prophet
Norton Antivirus
Acronis Back up
Palm applications
MS Office Professional
Entellium Rave
Will maker
Quickbooks
HP
Toshiba Qosmio
IBM T41
Docking Station--Think pad advanced
spare AC power cord
Bose with subwoofer

large
small

spray bottles
toothbrush, soap
High Altitude Primus
Coleman 3 burner
Red--16oz
White--16oz
Sherry--16oz
Marsala--16oz
MSR Flex 4 cookset

with foam pad

plastic
Denby Regency Green
White
Rival--6 qt
Rival-4.5 qt
with rack
Thermal
set of 2
package
Chinese
Jansport
Glass
crystal, yeoward
crystal
goo gone, degrease it
AAA set
Camp suds 16 oz
Camp suds, 2 oz
Ceramic
Lenox Interlude China
Denby Regency green 4 pc place set
Corelle service for 12 plus serving bowls
Pfaltzgraff Yorktowne

Chinese dipping sauce

Misc
Drano, liquid plumber
Included in Staples shopping cart
External Simpletech 500gb
Included in Staples shopping cart
Gas--top of line
REI Cargo Adventure

large aluminum

Hi reach kit
Customer Mktg DVD's--Psom
Scanned course evals
George Foreman
Hamilton Beach
various--felt

Jansport
Backpackers
Headlamps-Petzel
pen flashlights--Maglite
wire, foam, rocks, etc.
Peak & Zerex

Electric-Cuisinart
Electric-Rival
Set with rotating sauce cups
Freeze dried entrees
Bear Canisters

Vitamix
Cuisinart--14 cup
Cuisinart
Ziplocks
dog food
grape, berry cans
pledge, endust

a-5 gal; 1-2 gal

pilsner, waterford
Waterford Wishes
Riedel Crystal
Bride and groom set, crystal
saucer champagne, Wm Yeoward, crystal
crystal
set of 36
Cairo Champagne
crystal
set of 8
crystal, set of 2
hand painted
crystal
crystal
small
crystal, large, set of 2
Riedel Bordeaux
XL cabernet
Chardonney
Pean Doubulyu glasses, pitcher, bowls
various

craft, hobby
Crystal, wm yeoward
glass, water, green
glass, water, burgundy
Garmin NUVI wall and car chargers
Exercise Garmin
Stone care kit
Gel spray
stainless
stainless with design
stainless

Davy Crocket Rifle

insect repellent

Leki
Sue Bee 24oz
Creamy, Plain
Camelback Mule 100 oz
Camelback UnBottle
Camelback Cleaning Kit
Camelback Alpine Explorer
Camelback Classic
Camelback spare parts kit
Crystal
metal with top
Cuisinart
Waring Pro.
Mr Coffee
ants
Jungle Juice
Raid
Smuckers
grape, mint
Breville

organic grapefruit; cherry; cider,cranberry

Craftsman deluxe
Heinz

Electric-Wusthof
Swiss Army Knives
stainless

Coleman 2 mantle
Brass, 5 lights
Slim line
Black
crystal light--box
Helios storm proof
Coleman Distribution Tree
Coleman 8' hose extension
Spare Mantles
Dry Bag Canoeing 20 liter
Baileys
Campari
Chambord
Cointreau
Courvoisier XO
Crème de Cacao
Crème de Menthe
Disaronno Amaretto
Frangelico
Gin--Tanqueray
Grand Marnier
Grand Marnier Cinquantenaire
Harvey's Bristol Cream
Hennessey XO
Jack Daniels
Jim Bean
Kahlua
Kirsch
Lemoncello
Macallan 12 single Malt
Peppermint Schnapps
Remy Martin XO
Rum-Bacardi Dark
Rum-Bacardi Light
Rye Wiskey-Canadian Club
Sake, Murai
Sake, Kaika Tobindori Shizuki
Sake, Narutotai
Scotch-Johnnie Walker Black
Scotch-Johnnie Walker Blue Label King
George V
Scotch-Johnnie Walker Blue--750ml
Seagrams 7 Crown
Southern Comfort
Tequila-Don Julio 1942 Anejo--750ml
Tequila-Gran Patron Platinum--1.75 L
Tequila-Jose Cuervo 1849
Tequila-Jose Cuervo Gold
Tequila-Patron Silver 1.75 L
Triple Sec
Vermouth-Dry
Vermouth-Sweet
Vodka-Absolut
Vodka-Absolut Mandarin
Vodka-Absolut Peppar
Vodka-Absolut Rasberry
Vodka-Absolut Vanilla
Vodka-Grey Goose
Wild Turkey
Wild Turkey Bourbon
Ski bag for clothes and boots
Travel bag for skis
Ski boot bag
Snow board bag
Lark luggage 30"bag
Lark luggage overngt bag
Lark luggage garment
Atlantic large bags
Boyt carryons
Samsonite garment bag
Swiss army roller 26"
Hanging garment bag
Green duffle carryon
Blue canvas/leather with pockets
Computer wheelie bags
Black small carryon (duffle)
Lg Black nylon/poly purse/carryon

black overnight bag with zip off toiletry case

Nylon, large
Nylon, med
Nylon, small
Grade B lg--trader joes
Aunt Jemima lite
Sugar free
Electric
Rhythm Touch Therapy Massager
Therm-a-rest
Stormproof
Plastic match box

Hellmans 22oz Ezout

Kitchen Aid attachment to mixer
Reggie Jackson autographed baseball
Nolan Ryan autographed baseball
Bill Cosby autographed wine bottle

cleanser
cleaning plate
Fold up garage with 50 micro machines

Kitchen Aid
Cuisinart
Kitchen Aid
Mr. and Mrs. T
soda water; ginger ale; tonic--6 packs

Grandma's 20oz
Samsung 22" wide screen

Spin rim for head

poster size

large blue ceramic

set of 4
crystal
large green
large green and purple
rabbit
French's Lg 20oz
Dijon--Grey Poupon
Fancy--Hot, Sweet, Honey, Garlic
32 oz
16oz
varioua
Taylor Ivory set of 4
Reticella lace-each
cloth
lace
with foam darts
High gain
Murphy's
48oz
Quarts
17oz
Organic infused
Lucini --lg bottle
Napa Style olive oil set of 3
Flaxseed--Henry's
5oz
Wesson--1/2 Gallon
8.45oz
Black-large canned-5.75oz
Green--10oz
Easy off
for 4 vehicles
sets
enamel .5 oz
spray
Broiler
Construction
drawing

Colored--box
Colored markers, glitter, various tips, sets of
8
Palm lifedrive
Palm lifedrive applications
sweet, dill
lg jar
large jar--baby dills--20oz
12 oz
24 oz
plastic
for travel
neck, travel
Compressible
2 oz
crystal martini with stirrer
cloth
vinyl
Waterford 3 section
Waterford cake plate
ceramic purple/green
Wood-Carving board with gripping ring
Crystal etched platter
Asparagus ceramic
Herend Q. Victoria
Denby Regency Green
Wedgwood turkey
Wedgwood oval
Nambe metal platter
tower

3 pk
Targus with Laser pointer
HP Mobile H470b
HP Officejet Pro 8500 all in one
Black, Attachment 149
Included in Staples shopping cart
Hp Laserjet p1006
HP Laserjet P4014dn
Epson Photo SP 1400
For laser printers
Sales Success Seminars
Clemson Marketing
Sandler manuals
Nelson Negotiation
Condry Management
Muscle milk, EAS--24 pk

MTC training manual

DISC/ marketing materials
MTC Role Play manual
Transcribed course--20 hours
Morgan Training LLC Book--leather
Copies of course evals
Trade Show business cards
Client and Prospect Information
GE Profile 25 cu ft
GE 21.7 cu ft
Haier wine cooler
various
Cuisinart 8 cup
Netgear cable gateway
Various flavors--16oz
24oz--ranch, thousand island
Sterling Silver
Stainless
wood--Xtra lg bowl, lg bowl, 16 small bowls,
fork, spoon

Various types--16oz
mini sets of 2, Gorham--8 pkg
Glass and metal
Asparagus set; walnut set
various
completed bottles
lg bottle
40 oz
12 oz
8oz
12 oz
Sriracha
El Tapatio--10oz
Mongolian fire oil--10oz
5 oz
5 oz
Ling ling--lg bottle
Reg, lite--20oz
green, red--12 oz
12oz
11.5 oz
20 oz
15 oz

Epson Perfection V700 flatbed

paper, stickers, mats, etc.

extra pages

Miller Heiman Strategic Selling Program

Miller Heiman Conceptual Selling Program

Appointment Getter
wooden
Oneida Dover Stainless-Lifetime warranty
Sterling Silver service for 12 plus serving
pieces
cake server--Gorham
Thule Universal flat top
REI--3 season
Marmot 0 degree
pkg of 12

diet pepsi; coke; 7-up; diet coke 12 packs

hansens, rootbeer, orange--6 packs
Scotch Brite assorted
stainless
stainless, misc

16"
window washer
Case of 24 with external wick

Sleeping Bag
Sm, Med, Lg
Mesh
Reunite Penguin--3' high
Beanie Babies--30 per boy

refills
vinyl with cloth back
Taylor 70x108
Taylor 70x126
Reticella lace 72x144

Tapestry material
Lace
Satin
cylindrical --wood
night stands--wood
metal and glass
Wood and glass
Wood, Double pedestal
Hexagonal, wood
Bronze finished metal
Strand chairside--wood
Olive ash chairside--wood
Essex leather wrap wood
(1) 8 ft. (2) 6 ft.
folds in half
Metal with thick beveled glass top
wood, sofa table
wood

Reg and decaf--green, constant comment;

english; red; peach; chamomille,lemon,
smooth move, licorice, etc.

25'
Panasonic 2-line corded with answering
Panasonic cordless handsets
Panasonic cordless with answering
Uniden wireless
Wall mount
2-line corded

Plantronics cordless phone headset--CT12

Plantronics cordless phone headset--CT10

Sony single line
15'
Eureka 3 man
REI Halfdome
Mountain Hardware
Sierra 6-person

SCC for SUVs

1 Pencil gauge; 2 digital
Cuisinart

shampoo, deodorant, etc.

Dopp kits
Woman's hanging
Bottle--8.5 oz
Various Areas
Craftsman 1/2" Ratcheting
canvas, beach

Backpack, fast dry

Assorted Items--32 sets
Hess truck
Brio train pieces
Oregon Scientific
Large plastic
metal filagree
glass

Coleman

Knife, fork, spoon sets

Hoover upright
Eureka canister
for central vac

Rabbit
various
Qt--reg
Lg bottle
Avanti 3 bottle set
Campari 15 yr aged
Fancy bottles infused with herbs

organic apple-16oz
lg bottle-Regina
half gallon
16 oz

Calphalon
Radio Flyer
Northface
REI Double Shot
Motorola
Bella Cucina
Salton --Crate and Barrel
Top Loading top of line
Pellegrino
Perrier
Vitamin, Gatorade - case
Katadyne Hiker Pro
Replacement Cartridge

24"-60"
oxy clean
windex

Crystal
metal, glass

See attached list

Breville
various
Euro Cuisine
4/pack
Iomega