LAST Excel Intermediate

Microsoft Office Excel 2007

 

Independent Challenge 1 Appliances Steps a-i all steps need to be done

Independent Challenge 2 Portfolio Sales Steps a-m all steps need to be done

Independent Challenge 3 Travel Employees Steps a-h all steps need to be done

 

I AM FAILING THIS COURSE NEED 100 ON ALL 3 CHALLENGES

 

NOTES PROVIDED

 

DUE BY FRIDAY, NOV. 1, 2013 AT 12 NOON

 

DO NOT ASK WHEN DUE; PLEASE READ ALL NOTES

 

Appliance Depot

/

0

0

Burton

Install

2/2/10

No

2/2/10 Burton

1 Yes

Burton

Install

Yes

2/1/10 Burton

Repair 6 Yes

Install 7 Yes

Reilly

Estimate 1 No

2/2/10 Juarez

Repair 4 No

2/3/10 Reilly

Estimate 1 No

2/5/10 Juarez

Repair 7 Yes

2/1/10 Juarez

Install 9 Yes

Burton

Repair 7 Yes

2/2/10 Reilly

Repair 7 No

2/2/10 Juarez

Install 7 No

2/5/10 Juarez

Install 6 No

2/2/10 Reilly

Install 3 Yes

2/2/10 Juarez

Estimate 1 Yes

2/6/10 Reilly

Install 4 Yes

2/5/10 Burton

Install

Yes

2/6/10 Reilly

Install 9 No

2/1/10 Reilly

Install 10 No

2/2/10 Reilly

Install 4 No

2/6/10 Juarez

Install 8 Yes

2/3/10 Burton

Repair 6 No

Date	Technician	Job #	Category	Hours	Warranty
2/	3				1								Burton		10														Install				6													Yes
								2/2/10	103		8												No
								Reilly	10		9							Repair				4
116				Estimate
			2/1/10	122						7
134
		2/3/10								Juarez	153
			2/5/10	161
164
165
166
167
			2/6/10	173
175
177
181
185
187
188
190	14
192
194
195
197
198

Sheet2

Sheet3

Sale

s

Sale

April Online

April Online

April

Paint

April Phone Paper

April Phone Brushes

April

Paint

April Store Paper

April Store Brushes

Online Paint

May Online Paper

May Online Brushes

May Phone Paint

May Phone Paper

May Phone Brushes

May Store Paint

May Store Paper

May Store Brushes

Online Paint

June Online Paper

June Online Brushes

June Phone Paint

June Phone Paper

June Phone Brushes

June Store Paint

June Store Paper

June Store Brushes $ 4,845

Month	Type	Category
								April									Online									Paint	$ 43,225
								Paper	$ 18,444
								Brushes	$ 5,645
								Phone	$ 45,444
$ 27,554
$ 5,377
								Store	$ 42,221
$ 18,009
$ 11,899
								May	$ 489,557
$ 27,452
$ 3,133
$ 2,445
$ 11,550
$ 8,511
$ 30,458
$ 15,222
$ 5,556
								June	$ 45,454
$ 25,444
$ 15,452
$ 48,442
$ 20,776
	$ 4,845
$ 49,554
$ 25,664

Sheet2

Sheet3

Employees

Sales Representative Boston U.S.

Sales Representative Boston U.S. Full-time

Sales Representative Boston U.S. Full-time

Boston U.S. Part-time

Sales Manager

U.S. Full-time

Sales Manager New York U.S. Full-time

Sales Representative New York U.S. Part-time

Sales Representative New York U.S. Part-time

Sales Representative New York U.S. Full-time

Sales Representative New York U.S. Full-time

Sales Representative New York U.S. Full-time

Sales Representative New York U.S. Full-time

Sales Representative New York U.S. Full-time

Sales Manager

U.S. Part-time

Sales Manager Minneapolis U.S. Full-time

Sales Representative Minneapolis U.S. Part-time

Sales Representative Minneapolis U.S. Full-time

Sales Manager

U.S. Full-time

Sales Representative Chicago U.S. Full-time

Sales Representative Chicago U.S. Part-time

Sales Manager Chicago U.S. Full-time

Sales Representative

Part-time

York

Sales Manager Vancouver Canada Full-time

Sales Representative Vancouver Canada Full-time

Sales Representative Vancouver Canada Full-time

s

Sales Manager

Canada Full-time

Martin Sales Representative Montreal Canada Part-time

Sales Representative Montreal Canada Full-time

Sales Representative Montreal Canada Full-time

Sales Representative Montreal Canada Full-time

Sales Manager

Canada Part-time

Sales Manager Toronto Canada Full-time

Paul Sales Representative Toronto Canada Part-time

Sales Manager Toronto Canada Full-time

Sales Representative Toronto Canada Full-time

Sales Representative Toronto Canada Full-time

Sales Representative

U.S. Part-time

Sales Representative Los Angeles U.S. Full-time

Sales Representative Los Angeles U.S. Full-time

Sales Representative Los Angeles U.S. Full-time

Sales Representative Los Angeles U.S. Full-time

Sue Sales Manager Los Angeles U.S. Full-time

John Sales Representative

co

U.S. Part-time

Sales Representative

U.S. Full-time

Edward Sales Manager San Francisco U.S. Part-time

Sales Representative San Francisco U.S. Full-time

Sales Representative San Francisco U.S. Full-time

Joe Sales Manager San Francisco U.S. Full-time

Francis Sales Representative San Francisco U.S. Full-time

Sales Representative San Francisco U.S. Full-time

Sales Manager San Francisco U.S. Full-time

Sales Representative San Francisco U.S. Part-time

Last Name

First Name

Title

City

Region

Status

Walsh

George

Sales Representative

Boston

U.S.

Full-time

Stinson

Greg

Part-time

Spinale

Eva

Hart

Jeanne

Ng

Joyce

Sales Manager

Juarez

Jose

New

York

Merk

Joe

Lincoln

Michael

Martin

Daniel

Levine

Andy

Lenni

Paul

Curtis

Betty

Hanley

Elaine

Weir

Troy

Clay

Duane

Minneapolis

Bates

Julie

Riley

Pat

Lavoie

John

McCormick

Sue

Chicago

Bayard

Grace

Zelan

Michelle

Gorahm

Fred

Casey

Jack

Vancouver

Canada

Eddie

Hassan

Denise

Hatem

Robert

Edward

Jen

Montreal

James

Kerman

Tim

Rich

Jan

Forsythe

Pete

Manno

Dorothy

Toronto

Neil

Luciana

Sable

Wilbur

Diane

Leary

Jeff

Jerreck

Wiley

Bailey

Holly

Los Angeles

Otis

Valencia

Healey

Lily

Norris

Peter

Yanchez

Harry

Walker

Murray

San

Francis

Prout

Kevin

San Francisco

Hansen

Flatley

Marge

Kelley

Larry

Collins

Carter

Ingram

Kathy

Harris

William

Hawthorne

Nathan

Sheet2

Sheet3