Aufgaben Excel Workshop (1)

  • Upload
    noel

  • View
    215

  • Download
    0

Embed Size (px)

Citation preview

  • 8/17/2019 Aufgaben Excel Workshop (1)

    1/338

    Tasks:1. Create a formula to work out the wealth per year for each person. To do2. Use the Sum and the Average ormula to get the results below

    The 10 Richest People in the World 2007

    Rank Name Age Wealth ($bil)1 !illiam "ates ### $1 $%2 !arren &u'ett (% $2) Carlos Slim *elu %( +,+ #ngvar -amprad family /0 ))$ akshmi ittal $% )2% Sheldon Adelson () 2%.$( &ernard Arnault $/ 2%/ Amancio 3rtega (1 2+, i -a4shing (/ 2)

    10 5avid Thomson family +, 22

    Total Wealtch p.a. Average

  • 8/17/2019 Aufgaben Excel Workshop (1)

    2/338

    his you must divide wealth by age and then copy the formula down.

    Wealth per year

  • 8/17/2019 Aufgaben Excel Workshop (1)

    3/338

    Tasks6Use formulas to calculate the four statistics at the bottom of the list.Use SU 7 A89:A"9 ; :ound7 Aason Allen Ale?ander >anuary 200+

    isa arie @resley =icholas Cage August 2002 >ennifer ope Cris >udd 3ctober 2001Courtney Thorne4Smith Andrew Conrad >une 2000Carmen 9lectra 5ennis :odman =ovember 1,,/5onna @eele Charlie Sheen September 1,,$5rew &arrymore >eremy Thomas arch 1,,+Shannen 5oherty Ashley *amilton September 1,,)Cher "reg Allman >uly 1,($

    ichelle @hillips 5ennis *opper 3ctober 1,(09thel erman 9rnest &orgnine >une 1,%+9li abeth Taylor =icky *ilton ay 1,$0

    >ean Acker :udolph 8alentino =ovember 1,1,

  • 8/17/2019 Aufgaben Excel Workshop (1)

    4/338

    Split ays together >anuary 200+ 0.2=ovember 2002 10(

    >uly 2002 2() >anuary 2001 21+

    arch 1,,, 1$0ebruary 1,,% 1+%

    April 1,,+ )0ebruary 1,,+ 1$)

    >uly 1,($ ,=ovember 1,(0 /

    >uly 1,%+ )2 >anuary 1,$1 2+$=ovember 1,1, 0.2$

    TotalA!erage

    "ongestShortest

  • 8/17/2019 Aufgaben Excel Workshop (1)

    5/338

    Tasks61. Use the eft and ind functions to get the ast =ame .2. Use the :#"*T7 9= and #=5 functions to geht the irst =ame.). Use the C3=CAT9=AT9 function create the gmail address.

    # ll Name "ast Name #irst Name5ia Cameron 5ia Cameron-night ichaelSheen Charlie*ayek Salma-utcher Aston:odrigue ichelle&lack >ack

    iley CyrusCraig 5aniel

    o? egan:yan :eynolds

    >ohansson ScarlettatthBus othar

  • 8/17/2019 Aufgaben Excel Workshop (1)

    6/338

    %&mail("astName'#irstName gmail *om)Cameron 5ia Dgmail.com

    mailto:[email protected]:[email protected]

  • 8/17/2019 Aufgaben Excel Workshop (1)

    7/338

    Tasks: Try to solve the following Euestions using the Countifs function6

    Fuestion 16 *ow many clients are married with one childFuestion 26 *ow many clients are single or divorcedFuestion )6 *ow many clients are married with an income above ($7000Fuestion +6 *ow many clients are male7 unmarried and without children

    Fuestion $6 *ow many clients are women with 1 or 2 children.Fuestion %6 *ow many clients are married or in relationship7 with an income greater

    Clients List Name #irstname Genre +n*ome Stat s ,hildren&uilder &ob an 20000 :elationship 0Chance Steve an /0000 arried 1onas ee an )$000 :elationship 0

    Sturrigde ichael an ((000 Single 0Satake -iyoshi an (0000 arried )eon ernando an 2)000 Single )

    Stewart -imberly !oman ,(000 :elationship 1Cole =orris an 2%000 5ivorced )"audefroy arie4Claire !oman /,000 :elationship 0Smith Audrey !oman ((000 Single 2Cavani Alessandro an )+000 5ivorced 0Sharma Sandeep an %1000 :elationship 2-urikova =atalya !oman 2(000 Single 0

    undstroem #ngrid !oman (2000 5ivorced )*anderson !illiam an /$000 :elationship 1"oswami @riya !oman /+000 Single )

    Tanton >ean4 uc an $0000 Single 2 >ones 5avid an )1000 Single 0 >imene >orge an $2000 arried 0&lochin 3leg an %(000 Single )Castro -arlita !oman +)000 :elationship 2

  • 8/17/2019 Aufgaben Excel Workshop (1)

    8/338

    than or eEual to $07000 and have at least two children

    Sol"tions- estion . - estion / - estion 0 - estion 1 - estion 2

  • 8/17/2019 Aufgaben Excel Workshop (1)

    9/338

    Tasks: Try to solve the following Euestions using the Countif7 Sumif7 Countifs and Su

    Fuestion 16 *ow many orders were made by persons called SmithFuestion 26 *ow many orders were made from persons called itron andFuestion )6 *ow many orders were made from persons called Smiths froFuestion +6 !hat was the total amount of orders made by persons calledFuestion $6 !hat was the total amount of C54:om orders made by persoFuestion %6 !hat was the total amount of orders made by persons called

    ate Name State 3rod *t - antity 4nit 3ri*e1H$H200( itron Te?as C54:om %+ I 0.2$1H/H200( Smith assachusets C54:om 1$2 I 0.2$

    1H10H200( "arcia Alabama Smart Card 2/2 I 2$.)01H11H200( Gokuchi California 5854:om 2,2 I 0.$$1H11H200( "arcia California 5854:om ))% I 0.$$1H11H200( "arcia California 5854:om )0+ I 0.$$1H11H200( Charlton California -eyboard ))1 I (.$01H11H200( Gokuchi lorida C54:om )/$ I 0.2$1H11H200( Gang Te?as US& 5rive 2/$ I 12.+$1H11H200( Gang assachusets *ard drive 1%+ I ($.001H11H200( Charlton Te?as 5854:om )++ I 0.$$1H11H200( Gang lorida C54:om $) I 0.2$1H12H200( Smith ichigan C54:om 2/) I 0.2$1H12H200( Charlton 3hio 5854:om )1) I 0.$$1H1$H200( >ulian Te?as 5854:om ),( I 0.$$1H1%H200( Charlton 5akota US& 5rive +// I 12.+$1H1%H200( Charlton California Smart Card 1/1 I 2$.)01H1%H200( Charlton California US& 5rive +%0 I 12.+$1H1(H200( Gang 5akota *ard drive ,0 I ($.001H1(H200( &rown ichigan @rinter 2%0 I $+.001H1(H200( &oulard California 5854:om 2/% I 0.$$1H1(H200( itron Te?as 5854:om 2$+ I 0.$$1H1(H200( "arcia ichigan @rinter ),/ I $+.001H1(H200( &oulard Te?as Smart Card 1/$ I 2$.)01H1(H200( &oulard assachusets *ard drive 1$ I ($.001H1(H200( >ulian Te?as @rinter 22/ I $+.001H1(H200( itron California Smart Card 2/+ I 2$.)01H1/H200( Gang Te?as *ard drive +(2 I ($.001H1/H200( Charlton ichigan -eyboard $) I (.$01H1/H200( Gokuchi assachusets Smart Card )(2 I 2$.)01H1/H200( &oulard 3hio -eyboard +,0 I (.$01H1/H200( Smith Te?as C54:om 1000 I 0.2$1H1/H200( "arcia California @rinter $00 I $+.001H1,H200( >ulian Te?as @rinter )(+ I $+.001H1,H200( &oulard 3hio -eyboard 2/$ I (.$01H1,H200( Gang 5akota @rinter )(% I $+.001H22H200( Gang lorida C54:om 2$ I 0.2$1H22H200( "arcia California @rinter +(1 I $+.00

  • 8/17/2019 Aufgaben Excel Workshop (1)

    10/338

    1H22H200( itron Te?as @rinter )%% I $+.001H22H200( itron assachusets Smart Card )%$ I 2$.)01H2)H200( &oulard Te?as C54:om 2,, I 0.2$1H2)H200( Gang Alabama US& 5rive ))% I 12.+$1H2+H200( Gang assachusets 5854:om 11(0 I 0.$$1H2+H200( Gang assachusets 5854:om +(2 I 0.$$1H2+H200( Smith 5akota @rinter +), I $+.001H2+H200( &rown California C54:om ++2 I 0.2$1H2+H200( "arcia =evada *ard drive +++ I ($.001H2+H200( Smith Te?as C54:om +2( I 0.2$1H2+H200( itron =evada 5854:om () I 0.$$1H2+H200( Gang =evada Smart Card )22 I 2$.)01H2+H200( Gokuchi ichigan @rinter )%% I $+.001H2+H200( &rown =evada US& 5rive 2/1 I 12.+$1H2$H200( Gang assachusets Smart Card 2(2 I 2$.)01H2$H200( itron California Smart Card )00 I 2$.)01H2$H200( Gang California -eyboard 1/$ I (.$01H2$H200( >ulian Te?as @rinter )// I $+.001H2$H200( itron 3hio @rinter 12$ I $+.001H2$H200( Gokuchi 5akota *ard drive 2,% I ($.001H2$H200( &oulard Te?as Smart Card 2$0 I 2$.)01H2$H200( Gang assachusets *ard drive 20$ I ($.001H2%H200( >ulian =evada 5854:om ),/ I 0.$$1H2,H200( Charlton lorida C54:om )++ I 0.2$1H2,H200( Gang Te?as @rinter 2,, I $+.001H2,H200( Smith =evada C54:om 20( I 0.2$1H)0H200( Smith Te?as @rinter )+% I $+.001H)0H200( &oulard California C54:om +(2 I 0.2$1H)0H200( Gang Te?as Smart Card +0( I 2$.)01H)0H200( Gang California Smart Card %, I 2$.)01H)1H200( Gang California @rinter /0 I $+.001H)1H200( &oulard assachusets *ard drive +) I ($.001H)1H200( &oulard Te?as C54:om 1,+ I 0.2$1H)1H200( Smith assachusets 5854:om %/ I 0.$$

    2H1H200( Gang assachusets *ard drive 2/+ I ($.002H1H200( &rown California @rinter 2$$ I $+.002H1H200( &oulard California US& 5rive $2 I 12.+$2H1H200( &rown California Smart Card +/% I 2$.)02H2H200( Charlton =evada 5854:om +2+ I 0.$$2H2H200( Charlton California Smart Card )%1 I 2$.)02H$H200( >ulian 3hio -eyboard +(+ I (.$02H$H200( itron Alabama US& 5rive 2)( I 12.+$2H$H200( Charlton Te?as C54:om )+2 I 0.2$2H$H200( itron assachusets *ard drive )21 I ($.002H$H200( Charlton Te?as 5854:om 1$2 I 0.$$2H%H200( Gokuchi California US& 5rive 2%$ I 12.+$2H%H200( Gokuchi California *ard drive 1/0 I ($.002H%H200( Charlton Te?as US& 5rive +%) I 12.+$

  • 8/17/2019 Aufgaben Excel Workshop (1)

    11/338

    2H%H200( Charlton assachusets @rinter (( I $+.002H%H200( Gokuchi assachusets 5854:om )(2 I 0.$$2H(H200( &oulard lorida Smart Card )01 I 2$.)02H(H200( &rown Te?as @rinter )$0 I $+.002H(H200( &oulard Te?as 5854:om 2( I 0.$$2H(H200( "arcia California 5854:om )0, I 0.$$2H(H200( Smith California US& 5rive 1,% I 12.+$2H(H200( &oulard lorida C54:om +%) I 0.2$2H(H200( itron assachusets C54:om 21% I 0.2$2H(H200( >ulian Alabama -eyboard )2$ I (.$02H(H200( Charlton Te?as -eyboard +( I (.$02H(H200( "arcia Alabama -eyboard )() I (.$02H/H200( &oulard ichigan *ard drive 200 I ($.002H/H200( Gang Te?as US& 5rive )(+ I 12.+$2H/H200( Smith assachusets C54:om ))+ I 0.2$2H/H200( &rown assachusets 5854:om 122 I 0.$$2H,H200( &rown =evada -eyboard 2)) I (.$02H,H200( "arcia assachusets -eyboard 2+) I (.$02H,H200( &rown Alabama Smart Card +2 I 2$.)0

    2H12H200( itron Te?as US& 5rive $) I 12.+$2H12H200( Gang California 5854:om 2+( I 0.$$2H12H200( Gokuchi 5akota *ard drive 1%/ I ($.002H1)H200( Gokuchi assachusets US& 5rive 2+2 I 12.+$2H1)H200( Gang 5akota *ard drive 222 I ($.002H1)H200( &oulard Te?as *ard drive 11( I ($.002H1)H200( Gokuchi California C54:om +1 I 0.2$2H1+H200( &oulard lorida @rinter 2(2 I $+.002H1+H200( Gokuchi California Smart Card /, I 2$.)02H1+H200( Charlton Te?as C54:om 2(% I 0.2$2H1+H200( Charlton California *ard drive )01 I ($.002H1+H200( itron Te?as US& 5rive )%/ I 12.+$2H1$H200( &rown assachusets *ard drive ))2 I ($.002H1$H200( &rown ichigan *ard drive +, I ($.002H1$H200( Charlton Te?as -eyboard )$$ I (.$02H1$H200( Gokuchi California -eyboard 1(2 I (.$02H1$H200( Gokuchi assachusets US& 5rive 22(0 I 12.+$2H1$H200( Gokuchi California @rinter +($ I $+.002H1$H200( >ulian lorida Smart Card 2,$ I 2$.)02H1$H200( itron assachusets *ard drive (% I ($.002H1%H200( &oulard 3hio -eyboard 1+$ I (.$02H1%H200( Charlton California @rinter 21, I $+.002H1%H200( &rown assachusets *ard drive )10 I ($.002H1%H200( Charlton lorida Smart Card +1% I 2$.)02H1,H200( itron lorida @rinter 1/% I $+.002H1,H200( &oulard California US& 5rive 2++ I 12.+$2H20H200( &oulard California Smart Card +1+ I 2$.)02H21H200( Charlton assachusets US& 5rive )$% I 12.+$2H21H200( &rown California @rinter 1% I $+.00

  • 8/17/2019 Aufgaben Excel Workshop (1)

    12/338

    2H21H200( Gang California C54:om ),+ I 0.2$2H21H200( Smith assachusets 5854:om 1+0 I 0.$$2H22H200( Charlton Alabama -eyboard 1(/ I (.$02H22H200( &oulard California *ard drive +)0 I ($.002H22H200( Smith 3hio US& 5rive 10( I 12.+$2H22H200( Gang assachusets -eyboard 1( I (.$02H2)H200( itron assachusets US& 5rive 1%% I 12.+$2H2)H200( itron assachusets @rinter 12( I $+.002H2%H200( itron assachusets 5854:om +01 I 0.$$2H2%H200( "arcia 3hio Smart Card 1/) I 2$.)02H2%H200( "arcia Te?as Smart Card 2%, I 2$.)02H2%H200( itron lorida *ard drive 2(( I ($.002H2(H200( Gang California C54:om ,1 I 0.2$2H2(H200( >ulian California C54:om 10, I 0.2$2H2(H200( itron Te?as @rinter %0 I $+.002H2(H200( itron assachusets -eyboard (0 I (.$02H2(H200( "arcia ichigan 5854:om 2%, I 0.$$2H2/H200( >ulian Te?as @rinter +%, I $+.002H2/H200( &oulard Te?as *ard drive 1,$ I ($.002H2/H200( itron Te?as -eyboard 2/0 I (.$02H2/H200( &rown assachusets Smart Card 121 I 2$.)02H2/H200( >ulian California US& 5rive +%) I 12.+$

    )H1H200( itron =evada -eyboard 2+$ I (.$0)H1H200( Smith =evada @rinter 201 I $+.00)H1H200( Charlton ichigan -eyboard +(( I (.$0)H1H200( &oulard Te?as @rinter (+ I $+.00)H1H200( Charlton Te?as -eyboard 1+/ I (.$0)H1H200( Gokuchi Te?as *ard drive )%, I ($.00)H2H200( &rown assachusets -eyboard ,0 I (.$0)H%H200( >ulian Alabama 5854:om +2 I 0.$$)H%H200( &rown Te?as US& 5rive 12 I 12.+$)H(H200( >ulian Te?as Smart Card +(+ I 2$.)0)H(H200( >ulian Te?as @rinter +%( I $+.00)H(H200( "arcia lorida Smart Card +2, I 2$.)0)H(H200( &oulard California -eyboard +)( I (.$0)H(H200( >ulian California @rinter 100 I $+.00)H(H200( &rown Te?as US& 5rive 2/( I 12.+$)H(H200( Gokuchi 5akota @rinter 1%) I $+.00)H/H200( Gang =evada 5854:om )21 I 0.$$)H/H200( Charlton Te?as US& 5rive +1/ I 12.+$)H/H200( Smith Te?as Smart Card 20 I 2$.)0)H/H200( "arcia Alabama @rinter +$/ I $+.00)H,H200( Gang Te?as Smart Card 1+2 I 2$.)0)H,H200( itron ichigan 5854:om +$( I 0.$$

    )H12H200( itron ichigan US& 5rive )$ I 12.+$)H1)H200( Smith California -eyboard +0/ I (.$0)H1)H200( &oulard Alabama Smart Card +)+ I 2$.)0)H1)H200( Gokuchi Alabama 5854:om 2/) I 0.$$

  • 8/17/2019 Aufgaben Excel Workshop (1)

    13/338

    )H1+H200( itron =evada -eyboard 1(, I (.$0)H1+H200( itron =evada @rinter )%% I $+.00)H1+H200( >ulian California US& 5rive /$ I 12.+$)H1+H200( "arcia lorida @rinter +$0 I $+.00)H1+H200( Gang California 5854:om $$ I 0.$$)H1+H200( >ulian Te?as C54:om 202 I 0.2$)H1$H200( >ulian 3hio 5854:om 10( I 0.$$)H1$H200( Gang California 5854:om ++( I 0.$$)H1$H200( Smith =evada US& 5rive (( I 12.+$)H1$H200( Smith California @rinter +,( I $+.00)H1%H200( itron Alabama 5854:om +,+ I 0.$$)H1%H200( "arcia 3hio C54:om 11) I 0.2$)H1,H200( itron California 5854:om 1/, I 0.$$)H1,H200( itron California -eyboard 2%+ I (.$0)H1,H200( &oulard Te?as Smart Card +2 I 2$.)0)H20H200( Gang assachusets C54:om 1,0 I 0.2$)H20H200( Charlton Te?as *ard drive /, I ($.00)H21H200( >ulian California *ard drive 111 I ($.00)H21H200( &rown California US& 5rive ++0 I 12.+$)H22H200( "arcia Alabama @rinter 2%0 I $+.00)H22H200( &oulard Te?as -eyboard 10, I (.$0)H22H200( Smith California 5854:om 1(, I 0.$$)H22H200( "arcia California *ard drive +%2 I ($.00)H2%H200( &rown =evada C54:om )$( I 0.2$)H2%H200( Gokuchi Te?as *ard drive )(+ I ($.00)H2%H200( Gang =evada -eyboard )02 I (.$0)H2%H200( &oulard California US& 5rive +0) I 12.+$)H2%H200( "arcia assachusets -eyboard +(, I (.$0)H2%H200( &rown Te?as -eyboard )+/ I (.$0)H2(H200( Smith assachusets @rinter )%1 I $+.00)H2/H200( Gokuchi California *ard drive )00 I ($.00)H2/H200( Gokuchi Alabama *ard drive $$ I ($.00)H2/H200( "arcia Te?as 5854:om +2% I 0.$$)H2/H200( Charlton Alabama Smart Card )1% I 2$.)0)H2,H200( &oulard California Smart Card +11 I 2$.)0)H2,H200( itron Te?as Smart Card 2+) I 2$.)0)H2,H200( &oulard ichigan @rinter )1+ I $+.00)H2,H200( &rown lorida Smart Card %0 I 2$.)0)H2,H200( >ulian California @rinter 20) I $+.00)H2,H200( "arcia Alabama C54:om 12, I 0.2$)H2,H200( "arcia Te?as C54:om ))1 I 0.2$)H)0H200( >ulian Te?as C54:om 2%+ I 0.2$

    +H2H200( &rown California @rinter 21% I $+.00+H2H200( Smith 5akota Smart Card 2(0 I 2$.)0+H2H200( >ulian Te?as US& 5rive +1% I 12.+$+H2H200( Gang assachusets @rinter 21/ I $+.00+H2H200( Gokuchi ichigan @rinter 102 I $+.00+H)H200( "arcia Te?as *ard drive $0 I ($.00

  • 8/17/2019 Aufgaben Excel Workshop (1)

    14/338

    +H)H200( Gokuchi California C54:om /% I 0.2$+H)H200( >ulian Te?as *ard drive +/ I ($.00+H)H200( Gokuchi Te?as 5854:om 2$, I 0.$$+H)H200( Gang ichigan Smart Card +% I 2$.)0+H+H200( "arcia lorida *ard drive 2)) I ($.00+H+H200( &rown Te?as C54:om 1%( I 0.2$+H+H200( "arcia lorida C54:om 1%0 I 0.2$+H+H200( Gokuchi California 5854:om 2/+ I 0.$$+H+H200( Gang Te?as *ard drive 1,1 I ($.00+H+H200( Charlton Te?as *ard drive +%/ I ($.00+H+H200( Gang =evada Smart Card (1 I 2$.)0+H$H200( "arcia assachusets US& 5rive 1$% I 12.+$+H$H200( &oulard assachusets @rinter $, I $+.00+H$H200( Charlton Alabama Smart Card )%2 I 2$.)0+H$H200( Gokuchi ichigan *ard drive +2% I ($.00+H$H200( Gang 5akota C54:om 11, I 0.2$+H%H200( >ulian Te?as -eyboard $% I (.$0+H%H200( Gokuchi assachusets 5854:om +%0 I 0.$$+H%H200( Gokuchi California C54:om (+ I 0.2$+H%H200( Gang California @rinter 1%1 I $+.00+H%H200( itron =evada US& 5rive ,) I 12.+$+H%H200( Gokuchi California @rinter ++( I $+.00+H,H200( &oulard Te?as Smart Card +, I 2$.)0

    +H10H200( "arcia Alabama *ard drive +0/ I ($.00+H10H200( Gokuchi Te?as *ard drive )%, I ($.00+H10H200( Smith California US& 5rive )($ I 12.+$+H10H200( Charlton California US& 5rive +,2 I 12.+$+H11H200( itron Te?as US& 5rive 111 I 12.+$+H11H200( &oulard California @rinter +$, I $+.00+H11H200( Gokuchi Te?as *ard drive ,, I ($.00+H11H200( &rown Te?as 5854:om )($ I 0.$$+H11H200( Charlton California US& 5rive ++/ I 12.+$+H11H200( Smith Te?as -eyboard 2%) I (.$0+H11H200( >ulian Alabama -eyboard 1)0 I (.$0+H11H200( >ulian assachusets Smart Card 2)/ I 2$.)0+H11H200( itron Te?as Smart Card +2( I 2$.)0+H11H200( Gokuchi 5akota Smart Card +0+ I 2$.)0+H11H200( "arcia California -eyboard 11% I (.$0+H12H200( Gang ichigan @rinter ++% I $+.00+H12H200( >ulian lorida Smart Card 20/ I 2$.)0+H12H200( >ulian California *ard drive 2/ I ($.00+H12H200( itron Te?as -eyboard )2( I (.$0+H12H200( &oulard Te?as *ard drive )/% I ($.00+H12H200( Gokuchi ichigan @rinter ))) I $+.00+H1%H200( Gang 5akota @rinter 1/+ I $+.00+H1(H200( Smith ichigan 5854:om ++2 I 0.$$+H1(H200( Charlton Te?as @rinter +,/ I $+.00+H1(H200( Gang ichigan US& 5rive +$$ I 12.+$

  • 8/17/2019 Aufgaben Excel Workshop (1)

    15/338

    +H1(H200( itron California 5854:om 1) I 0.$$+H1/H200( &rown California 5854:om 120 I 0.$$+H1/H200( itron assachusets *ard drive 200 I ($.00+H1/H200( "arcia ichigan C54:om 1)$ I 0.2$+H1/H200( &rown Te?as -eyboard %% I (.$0+H1/H200( Smith =evada US& 5rive 12$ I 12.+$+H1/H200( >ulian Te?as US& 5rive +02 I 12.+$+H1,H200( &oulard lorida 5854:om 2$/ I 0.$$+H1,H200( Smith assachusets -eyboard 2+, I (.$0+H1,H200( &rown 3hio *ard drive )($ I ($.00+H1,H200( "arcia =evada Smart Card +(1 I 2$.)0+H1,H200( "arcia Te?as @rinter 2)+ I $+.00+H20H200( >ulian lorida *ard drive 1$% I ($.00+H20H200( Gokuchi 5akota Smart Card +,1 I 2$.)0+H20H200( itron Te?as -eyboard )++ I (.$0+H20H200( itron Te?as C54:om +// I 0.2$+H2)H200( "arcia Te?as @rinter )(1 I $+.00+H2)H200( &rown lorida C54:om +%) I 0.2$+H2)H200( "arcia assachusets *ard drive +( I ($.00+H2+H200( >ulian 5akota -eyboard ++2 I (.$0+H2$H200( Gokuchi ichigan *ard drive /% I ($.00+H2$H200( Charlton assachusets *ard drive )%% I ($.00+H2$H200( Gang California US& 5rive +1$ I 12.+$+H2$H200( &rown assachusets 5854:om +(, I 0.$$+H2%H200( Smith assachusets *ard drive 12+0 I ($.00+H2%H200( &rown California *ard drive 20% I ($.00+H2%H200( &rown Alabama *ard drive +01 I ($.00+H2%H200( >ulian California Smart Card 1+1 I 2$.)0+H2%H200( Gang California Smart Card 1() I 2$.)0+H2(H200( Gokuchi Alabama @rinter 12% I $+.00+H2(H200( "arcia California C54:om 1% I 0.2$+H)0H200( Gokuchi lorida @rinter 2$0 I $+.00+H)0H200( Gang Te?as 5854:om )01 I 0.$$+H)0H200( itron California @rinter )1% I $+.00

    $H1H200( Charlton ichigan C54:om 1,, I 0.2$$H1H200( Gang 5akota *ard drive $+ I ($.00$H1H200( itron Te?as 5854:om 1++ I 0.$$$H2H200( Gang 5akota US& 5rive 20+0 I 12.+$$H2H200( Gang 5akota C54:om +/% I 0.2$$H2H200( &oulard California C54:om 1)( I 0.2$$H2H200( Smith California C54:om $2 I 0.2$$H2H200( Smith Te?as 5854:om 10$ I 0.$$$H)H200( Gang assachusets C54:om 1,0 I 0.2$$H)H200( &rown =evada C54:om 1++ I 0.2$$H+H200( >ulian Te?as US& 5rive )/( I 12.+$$H+H200( &oulard =evada Smart Card %% I 2$.)0$H+H200( &rown 5akota Smart Card 202 I 2$.)0$H(H200( itron California US& 5rive 2%/ I 12.+$

  • 8/17/2019 Aufgaben Excel Workshop (1)

    16/338

    $H(H200( &rown California Smart Card +10 I 2$.)0$H/H200( Gokuchi Te?as US& 5rive +1$ I 12.+$$H,H200( itron California @rinter 1)$ I $+.00$H,H200( &oulard California US& 5rive 2)( I 12.+$$H,H200( &rown Te?as @rinter )1) I $+.00$H,H200( &oulard Te?as C54:om 12/ I 0.2$$H,H200( Smith ichigan *ard drive 2/+ I ($.00

    $H10H200( >ulian ichigan C54:om ))0 I 0.2$$H10H200( >ulian Te?as @rinter 2%0 I $+.00$H10H200( Gang Te?as C54:om )00 I 0.2$$H10H200( "arcia 3hio C54:om 11 I 0.2$$H10H200( itron California @rinter )($ I $+.00$H10H200( "arcia Te?as @rinter 2)$ I $+.00$H10H200( &rown lorida US& 5rive 1,2 I 12.+$$H11H200( Gokuchi assachusets -eyboard 2%$ I (.$0$H11H200( &oulard Te?as US& 5rive )% I 12.+$$H11H200( Gokuchi ichigan C54:om )1) I 0.2$$H11H200( Gang California 5854:om ,2 I 0.$$$H11H200( Charlton California C54:om 2)( I 0.2$$H11H200( >ulian lorida @rinter 1,2 I $+.00$H11H200( &oulard assachusets US& 5rive /, I 12.+$$H11H200( &oulard California 5854:om %( I 0.$$$H1+H200( Gang 3hio @rinter 2%2 I $+.00$H1+H200( >ulian Te?as US& 5rive 1/0 I 12.+$$H1+H200( Charlton =evada @rinter )$/ I $+.00$H1$H200( &oulard =evada *ard drive +12 I ($.00$H1$H200( itron assachusets @rinter 2(2 I $+.00$H1$H200( >ulian California @rinter )$1 I $+.00$H1%H200( Smith Te?as Smart Card ,2 I 2$.)0$H1%H200( Smith California -eyboard 2+( I (.$0$H1%H200( itron California 5854:om +), I 0.$$$H1%H200( &rown assachusets C54:om /00 I 0.2$$H1%H200( Smith Te?as *ard drive )) I ($.00$H1%H200( Charlton =evada 5854:om 2/+ I 0.$$$H1(H200( Gokuchi California 5854:om 1%, I 0.$$$H1(H200( Gokuchi California Smart Card )10 I 2$.)0$H1(H200( "arcia =evada @rinter 1)/ I $+.00$H1(H200( >ulian California US& 5rive ),, I 12.+$$H1(H200( Charlton California C54:om )%/ I 0.2$$H1(H200( >ulian Te?as *ard drive 20 I ($.00$H1(H200( &oulard California -eyboard 2,$ I (.$0$H1/H200( itron assachusets -eyboard +02 I (.$0$H1/H200( itron 5akota US& 5rive )%+ I 12.+$$H21H200( "arcia assachusets US& 5rive 2+ I 12.+$$H21H200( &rown California @rinter 2%+ I $+.00$H22H200( "arcia =evada *ard drive 1$$ I ($.00$H22H200( Gang =evada *ard drive +,, I ($.00$H2)H200( Gokuchi California Smart Card 2( I 2$.)0

  • 8/17/2019 Aufgaben Excel Workshop (1)

    17/338

    $H2)H200( Charlton assachusets C54:om +$ I 0.2$$H2)H200( Smith California US& 5rive +1( I 12.+$$H2)H200( Charlton ichigan -eyboard +/$ I (.$0$H2)H200( Gang Te?as Smart Card )01 I 2$.)0$H2)H200( Charlton California *ard drive 1)( I ($.00$H2)H200( Gokuchi California US& 5rive 1(( I 12.+$$H2+H200( Smith 5akota *ard drive 22$ I ($.00$H2+H200( &rown assachusets C54:om )), I 0.2$$H2+H200( &rown 5akota US& 5rive 12/ I 12.+$$H2+H200( "arcia California C54:om )%1 I 0.2$$H2+H200( &rown assachusets 5854:om )(% I 0.$$$H2+H200( itron Te?as C54:om +/ I 0.2$$H2+H200( "arcia Te?as US& 5rive +/0 I 12.+$$H2+H200( "arcia Te?as @rinter 2$ I $+.00$H2$H200( &oulard lorida 5854:om 1+0 I 0.$$$H2/H200( itron 5akota C54:om ++( I 0.2$$H2/H200( Gokuchi Te?as @rinter )(, I $+.00$H2/H200( &rown Te?as C54:om 22 I 0.2$$H)0H200( Gang Te?as US& 5rive +(% I 12.+$$H)0H200( Gang assachusets *ard drive %% I ($.00$H)0H200( Gang Te?as US& 5rive 1($ I 12.+$$H)0H200( Gokuchi California *ard drive 2)2 I ($.00$H)0H200( Charlton 3hio *ard drive 10+ I ($.00$H)0H200( "arcia California @rinter (20 I $+.00$H)0H200( Gokuchi 3hio 5854:om +/, I 0.$$$H)0H200( Gang California Smart Card 2,$ I 2$.)0$H)1H200( Gang 3hio 5854:om ++1 I 0.$$$H)1H200( >ulian assachusets -eyboard 2)2 I (.$0$H)1H200( itron assachusets @rinter +($ I $+.00$H)1H200( itron ichigan *ard drive 1++ I ($.00$H)1H200( "arcia California 5854:om ))/ I 0.$$$H)1H200( itron 5akota @rinter )10 I $+.00$H)1H200( "arcia assachusets Smart Card )1+ I 2$.)0$H)1H200( Smith assachusets -eyboard 2%+ I (.$0

    %H1H200( "arcia Te?as US& 5rive 2+2 I 12.+$%H+H200( &oulard assachusets -eyboard )+0 I (.$0%H+H200( &oulard 3hio 5854:om 2+) I 0.$$%H+H200( Gokuchi assachusets *ard drive (( I ($.00%H+H200( >ulian Alabama -eyboard +0% I (.$0%H%H200( Charlton Te?as 5854:om 2+1 I 0.$$%H%H200( Charlton =evada Smart Card )% I 2$.)0%H%H200( itron assachusets *ard drive 2(2 I ($.00%H(H200( &rown California *ard drive 22$ I ($.00%H(H200( &oulard 3hio *ard drive )( I ($.00%H(H200( "arcia California *ard drive ),% I ($.00%H(H200( &rown Te?as *ard drive 11, I ($.00%H(H200( Gang ichigan *ard drive 11% I ($.00%H(H200( Gokuchi Te?as US& 5rive )/$ I 12.+$

  • 8/17/2019 Aufgaben Excel Workshop (1)

    18/338

    %H/H200( &oulard assachusets -eyboard 1,/ I (.$0%H/H200( >ulian Te?as C54:om 1%$ I 0.2$%H/H200( &rown 5akota *ard drive ),2 I ($.00%H/H200( Charlton Te?as US& 5rive 11% I 12.+$%H/H200( >ulian assachusets 5854:om 2/ I 0.$$

    %H11H200( >ulian California *ard drive 2%0 I ($.00%H12H200( "arcia California US& 5rive /1 I 12.+$%H1)H200( >ulian assachusets US& 5rive 2$( I 12.+$%H1)H200( Gang assachusets *ard drive 111 I ($.00%H1)H200( "arcia assachusets @rinter ,) I $+.00%H1)H200( "arcia California *ard drive 1% I ($.00%H1)H200( &rown Te?as -eyboard 1,, I (.$0%H1)H200( &rown ichigan *ard drive )() I ($.00%H1+H200( &rown =evada -eyboard )+1 I (.$0%H1+H200( >ulian lorida US& 5rive 2/$ I 12.+$%H1/H200( "arcia 5akota *ard drive )+( I ($.00%H1/H200( >ulian Te?as 5854:om // I 0.$$%H1/H200( Charlton Te?as Smart Card )/) I 2$.)0%H1,H200( >ulian Alabama -eyboard 21$ I (.$0%H1,H200( Gang Te?as 5854:om +)( I 0.$$%H1,H200( Gokuchi assachusets US& 5rive 22/ I 12.+$%H1,H200( Charlton California C54:om 2(+ I 0.2$%H20H200( &oulard Te?as Smart Card +%% I 2$.)0%H20H200( Charlton ichigan 5854:om +(2 I 0.$$%H20H200( Gokuchi Te?as @rinter )0 I $+.00%H20H200( Charlton 5akota *ard drive )+1 I ($.00%H20H200( itron Te?as 5854:om +++ I 0.$$%H21H200( >ulian Te?as -eyboard )12 I (.$0%H21H200( Smith lorida *ard drive +1, I ($.00%H21H200( >ulian =evada 5854:om 1/2 I 0.$$%H21H200( &oulard assachusets *ard drive $2 I ($.00%H21H200( Smith 5akota *ard drive +/2 I ($.00%H21H200( Charlton =evada C54:om +%/ I 0.2$%H22H200( &oulard assachusets C54:om 1$0 I 0.2$%H22H200( >ulian Te?as -eyboard 1(+ I (.$0%H2$H200( Charlton California *ard drive 1(0 I ($.00%H2$H200( &rown Alabama @rinter 10) I $+.00%H2%H200( Gang California US& 5rive 2(% I 12.+$%H2%H200( "arcia Alabama -eyboard ,$ I (.$0%H2%H200( Smith Te?as C54:om 2(0 I 0.2$%H2(H200( &rown Te?as -eyboard 1)% I (.$0%H2(H200( itron =evada US& 5rive 1( I 12.+$%H2(H200( itron ichigan C54:om +)( I 0.2$%H2(H200( &oulard assachusets US& 5rive )/1 I 12.+$%H2(H200( "arcia assachusets *ard drive +,% I ($.00%H2(H200( &rown assachusets US& 5rive +0+ I 12.+$%H2/H200( Smith lorida Smart Card +$0 I 2$.)0%H2/H200( &rown =evada US& 5rive 2(( I 12.+$

  • 8/17/2019 Aufgaben Excel Workshop (1)

    19/338

    %H2/H200( >ulian Te?as Smart Card 21/ I 2$.)0%H2/H200( >ulian Te?as US& 5rive +,$ I 12.+$%H2/H200( itron 3hio C54:om %0 I 0.2$%H2/H200( "arcia Alabama -eyboard )%2 I (.$0%H2,H200( >ulian Te?as -eyboard +2% I (.$0

    (H2H200( itron California US& 5rive 202 I 12.+$(H2H200( Gokuchi California US& 5rive 21) I 12.+$(H2H200( itron assachusets Smart Card 1%2 I 2$.)0(H)H200( "arcia Te?as 5854:om 12$0 I 0.$$(H+H200( Charlton Alabama Smart Card 2)1 I 2$.)0(H+H200( >ulian assachusets @rinter (% I $+.00(H+H200( Charlton California -eyboard // I (.$0(H+H200( Smith assachusets US& 5rive +$( I 12.+$(H+H200( Gokuchi =evada Smart Card (% I 2$.)0(H+H200( itron =evada 5854:om 222 I 0.$$(H+H200( Gang California @rinter )0) I $+.00(H+H200( Charlton assachusets *ard drive (, I ($.00(H+H200( "arcia Te?as @rinter 1(% I $+.00(H$H200( Gokuchi ichigan @rinter 2,0 I $+.00(H$H200( &oulard 3hio @rinter 11( I $+.00(H$H200( itron ichigan *ard drive 2$+ I ($.00(H%H200( &oulard California 5854:om %0 I 0.$$(H%H200( itron assachusets US& 5rive +)% I 12.+$(H%H200( &rown California -eyboard )11 I (.$0(H%H200( &rown Te?as @rinter )+( I $+.00(H,H200( Charlton Te?as *ard drive 1%2 I ($.00(H,H200( &rown 3hio Smart Card +)+ I 2$.)0(H,H200( itron =evada -eyboard +)0 I (.$0(H,H200( "arcia California *ard drive 10) I ($.00

    (H11H200( &oulard Te?as 5854:om +%1 I 0.$$(H11H200( "arcia ichigan @rinter )+2 I $+.00(H11H200( &rown California @rinter 2+, I $+.00(H11H200( "arcia California @rinter ++% I $+.00(H12H200( &oulard assachusets 5854:om 1)+0 I 0.$$(H12H200( >ulian =evada -eyboard )0( I (.$0(H12H200( &rown assachusets -eyboard )0, I (.$0(H12H200( &rown California C54:om )$$ I 0.2$(H12H200( Gokuchi Te?as 5854:om 2$ I 0.$$(H12H200( &oulard assachusets C54:om 21/ I 0.2$(H1)H200( &rown =evada Smart Card 2/ I 2$.)0(H1%H200( Smith Alabama C54:om 2/2 I 0.2$(H1%H200( Charlton 5akota C54:om 2/+ I 0.2$(H1%H200( Smith assachusets Smart Card +(0 I 2$.)0(H1(H200( &rown Te?as C54:om +$0 I 0.2$(H1(H200( &rown Te?as *ard drive )+( I ($.00(H1(H200( >ulian =evada Smart Card 1)+ I 2$.)0(H1(H200( Gang assachusets US& 5rive ))+ I 12.+$(H1/H200( "arcia =evada *ard drive 1/0 I ($.00

  • 8/17/2019 Aufgaben Excel Workshop (1)

    20/338

    (H1/H200( Gang California Smart Card (% I 2$.)0(H1/H200( >ulian California US& 5rive 100 I 12.+$(H1/H200( itron assachusets @rinter +11 I $+.00(H1/H200( &oulard Te?as @rinter )+2 I $+.00(H1/H200( &oulard assachusets US& 5rive )++ I 12.+$(H1/H200( &rown Te?as Smart Card 1$) I 2$.)0(H1/H200( Gang lorida C54:om )$ I 0.2$(H1/H200( itron California -eyboard )($ I (.$0(H1/H200( >ulian assachusets *ard drive 10 I ($.00(H1/H200( Gang assachusets 5854:om +1 I 0.$$(H1/H200( itron 3hio US& 5rive 2% I 12.+$(H1,H200( Charlton Te?as *ard drive +20 I ($.00(H1,H200( Charlton lorida *ard drive )2% I ($.00(H1,H200( Charlton California 5854:om 21) I 0.$$(H1,H200( Gokuchi Te?as -eyboard ))+ I (.$0(H1,H200( itron 3hio -eyboard $00 I (.$0(H1,H200( Gang =evada -eyboard 1,$ I (.$0(H1,H200( "arcia 5akota C54:om /1 I 0.2$(H1,H200( "arcia 5akota -eyboard 1$) I (.$0(H20H200( &rown 5akota C54:om 2/( I 0.2$(H20H200( &rown 5akota *ard drive )2) I ($.00(H20H200( Smith lorida US& 5rive +$1 I 12.+$(H20H200( Smith =evada @rinter 1$, I $+.00(H2)H200( itron California C54:om 11$ I 0.2$(H2+H200( Gokuchi assachusets -eyboard /0 I (.$0(H2+H200( &oulard =evada US& 5rive +/, I 12.+$(H2+H200( "arcia lorida Smart Card ),( I 2$.)0(H2$H200( Charlton California *ard drive 21, I ($.00(H2$H200( Gokuchi =evada @rinter 22) I $+.00(H2$H200( Charlton Te?as US& 5rive )(/ I 12.+$(H2$H200( itron 5akota *ard drive )22 I ($.00(H2$H200( "arcia California Smart Card 2+$ I 2$.)0(H2$H200( Smith assachusets US& 5rive 20) I 12.+$(H2%H200( "arcia 3hio Smart Card 2,, I 2$.)0(H2%H200( "arcia 3hio US& 5rive )+0 I 12.+$(H2%H200( &oulard 3hio @rinter 20% I $+.00(H2%H200( Charlton =evada *ard drive +,, I ($.00(H2(H200( Gang Te?as *ard drive )) I ($.00(H2(H200( &oulard assachusets US& 5rive 102 I 12.+$(H)0H200( Charlton Te?as @rinter 2)% I $+.00(H)0H200( "arcia =evada *ard drive 1$1 I ($.00(H)0H200( >ulian California *ard drive 2%/ I ($.00(H)0H200( Charlton Te?as C54:om 1$1 I 0.2$(H)0H200( &rown California *ard drive ,2 I ($.00(H)0H200( "arcia Te?as -eyboard +$+ I (.$0(H)1H200( itron =evada Smart Card +/2 I 2$.)0(H)1H200( itron Te?as 5854:om +/( I 0.$$

    /H2H200( &oulard assachusets -eyboard ,% I (.$0

  • 8/17/2019 Aufgaben Excel Workshop (1)

    21/338

    /H2H200( >ulian 3hio *ard drive 11, I ($.00/H2H200( Charlton assachusets US& 5rive )(1 I 12.+$/H2H200( >ulian California @rinter %$ I $+.00/H2H200( &rown 5akota Smart Card /0 I 2$.)0/H2H200( &rown Alabama Smart Card 1, I 2$.)0/H2H200( "arcia assachusets *ard drive $+ I ($.00/H2H200( &rown 3hio Smart Card 1(/ I 2$.)0/H2H200( &rown ichigan 5854:om )(% I 0.$$/H2H200( Gokuchi California 5854:om 2( I 0.$$/H)H200( Smith Alabama US& 5rive +$1 I 12.+$/H%H200( Gokuchi California *ard drive 22% I ($.00/H%H200( &rown =evada @rinter ))( I $+.00/H%H200( Gang =evada 5854:om +,1 I 0.$$/H%H200( Smith =evada US& 5rive 12$ I 12.+$/H(H200( "arcia Te?as -eyboard 2+$ I (.$0/H(H200( &oulard Alabama -eyboard 1)2 I (.$0/H(H200( >ulian 3hio 5854:om 1)2 I 0.$$/H(H200( Gang assachusets Smart Card 2%, I 2$.)0/H/H200( &oulard Te?as Smart Card 1$, I 2$.)0/H/H200( "arcia assachusets @rinter $$ I $+.00/H/H200( Gokuchi 5akota 5854:om 102 I 0.$$/H/H200( >ulian Te?as C54:om ,) I 0.2$/H/H200( itron Te?as C54:om )+( I 0.2$/H/H200( &rown California -eyboard $$ I (.$0/H,H200( >ulian California Smart Card +%/ I 2$.)0/H,H200( &oulard Te?as @rinter %( I $+.00/H,H200( Smith assachusets 5854:om +%( I 0.$$/H,H200( Smith California 5854:om +%) I 0.$$/H,H200( Gang assachusets Smart Card 1++ I 2$.)0/H,H200( &oulard Te?as *ard drive 2%1 I ($.00/H,H200( "arcia Te?as -eyboard 22, I (.$0

    /H10H200( &oulard assachusets -eyboard +12 I (.$0/H10H200( Gokuchi assachusets @rinter %$ I $+.00/H10H200( Gokuchi California US& 5rive 1,0 I 12.+$/H1)H200( &rown ichigan C54:om +2$ I 0.2$/H1)H200( Smith Te?as 5854:om 10/ I 0.$$/H1)H200( &oulard California C54:om %0 I 0.2$/H1+H200( Gang assachusets Smart Card 1$/ I 2$.)0/H1+H200( "arcia assachusets US& 5rive 1)+ I 12.+$/H1+H200( >ulian =evada Smart Card ,/ I 2$.)0/H1$H200( &rown Te?as Smart Card +% I 2$.)0/H1$H200( Gokuchi California Smart Card )0+ I 2$.)0/H1$H200( &rown 3hio -eyboard )%( I (.$0/H1$H200( Smith lorida *ard drive )++ I ($.00/H1$H200( &rown ichigan US& 5rive 1+0 I 12.+$/H1$H200( Charlton Te?as 5854:om )(/ I 0.$$/H1$H200( "arcia California @rinter 1( I $+.00/H1$H200( Gokuchi Te?as Smart Card 2$0 I 2$.)0

  • 8/17/2019 Aufgaben Excel Workshop (1)

    22/338

    /H1$H200( "arcia Alabama US& 5rive 1( I 12.+$/H1$H200( Gang Te?as @rinter 1++ I $+.00/H1$H200( >ulian assachusets *ard drive +/+ I ($.00/H1$H200( Smith Te?as 5854:om 1+0 I 0.$$/H1%H200( Smith 3hio -eyboard )/( I (.$0/H1%H200( &oulard assachusets Smart Card 1/0 I 2$.)0/H1%H200( Gang assachusets C54:om ))0 I 0.2$/H1(H200( &oulard California @rinter (( I $+.00/H1(H200( Smith California *ard drive $/ I ($.00/H1(H200( Smith California 5854:om 1/+ I 0.$$/H1(H200( Gokuchi assachusets Smart Card 1(1 I 2$.)0/H1(H200( Smith Te?as C54:om +(( I 0.2$/H1(H200( &rown 5akota @rinter 12+ I $+.00/H21H200( >ulian California @rinter (0 I $+.00/H21H200( &rown ichigan C54:om ))) I 0.2$/H21H200( >ulian =evada -eyboard )1/ I (.$0/H21H200( "arcia 3hio Smart Card 22% I 2$.)0/H21H200( &rown Te?as *ard drive )(% I ($.00/H21H200( "arcia Te?as 5854:om 2,% I 0.$$/H22H200( itron lorida US& 5rive 1%( I 12.+$/H22H200( Gokuchi ichigan C54:om +,$ I 0.2$/H22H200( &rown California 5854:om 2+$ I 0.$$/H22H200( &oulard California @rinter 2%/ I $+.00/H22H200( >ulian 3hio 5854:om 2$% I 0.$$/H22H200( itron Alabama US& 5rive 2/2 I 12.+$/H22H200( &rown Te?as -eyboard $00 I (.$0/H22H200( itron Te?as -eyboard )2/ I (.$0/H22H200( &rown Te?as Smart Card 10, I 2$.)0/H2)H200( Gang Te?as *ard drive +0, I ($.00/H2)H200( itron ichigan *ard drive 20 I ($.00/H2)H200( itron California C54:om +(+ I 0.2$/H2)H200( "arcia lorida 5854:om 101 I 0.$$/H2)H200( itron lorida -eyboard ++$ I (.$0/H2+H200( "arcia assachusets 5854:om +(% I 0.$$/H2(H200( Gokuchi Alabama *ard drive ++1 I ($.00/H2(H200( Smith Te?as US& 5rive (1 I 12.+$/H2(H200( >ulian lorida Smart Card 2,+ I 2$.)0/H2(H200( Smith Te?as -eyboard 1/) I (.$0/H2/H200( >ulian California C54:om )/0 I 0.2$/H2/H200( itron Te?as *ard drive 1/$ I ($.00/H2/H200( Gokuchi 5akota @rinter 1$% I $+.00/H2,H200( Gokuchi assachusets US& 5rive 2)/ I 12.+$/H)0H200( Charlton California -eyboard /, I (.$0/H)0H200( "arcia =evada -eyboard %( I (.$0/H)0H200( "arcia California US& 5rive )$1 I 12.+$/H)0H200( itron lorida 5854:om 1++ I 0.$$/H)0H200( Gokuchi assachusets -eyboard /$ I (.$0/H)0H200( >ulian =evada *ard drive )$0 I ($.00

  • 8/17/2019 Aufgaben Excel Workshop (1)

    23/338

  • 8/17/2019 Aufgaben Excel Workshop (1)

    24/338

    ,H1/H200( Gokuchi California @rinter 1)0 I $+.00,H1,H200( &oulard California @rinter 2$% I $+.00,H1,H200( Charlton assachusets C54:om +0/ I 0.2$,H1,H200( Charlton =evada C54:om 2++ I 0.2$,H1,H200( Charlton assachusets *ard drive ),) I ($.00,H20H200( "arcia assachusets @rinter 2+/ I $+.00,H20H200( Charlton ichigan C54:om +%/ I 0.2$,H20H200( &rown Te?as C54:om 2)% I 0.2$,H20H200( Gokuchi ichigan C54:om ))/ I 0.2$,H20H200( &oulard Te?as Smart Card 2,$ I 2$.)0,H20H200( >ulian assachusets US& 5rive 21, I 12.+$,H20H200( "arcia Alabama @rinter +,+ I $+.00,H21H200( >ulian Te?as @rinter )0, I $+.00,H21H200( Gang Te?as Smart Card +/1 I 2$.)0,H21H200( &rown assachusets Smart Card 1+, I 2$.)0,H21H200( itron 3hio C54:om 2,( I 0.2$,H21H200( itron =evada *ard drive +11 I ($.00,H21H200( Charlton Te?as -eyboard 1%0 I (.$0,H2+H200( Gokuchi 3hio US& 5rive 22/ I 12.+$,H2+H200( Gokuchi California 5854:om +$ I 0.$$,H2+H200( Gokuchi ichigan US& 5rive /) I 12.+$,H2+H200( Charlton California C54:om ),0 I 0.2$,H2$H200( &oulard Te?as 5854:om 102 I 0.$$,H2$H200( itron Te?as @rinter +$, I $+.00,H2$H200( Gang Te?as 5854:om +)2 I 0.$$,H2%H200( "arcia California @rinter +%0 I $+.00,H2%H200( Gang California C54:om +, I 0.2$,H2(H200( Gokuchi Te?as C54:om /2 I 0.2$,H2(H200( "arcia 3hio C54:om 1210 I 0.2$,H2(H200( Smith 3hio C54:om +$, I 0.2$,H2(H200( itron California *ard drive 2, I ($.00,H2(H200( Gang assachusets @rinter 2(% I $+.00,H2/H200( Charlton 5akota Smart Card ,0 I 2$.)0,H2/H200( Charlton California 5854:om )0+ I 0.$$10H1H200( "arcia assachusets 5854:om 2(% I 0.$$10H1H200( Charlton Alabama 5854:om 2/$ I 0.$$10H1H200( Charlton Te?as US& 5rive )(0 I 12.+$10H1H200( &oulard =evada @rinter 1+, I $+.0010H1H200( Smith lorida -eyboard )20 I (.$010H1H200( Gokuchi assachusets *ard drive +(, I ($.0010H2H200( Gokuchi =evada C54:om 220 I 0.2$10H2H200( &rown =evada C54:om 2%) I 0.2$10H)H200( >ulian Alabama US& 5rive +21 I 12.+$10H)H200( Gang California @rinter ,( I $+.0010H)H200( Gang 3hio @rinter +/) I $+.0010H)H200( &rown Te?as @rinter 211 I $+.0010H)H200( Smith Te?as 5854:om )++ I 0.$$10H)H200( >ulian California -eyboard )2$ I (.$0

  • 8/17/2019 Aufgaben Excel Workshop (1)

    25/338

    10H)H200( Gang ichigan 5854:om 2%) I 0.$$10H)H200( Smith assachusets Smart Card )$/ I 2$.)010H)H200( "arcia assachusets C54:om 22) I 0.2$10H+H200( &rown assachusets C54:om +( I 0.2$10H+H200( itron assachusets 5854:om ++0 I 0.$$10H+H200( Gokuchi Alabama C54:om 20 I 0.2$10H+H200( Charlton ichigan US& 5rive )20 I 12.+$10H$H200( Charlton assachusets @rinter )+/ I $+.0010H$H200( &oulard =evada @rinter $( I $+.0010H/H200( >ulian California @rinter 10, I $+.0010H/H200( itron assachusets 5854:om 2$+ I 0.$$10H/H200( Gang Te?as -eyboard 20$ I (.$010H/H200( Gokuchi California C54:om 1,/ I 0.2$10H,H200( Gang assachusets @rinter 1(+ I $+.0010H,H200( >ulian =evada 5854:om 1)1 I 0.$$10H,H200( "arcia California -eyboard 2+1 I (.$0

    10H10H200( "arcia assachusets 5854:om 120 I 0.$$10H10H200( "arcia 5akota Smart Card +2/ I 2$.)010H10H200( "arcia =evada *ard drive 1,/ I ($.0010H10H200( >ulian California US& 5rive +2) I 12.+$10H10H200( >ulian Alabama C54:om 11$ I 0.2$10H10H200( "arcia ichigan US& 5rive (+ I 12.+$10H10H200( &rown =evada Smart Card +1 I 2$.)010H10H200( &oulard Te?as C54:om %, I 0.2$10H10H200( "arcia Te?as 5854:om )$) I 0.$$10H10H200( Gokuchi lorida 5854:om +1+ I 0.$$10H11H200( >ulian 3hio -eyboard 2,( I (.$010H11H200( Charlton Te?as 5854:om +2( I 0.$$10H12H200( &oulard California -eyboard $+ I (.$010H12H200( &oulard California Smart Card )/% I 2$.)010H12H200( Gang California US& 5rive 2() I 12.+$10H12H200( >ulian =evada 5854:om 2+ I 0.$$10H12H200( Gang Te?as -eyboard )1, I (.$010H12H200( itron Alabama *ard drive 22, I ($.0010H12H200( itron Te?as Smart Card ), I 2$.)010H1$H200( "arcia lorida C54:om )$) I 0.2$10H1$H200( itron =evada US& 5rive 2)( I 12.+$10H1%H200( &oulard Alabama 5854:om )// I 0.$$10H1%H200( &oulard =evada Smart Card +02 I 2$.)010H1%H200( &oulard Te?as @rinter 1+$ I $+.0010H1%H200( &oulard Te?as *ard drive () I ($.0010H1(H200( &rown ichigan -eyboard 1$/ I (.$010H1(H200( Gang 3hio 5854:om +/$ I 0.$$10H1(H200( Gokuchi =evada Smart Card 2/+ I 2$.)010H1(H200( Gokuchi California C54:om 2+1 I 0.2$10H1(H200( Smith lorida C54:om /( I 0.2$10H1(H200( Gokuchi Alabama 5854:om () I 0.$$10H1(H200( Gokuchi lorida C54:om )1( I 0.2$

  • 8/17/2019 Aufgaben Excel Workshop (1)

    26/338

    10H1(H200( itron California US& 5rive // I 12.+$10H1(H200( Gokuchi 5akota 5854:om ),/ I 0.$$10H1(H200( >ulian assachusets Smart Card 22 I 2$.)010H1/H200( Smith =evada 5854:om +), I 0.$$10H1/H200( >ulian California *ard drive )(+ I ($.0010H1/H200( Gang California US& 5rive () I 12.+$10H1/H200( "arcia Te?as @rinter ,, I $+.0010H1/H200( Gokuchi =evada US& 5rive 2, I 12.+$10H1/H200( "arcia Alabama US& 5rive 2+0 I 12.+$10H1,H200( Smith assachusets -eyboard ))2 I (.$010H1,H200( "arcia California *ard drive 2%$ I ($.0010H1,H200( Smith 3hio C54:om )%/ I 0.2$10H1,H200( &rown Te?as Smart Card 2/2 I 2$.)010H1,H200( itron =evada 5854:om +00 I 0.$$10H1,H200( "arcia Te?as US& 5rive )/) I 12.+$10H1,H200( itron assachusets US& 5rive )1+ I 12.+$10H22H200( Gang assachusets *ard drive 2)/0 I ($.0010H22H200( Smith Te?as @rinter +)0 I $+.0010H22H200( "arcia assachusets 5854:om )%) I 0.$$10H22H200( "arcia California Smart Card ),0 I 2$.)010H2)H200( Smith assachusets 5854:om )(% I 0.$$10H2)H200( Gokuchi California C54:om )/) I 0.2$10H2)H200( Charlton California *ard drive )+$ I ($.0010H2)H200( Gang 5akota US& 5rive 2/$ I 12.+$10H2)H200( &oulard California US& 5rive +,/ I 12.+$10H2)H200( Gokuchi assachusets @rinter +21 I $+.0010H2)H200( "arcia lorida *ard drive ),2 I ($.0010H2+H200( Gokuchi assachusets US& 5rive 1$+ I 12.+$10H2+H200( >ulian 3hio C54:om )10 I 0.2$10H2+H200( Charlton California 5854:om 2+2 I 0.$$10H2+H200( >ulian =evada @rinter )(( I $+.0010H2+H200( &rown California -eyboard 1,1 I (.$010H2$H200( Gokuchi California Smart Card 2$/ I 2$.)010H2$H200( "arcia assachusets 5854:om )02 I 0.$$10H2$H200( &rown ichigan -eyboard 1(+ I (.$010H2$H200( "arcia assachusets US& 5rive 120 I 12.+$10H2$H200( &oulard Alabama Smart Card )/ I 2$.)010H2%H200( "arcia =evada *ard drive 1,) I ($.0010H2,H200( Gokuchi =evada C54:om ++ I 0.2$10H2,H200( >ulian assachusets 5854:om +20 I 0.$$10H2,H200( "arcia California US& 5rive +,/ I 12.+$10H2,H200( >ulian Te?as US& 5rive 2() I 12.+$10H)0H200( Smith lorida C54:om 2%) I 0.2$10H)0H200( Gang California @rinter 1,+ I $+.0010H)0H200( &oulard California US& 5rive 11 I 12.+$10H)1H200( Smith 5akota -eyboard )0 I (.$010H)1H200( &oulard California C54:om +11 I 0.2$10H)1H200( Charlton lorida @rinter 1(2 I $+.00

  • 8/17/2019 Aufgaben Excel Workshop (1)

    27/338

    10H)1H200( itron assachusets *ard drive ), I ($.0010H)1H200( itron 3hio *ard drive 20, I ($.0010H)1H200( >ulian Te?as 5854:om )0 I 0.$$10H)1H200( itron assachusets Smart Card 2,$ I 2$.)0

    11H1H200( Smith Te?as C54:om 12$ I 0.2$11H1H200( "arcia ichigan US& 5rive ,$ I 12.+$11H1H200( Gang lorida @rinter %) I $+.0011H1H200( Smith Te?as -eyboard +0$ I (.$011H1H200( Smith 5akota *ard drive )+$ I ($.0011H1H200( Gokuchi California Smart Card 11/ I 2$.)011H1H200( >ulian =evada -eyboard )22 I (.$011H1H200( &rown =evada -eyboard 2$, I (.$011H2H200( Smith Alabama @rinter 2/( I $+.0011H2H200( &rown Te?as 5854:om 20$ I 0.$$11H$H200( &oulard Te?as *ard drive %/ I ($.0011H$H200( Gokuchi Te?as @rinter 2/( I $+.0011H$H200( itron Te?as *ard drive ),) I ($.0011H$H200( "arcia California @rinter +20 I $+.0011H$H200( &rown California -eyboard ))1 I (.$011H%H200( itron assachusets C54:om 2,/ I 0.2$11H%H200( itron ichigan Smart Card )$% I 2$.)011H%H200( Charlton Alabama C54:om 21$ I 0.2$11H(H200( "arcia Te?as Smart Card 12, I 2$.)011H(H200( Charlton assachusets @rinter 2)2 I $+.0011H(H200( &rown 5akota US& 5rive 2// I 12.+$11H(H200( Gokuchi California *ard drive 2(( I ($.0011H/H200( "arcia =evada Smart Card 1$) I 2$.)011H/H200( Smith California US& 5rive 2(% I 12.+$11H/H200( &rown lorida *ard drive /( I ($.0011H/H200( "arcia assachusets 5854:om 1/0 I 0.$$11H,H200( "arcia Te?as 5854:om +/2 I 0.$$11H,H200( >ulian Te?as US& 5rive 1$) I 12.+$11H,H200( &rown California US& 5rive 1++ I 12.+$11H,H200( Gokuchi assachusets *ard drive +0 I ($.00

    11H12H200( Gokuchi 5akota Smart Card +20 I 2$.)011H12H200( Charlton 3hio Smart Card ))1 I 2$.)011H12H200( &rown lorida @rinter 10) I $+.0011H12H200( &rown California Smart Card 1+0 I 2$.)011H12H200( Gang California Smart Card )%1 I 2$.)011H1)H200( itron lorida -eyboard +,/ I (.$011H1)H200( Gang ichigan @rinter 1/% I $+.0011H1)H200( Smith California -eyboard +$1 I (.$011H1+H200( Charlton California US& 5rive /0 I 12.+$11H1+H200( Smith California @rinter +12 I $+.0011H1+H200( &rown California Smart Card +2 I 2$.)011H1+H200( Charlton =evada -eyboard 120 I (.$011H1+H200( Charlton Te?as 5854:om )%) I 0.$$11H1+H200( Gang California C54:om )2/ I 0.2$

  • 8/17/2019 Aufgaben Excel Workshop (1)

    28/338

    11H1$H200( Charlton Te?as 5854:om 2$% I 0.$$11H1$H200( Gang Te?as -eyboard 1,+ I (.$011H1$H200( &rown Te?as C54:om 2(+ I 0.2$11H1$H200( Gang 5akota *ard drive 2(0 I ($.0011H1$H200( Charlton assachusets 5854:om 1,2 I 0.$$11H1$H200( Gang =evada 5854:om 2)0 I 0.$$11H1%H200( &oulard assachusets C54:om 2%2 I 0.2$11H1%H200( Smith California @rinter ++2 I $+.0011H1,H200( itron Te?as -eyboard +%+ I (.$011H1,H200( itron assachusets *ard drive )(+ I ($.0011H20H200( Gokuchi assachusets @rinter +$0 I $+.0011H20H200( &oulard assachusets *ard drive %1 I ($.0011H20H200( >ulian 3hio *ard drive ,) I ($.0011H20H200( "arcia Te?as 5854:om +1+ I 0.$$11H21H200( itron ichigan *ard drive )%, I ($.0011H21H200( Gang California C54:om %0 I 0.2$11H21H200( Gang California C54:om +)( I 0.2$11H21H200( "arcia California Smart Card )() I 2$.)011H21H200( Smith California -eyboard )0+ I (.$011H21H200( Charlton California US& 5rive 1+% I 12.+$11H22H200( &rown 5akota C54:om 1% I 0.2$11H22H200( >ulian assachusets Smart Card )+1 I 2$.)011H22H200( itron California -eyboard ))2 I (.$011H22H200( itron =evada 5854:om )1+ I 0.$$11H22H200( &rown 5akota *ard drive // I ($.0011H22H200( &rown 5akota US& 5rive %+ I 12.+$11H2)H200( &rown assachusets *ard drive 1/0 I ($.0011H2)H200( &rown California US& 5rive +2 I 12.+$11H2)H200( Charlton Te?as 5854:om 22/ I 0.$$11H2)H200( Gokuchi assachusets *ard drive )$1 I ($.0011H2)H200( itron California -eyboard )0 I (.$011H2)H200( Gokuchi California C54:om 202 I 0.2$11H2)H200( Smith =evada 5854:om 2) I 0.$$11H2%H200( Gang 5akota C54:om +)( I 0.2$11H2(H200( Smith Te?as -eyboard +%2 I (.$011H2(H200( &oulard =evada @rinter 2%) I $+.0011H2(H200( Gokuchi 5akota -eyboard )/( I (.$011H2/H200( Gokuchi Te?as C54:om +)2 I 0.2$11H2/H200( Charlton ichigan US& 5rive )+/ I 12.+$11H2/H200( Gokuchi California @rinter )0% I $+.0011H2/H200( itron California 5854:om +() I 0.$$11H2/H200( Gokuchi 5akota C54:om 1,, I 0.2$11H2/H200( Smith assachusets C54:om ),% I 0.2$11H2/H200( Gang California Smart Card +0 I 2$.)011H2,H200( Charlton Te?as US& 5rive +1 I 12.+$11H2,H200( Smith California -eyboard )/) I (.$011H2,H200( Gang Te?as Smart Card 2$$ I 2$.)011H)0H200( &rown Alabama *ard drive +$ I ($.00

  • 8/17/2019 Aufgaben Excel Workshop (1)

    29/338

    11H)0H200( Gang Alabama Smart Card 1)$ I 2$.)011H)0H200( >ulian assachusets @rinter ))$ I $+.00

    12H)H200( "arcia assachusets Smart Card +)0 I 2$.)012H)H200( Gokuchi 3hio US& 5rive 1$ I 12.+$12H)H200( Charlton California -eyboard )21 I (.$012H+H200( >ulian Te?as *ard drive )1) I ($.0012H+H200( >ulian California US& 5rive 1(/ I 12.+$12H+H200( &oulard California US& 5rive +( I 12.+$12H+H200( Smith assachusets C54:om 11, I 0.2$12H+H200( Gokuchi Te?as @rinter +11 I $+.0012H+H200( &rown ichigan 5854:om 1%+ I 0.$$12H$H200( Smith California Smart Card +, I 2$.)012H$H200( &rown 3hio Smart Card %2 I 2$.)012H$H200( itron Alabama 5854:om +/0 I 0.$$12H$H200( "arcia Alabama 5854:om 22( I 0.$$12H$H200( "arcia Te?as *ard drive )+, I ($.0012H%H200( Gang California @rinter )% I $+.0012H%H200( &rown California @rinter 1%2 I $+.0012H%H200( "arcia California Smart Card +)) I 2$.)012H%H200( "arcia Te?as C54:om 10+ I 0.2$12H%H200( >ulian ichigan *ard drive ))% I ($.0012H%H200( "arcia ichigan C54:om +0, I 0.2$12H%H200( &oulard assachusets Smart Card +,% I 2$.)012H(H200( Smith Te?as 5854:om 1() I 0.$$12H(H200( &oulard California C54:om )/% I 0.2$

    12H11H200( &oulard Te?as 5854:om 2/2 I 0.$$12H11H200( "arcia California *ard drive )0 I ($.0012H11H200( &rown lorida -eyboard 2%0 I (.$012H11H200( Gang California Smart Card ),2 I 2$.)012H11H200( Gang assachusets @rinter /1 I $+.0012H12H200( Smith Te?as Smart Card %/0 I 2$.)012H12H200( Gang assachusets @rinter 1)0 I $+.0012H12H200( &rown lorida 5854:om 2$ I 0.$$12H12H200( Gang assachusets *ard drive 2,+ I ($.0012H1)H200( Charlton =evada -eyboard 2/2 I (.$012H1)H200( &rown assachusets US& 5rive 2/( I 12.+$12H1)H200( Charlton 5akota C54:om 1++ I 0.2$12H1)H200( Gokuchi assachusets -eyboard 1$$0 I (.$012H1)H200( "arcia Te?as US& 5rive )(1 I 12.+$12H1)H200( "arcia =evada @rinter )01 I $+.0012H1)H200( Smith =evada Smart Card 2)/ I 2$.)012H1)H200( "arcia lorida -eyboard 1( I (.$012H1+H200( &rown Te?as Smart Card 2/% I 2$.)012H1+H200( Gang California Smart Card +// I 2$.)012H1+H200( &oulard Te?as Smart Card 1,, I 2$.)012H1+H200( Smith California C54:om 1+ I 0.2$12H1(H200( &oulard assachusets *ard drive +0, I ($.0012H1(H200( &rown assachusets *ard drive /0 I ($.00

  • 8/17/2019 Aufgaben Excel Workshop (1)

    30/338

    12H1(H200( "arcia assachusets C54:om +++ I 0.2$12H1/H200( "arcia California Smart Card )2/ I 2$.)012H1/H200( &rown Te?as *ard drive /( I ($.0012H1/H200( &oulard California US& 5rive 2// I 12.+$12H1,H200( Charlton assachusets Smart Card )%+ I 2$.)012H1,H200( itron 5akota US& 5rive )%0 I 12.+$12H1,H200( Gokuchi 5akota Smart Card 20% I 2$.)012H1,H200( &rown assachusets US& 5rive )2( I 12.+$12H1,H200( &oulard assachusets *ard drive )2) I ($.0012H1,H200( itron assachusets US& 5rive 1)1 I 12.+$12H1,H200( Smith California 5854:om )/0 I 0.$$12H1,H200( Charlton Te?as *ard drive +(( I ($.0012H20H200( &oulard California US& 5rive 1+/ I 12.+$12H20H200( Gang Alabama *ard drive +(( I ($.0012H20H200( &oulard ichigan @rinter )// I $+.0012H20H200( Smith assachusets -eyboard ),) I (.$012H21H200( >ulian assachusets US& 5rive 20( I 12.+$12H21H200( "arcia Te?as *ard drive ),% I ($.0012H21H200( itron California C54:om 2(+ I 0.2$12H2+H200( "arcia California 5854:om +%1 I 0.$$12H2+H200( Gang =evada 5854:om ,% I 0.$$12H2$H200( "arcia 3hio *ard drive )0/ I ($.0012H2$H200( "arcia assachusets *ard drive 1%$ I ($.0012H2%H200( &rown California *ard drive $$ I ($.0012H2%H200( &rown California C54:om %, I 0.2$12H2%H200( Smith Alabama @rinter +2, I $+.0012H2%H200( &oulard Te?as -eyboard )/2 I (.$012H2(H200( &oulard Te?as Smart Card 1/0 I 2$.)012H2(H200( Smith Te?as *ard drive +1% I ($.0012H2(H200( Charlton lorida 5854:om 2$ I 0.$$12H2(H200( Smith assachusets *ard drive )/+ I ($.0012H2(H200( "arcia Te?as -eyboard ,) I (.$012H2(H200( itron California -eyboard 11+ I (.$012H2/H200( itron assachusets -eyboard 1/2 I (.$012H2/H200( Smith California -eyboard )/% I (.$012H2/H200( Gokuchi assachusets US& 5rive )(+ I 12.+$12H2/H200( Charlton California US& 5rive +,% I 12.+$12H2/H200( >ulian =evada @rinter 2)( I $+.0012H)1H200( Gokuchi 3hio @rinter 2$$ I $+.0012H)1H200( Charlton Te?as 5854:om ),0 I 0.$$12H)1H200( "arcia Te?as *ard drive 2$+ I ($.00

    1H1H200/ &rown assachusets Smart Card )/$ I 2$.)01H1H200/ "arcia assachusets C54:om )+1 I 0.2$1H1H200/ itron lorida -eyboard 1$+ I (.$01H2H200/ "arcia 5akota C54:om 2%2 I 0.2$1H2H200/ Gokuchi assachusets Smart Card ,$ I 2$.)01H2H200/ itron lorida @rinter 100 I $+.001H2H200/ Charlton 5akota -eyboard ),, I (.$0

  • 8/17/2019 Aufgaben Excel Workshop (1)

    31/338

    1H2H200/ Gokuchi Te?as @rinter 1%( I $+.001H2H200/ >ulian California Smart Card 12+ I 2$.)01H2H200/ >ulian lorida *ard drive )(+ I ($.001H2H200/ Gang Te?as -eyboard )(2 I (.$01H2H200/ &rown assachusets C54:om 1, I 0.2$1H2H200/ itron =evada Smart Card 1$2 I 2$.)01H2H200/ &oulard Alabama -eyboard 2(0 I (.$01H2H200/ >ulian 5akota *ard drive 1% I ($.001H2H200/ Charlton Alabama C54:om /+ I 0.2$1H)H200/ &oulard California @rinter +$1 I $+.001H)H200/ itron assachusets Smart Card +10 I 2$.)01H)H200/ &oulard California C54:om 1%) I 0.2$1H)H200/ "arcia Te?as *ard drive +,+ I ($.001H)H200/ itron 3hio 5854:om 2$ I 0.$$1H)H200/ Gokuchi lorida US& 5rive +(1 I 12.+$1H)H200/ itron assachusets C54:om )2$ I 0.2$1H+H200/ >ulian Te?as *ard drive 2)0 I ($.001H+H200/ Gang Alabama *ard drive 1(0 I ($.001H+H200/ &rown 5akota @rinter $( I $+.001H+H200/ Gokuchi 5akota *ard drive +(( I ($.001H(H200/ &rown California Smart Card 2+$ I 2$.)01H(H200/ Charlton California US& 5rive %2 I 12.+$1H(H200/ itron 5akota US& 5rive )/) I 12.+$1H/H200/ &oulard assachusets 5854:om +/% I 0.$$1H/H200/ Gokuchi Te?as @rinter ))% I $+.001H/H200/ Smith California @rinter +%% I $+.001H/H200/ Charlton California -eyboard %+ I (.$01H,H200/ Smith assachusets 5854:om ,$ I 0.$$1H,H200/ Gokuchi California US& 5rive 2)) I 12.+$1H,H200/ Gang California US& 5rive 1,/ I 12.+$1H,H200/ Charlton =evada Smart Card )) I 2$.)01H,H200/ &rown Alabama @rinter /% I $+.00

    1H10H200/ &rown Te?as Smart Card +%) I 2$.)01H10H200/ itron California @rinter 22) I $+.001H10H200/ &rown assachusets C54:om 11/ I 0.2$1H11H200/ itron 3hio C54:om )2, I 0.2$1H11H200/ &rown assachusets Smart Card )2$ I 2$.)01H11H200/ &oulard California *ard drive 1,/ I ($.001H11H200/ >ulian Alabama -eyboard +0( I (.$01H1+H200/ >ulian assachusets @rinter 1+/ I $+.001H1+H200/ &oulard assachusets -eyboard 2)/ I (.$01H1+H200/ itron ichigan US& 5rive 1,) I 12.+$1H1+H200/ itron assachusets 5854:om 1+, I 0.$$1H1+H200/ itron =evada 5854:om 222 I 0.$$1H1+H200/ &oulard ichigan US& 5rive ++2 I 12.+$1H1$H200/ >ulian Te?as -eyboard )1$ I (.$01H1$H200/ Gang California -eyboard ))% I (.$01H1$H200/ &oulard Te?as @rinter )( I $+.00

  • 8/17/2019 Aufgaben Excel Workshop (1)

    32/338

    1H1$H200/ &oulard ichigan @rinter )11 I $+.001H1%H200/ >ulian Te?as @rinter 22( I $+.001H1(H200/ Smith Te?as US& 5rive ),0 I 12.+$1H1(H200/ Gokuchi =evada US& 5rive 1/( I 12.+$1H1(H200/ Smith Te?as @rinter ,) I $+.001H1(H200/ itron 3hio Smart Card +0$ I 2$.)01H1/H200/ itron =evada -eyboard 2++ I (.$01H1/H200/ &oulard California 5854:om +$2 I 0.$$1H1/H200/ Charlton assachusets 5854:om )11 I 0.$$1H21H200/ >ulian ichigan C54:om 12 I 0.2$1H21H200/ Charlton California US& 5rive +2+ I 12.+$1H22H200/ itron lorida *ard drive )$2 I ($.001H22H200/ itron assachusets US& 5rive +$0 I 12.+$1H22H200/ &oulard =evada US& 5rive 2$$ I 12.+$1H2)H200/ Smith assachusets -eyboard +,( I (.$01H2)H200/ >ulian California -eyboard +%) I (.$01H2)H200/ >ulian ichigan Smart Card 1), I 2$.)01H2)H200/ "arcia Te?as @rinter ,) I $+.001H2)H200/ Smith Te?as 5854:om +2) I 0.$$1H2)H200/ Charlton ichigan Smart Card 2%+ I 2$.)01H2)H200/ &rown assachusets 5854:om () I 0.$$1H2+H200/ Gokuchi California C54:om 2%( I 0.2$1H2+H200/ Gokuchi California US& 5rive /, I 12.+$1H2+H200/ "arcia California -eyboard ))/ I (.$01H2+H200/ &oulard ichigan 5854:om %( I 0.$$1H2+H200/ >ulian assachusets *ard drive 1(% I ($.001H2+H200/ Smith California -eyboard )$/ I (.$01H2+H200/ Gang assachusets Smart Card (0 I 2$.)01H2+H200/ Smith California C54:om 1// I 0.2$1H2$H200/ Gokuchi Te?as *ard drive +2% I ($.001H2$H200/ &oulard California C54:om 22+ I 0.2$1H2$H200/ "arcia California C54:om )/1 I 0.2$1H2/H200/ Smith assachusets @rinter +(0 I $+.001H2/H200/ Smith Te?as C54:om ,0 I 0.2$1H2,H200/ Charlton Alabama @rinter /$ I $+.001H2,H200/ &rown Te?as US& 5rive 1,% I 12.+$1H)0H200/ "arcia 3hio -eyboard $2 I (.$01H)0H200/ Charlton California 5854:om 2/$ I 0.$$1H)0H200/ Charlton 5akota -eyboard )/( I (.$01H)0H200/ &oulard Te?as Smart Card +,% I 2$.)01H)0H200/ Gang Te?as Smart Card 2(, I 2$.)01H)0H200/ "arcia Te?as Smart Card 10 I 2$.)01H)0H200/ Charlton assachusets *ard drive 1,$ I ($.001H)0H200/ >ulian =evada C54:om )(/ I 0.2$1H)0H200/ Charlton Alabama *ard drive )0 I ($.001H)1H200/ &rown 3hio Smart Card +%+ I 2$.)01H)1H200/ Gokuchi Te?as *ard drive )(0 I ($.001H)1H200/ Gokuchi assachusets @rinter $0 I $+.00

  • 8/17/2019 Aufgaben Excel Workshop (1)

    33/338

    1H)1H200/ itron California *ard drive 1)1 I ($.002H1H200/ Charlton California Smart Card )1% I 2$.)02H1H200/ >ulian ichigan Smart Card 12% I 2$.)02H1H200/ Gang 3hio @rinter 21) I $+.002H1H200/ itron 5akota C54:om 2$, I 0.2$2H+H200/ Smith assachusets 5854:om $2 I 0.$$2H+H200/ Gang California 5854:om +,/ I 0.$$2H+H200/ Smith 3hio US& 5rive +2, I 12.+$2H+H200/ &rown California *ard drive )$% I ($.002H$H200/ &rown Te?as Smart Card )+1 I 2$.)02H%H200/ &oulard California @rinter ($ I $+.002H%H200/ Gokuchi Te?as Smart Card 10/ I 2$.)02H%H200/ >ulian Alabama US& 5rive $+ I 12.+$2H%H200/ Gang Te?as Smart Card +%+ I 2$.)02H(H200/ &oulard assachusets -eyboard )/, I (.$02H(H200/ Smith Te?as 5854:om )%% I 0.$$2H(H200/ Gokuchi ichigan @rinter 1/% I $+.002H/H200/ &oulard 3hio @rinter 2/$ I $+.002H/H200/ &rown Alabama -eyboard ,( I (.$02H/H200/ >ulian Te?as -eyboard 22% I (.$02H/H200/ >ulian Te?as -eyboard )/1 I (.$0

    2H11H200/ Charlton lorida 5854:om )/( I 0.$$2H11H200/ &oulard assachusets Smart Card )%0 I 2$.)02H11H200/ Charlton California @rinter ))) I $+.002H12H200/ "arcia California *ard drive $( I ($.002H1)H200/ Gokuchi 3hio @rinter 21 I $+.002H1)H200/ &rown 5akota Smart Card 1%( I 2$.)02H1)H200/ &rown California *ard drive 2,+ I ($.002H1)H200/ >ulian Te?as 5854:om $2 I 0.$$2H1+H200/ >ulian =evada C54:om +/( I 0.2$2H1+H200/ &rown Alabama *ard drive )$% I ($.002H1+H200/ &rown ichigan Smart Card )/ I 2$.)02H1+H200/ itron assachusets US& 5rive +(, I 12.+$2H1+H200/ Smith Te?as @rinter +%2 I $+.002H1$H200/ Gang California 5854:om 2)$ I 0.$$2H1$H200/ itron Te?as 5854:om )1, I 0.$$2H1/H200/ &rown assachusets US& 5rive 2,+ I 12.+$2H1/H200/ Charlton 5akota Smart Card +2 I 2$.)02H1,H200/ >ulian 3hio *ard drive $0 I ($.002H20H200/ &oulard California *ard drive +%% I ($.002H20H200/ Smith Te?as Smart Card 21+ I 2$.)02H20H200/ Charlton ichigan US& 5rive 1)$ I 12.+$2H20H200/ Smith Te?as 5854:om 2/, I 0.$$2H20H200/ Gokuchi 5akota US& 5rive 2/% I 12.+$2H20H200/ &rown assachusets @rinter 1)/ I $+.002H21H200/ Charlton California C54:om +$1 I 0.2$2H21H200/ Charlton California US& 5rive 1%% I 12.+$2H21H200/ >ulian lorida 5854:om +)0 I 0.$$

  • 8/17/2019 Aufgaben Excel Workshop (1)

    34/338

    2H21H200/ &rown lorida *ard drive )$$ I ($.002H21H200/ >ulian California Smart Card +1 I 2$.)02H21H200/ Gokuchi California *ard drive )(, I ($.002H21H200/ &oulard ichigan 5854:om )0, I 0.$$2H21H200/ itron California -eyboard 10/ I (.$02H22H200/ &rown Te?as 5854:om 1// I 0.$$2H2$H200/ Charlton Te?as C54:om 20) I 0.2$2H2$H200/ "arcia =evada *ard drive +0, I ($.002H2$H200/ itron assachusets *ard drive +($ I ($.002H2$H200/ >ulian assachusets @rinter )%/ I $+.002H2%H200/ >ulian California 5854:om 1,)0 I 0.$$2H2%H200/ >ulian assachusets Smart Card ,, I 2$.)02H2%H200/ &oulard California US& 5rive +$$ I 12.+$2H2%H200/ >ulian Te?as @rinter 2$$ I $+.002H2%H200/ Charlton Te?as 5854:om +1 I 0.$$2H2%H200/ &oulard Alabama @rinter 20) I $+.002H2%H200/ Charlton California @rinter +0) I $+.002H2(H200/ Smith California Smart Card +11 I 2$.)02H2(H200/ Gokuchi lorida @rinter )$2 I $+.002H2(H200/ Smith California *ard drive 21+ I ($.002H2(H200/ >ulian Te?as 5854:om )(% I 0.$$2H2(H200/ "arcia California 5854:om )$$ I 0.$$2H2/H200/ Gang California C54:om )// I 0.2$2H2/H200/ Gokuchi California -eyboard 20( I (.$02H2/H200/ Gokuchi Alabama -eyboard +2 I (.$02H2/H200/ Gang assachusets -eyboard 2)% I (.$02H2,H200/ itron California US& 5rive 20 I 12.+$2H2,H200/ &rown Te?as C54:om )00 I 0.2$2H2,H200/ Smith lorida -eyboard 10$ I (.$0

    )H+H200/ &oulard =evada 5854:om 2($ I 0.$$)H+H200/ &rown assachusets C54:om +(% I 0.2$)H+H200/ Gang =evada *ard drive )$( I ($.00)H+H200/ &rown Te?as C54:om ))+ I 0.2$)H$H200/ &oulard Te?as US& 5rive 2)0 I 12.+$)H$H200/ Smith Te?as @rinter +2/ I $+.00)H$H200/ Gokuchi Te?as @rinter 2)0 I $+.00)H$H200/ &oulard Te?as @rinter 2/+ I $+.00)H%H200/ Charlton California 5854:om +)1 I 0.$$)H%H200/ >ulian California *ard drive )+) I ($.00)H(H200/ &rown lorida -eyboard ,0 I (.$0

    )H10H200/ &oulard =evada US& 5rive 1%, I 12.+$)H10H200/ &oulard lorida @rinter )%2 I $+.00)H10H200/ Smith California US& 5rive )1 I 12.+$)H11H200/ &oulard assachusets -eyboard () I (.$0)H11H200/ &rown California @rinter 10, I $+.00)H11H200/ Smith =evada 5854:om 2,/ I 0.$$)H11H200/ Smith California US& 5rive )$% I 12.+$)H11H200/ &rown California 5854:om 2/$ I 0.$$

  • 8/17/2019 Aufgaben Excel Workshop (1)

    35/338

    )H12H200/ &rown Te?as *ard drive ), I ($.00)H12H200/ &rown 3hio *ard drive 2(+ I ($.00)H12H200/ Smith Te?as -eyboard (+ I (.$0)H12H200/ itron 3hio *ard drive 202 I ($.00)H12H200/ "arcia California 5854:om ),2 I 0.$$)H1)H200/ "arcia Te?as US& 5rive +$) I 12.+$)H1)H200/ &oulard Te?as @rinter ),, I $+.00)H1)H200/ &rown =evada US& 5rive +), I 12.+$)H1)H200/ itron lorida -eyboard )+1 I (.$0)H1)H200/ &rown Te?as C54:om 22( I 0.2$)H1)H200/ Charlton California -eyboard 201 I (.$0)H1)H200/ >ulian Te?as -eyboard 1)2 I (.$0)H1(H200/ Charlton Te?as US& 5rive 220 I 12.+$)H1(H200/ itron =evada -eyboard +,( I (.$0)H1(H200/ >ulian Te?as @rinter %1 I $+.00)H1/H200/ &rown lorida *ard drive +)( I ($.00)H1/H200/ >ulian lorida C54:om 2($ I 0.2$)H1,H200/ Gokuchi 5akota C54:om +$0 I 0.2$)H1,H200/ Smith assachusets C54:om ++% I 0.2$)H1,H200/ itron ichigan -eyboard 22% I (.$0)H20H200/ "arcia California -eyboard ))% I (.$0)H20H200/ >ulian Te?as 5854:om 2$$ I 0.$$)H20H200/ itron Alabama -eyboard 2+% I (.$0)H20H200/ Charlton Alabama C54:om 1) I 0.2$)H20H200/ itron Te?as 5854:om +2, I 0.$$)H20H200/ &oulard =evada -eyboard 1,$ I (.$0)H20H200/ >ulian assachusets 5854:om 11( I 0.$$)H20H200/ &oulard Te?as @rinter 2/( I $+.00)H20H200/ "arcia Alabama US& 5rive 12$ I 12.+$)H21H200/ itron ichigan US& 5rive +2) I 12.+$)H2+H200/ &oulard assachusets *ard drive )$1 I ($.00)H2$H200/ itron Te?as @rinter ),0 I $+.00)H2$H200/ "arcia Te?as 5854:om +%0 I 0.$$)H2$H200/ itron Alabama -eyboard 1, I (.$0)H2%H200/ Charlton Te?as -eyboard ))/ I (.$0)H2%H200/ Smith 3hio C54:om +(/ I 0.2$)H2%H200/ Gokuchi 5akota @rinter )(/ I $+.00)H2%H200/ &oulard California C54:om +)% I 0.2$)H2%H200/ "arcia assachusets C54:om 100 I 0.2$)H2%H200/ Smith assachusets C54:om 1,$ I 0.2$)H2%H200/ Gokuchi lorida Smart Card 21 I 2$.)0)H2%H200/ Charlton Te?as -eyboard 2+) I (.$0)H2(H200/ Charlton =evada US& 5rive 2%+ I 12.+$)H2(H200/ Smith California @rinter 1%0 I $+.00)H2(H200/ Gokuchi Alabama -eyboard 20( I (.$0)H2(H200/ &oulard Te?as Smart Card +$+ I 2$.)0)H2/H200/ Gokuchi ichigan US& 5rive 22$ I 12.+$)H)1H200/ Smith assachusets @rinter +$/ I $+.00

  • 8/17/2019 Aufgaben Excel Workshop (1)

    36/338

    )H)1H200/ &oulard Te?as *ard drive )% I ($.00)H)1H200/ Gokuchi assachusets 5854:om 2/2 I 0.$$)H)1H200/ &oulard California Smart Card 1%2 I 2$.)0

    +H1H200/ Charlton assachusets *ard drive /% I ($.00+H1H200/ &rown California US& 5rive 2)/ I 12.+$+H1H200/ &rown Te?as -eyboard 2(0 I (.$0+H2H200/ Smith Te?as 5854:om ),( I 0.$$+H2H200/ &oulard Te?as C54:om +(0 I 0.2$+H2H200/ &rown Te?as @rinter 2,( I $+.00+H)H200/ &rown Te?as Smart Card 22+ I 2$.)0+H)H200/ "arcia California US& 5rive 22, I 12.+$+H)H200/ "arcia assachusets US& 5rive )0/ I 12.+$+H)H200/ "arcia lorida @rinter 1+1 I $+.00+H+H200/ Charlton Te?as Smart Card 202 I 2$.)0+H+H200/ itron Te?as -eyboard ++/ I (.$0+H+H200/ >ulian 3hio 5854:om /, I 0.$$+H(H200/ >ulian Te?as C54:om 2% I 0.2$+H(H200/ >ulian lorida 5854:om ))/ I 0.$$+H(H200/ Gang Te?as Smart Card 1$$ I 2$.)0+H/H200/ &oulard Te?as Smart Card +0/ I 2$.)0+H/H200/ Gang California *ard drive 1)) I ($.00+H/H200/ >ulian assachusets @rinter +%) I $+.00+H,H200/ "arcia California Smart Card +22 I 2$.)0+H,H200/ Gokuchi assachusets Smart Card +%2 I 2$.)0+H,H200/ Gang 3hio @rinter 2() I $+.00+H,H200/ Charlton ichigan Smart Card 2+ I 2$.)0

    +H10H200/ >ulian Te?as Smart Card 1)$0 I 2$.)0+H10H200/ Gang California *ard drive )(% I ($.00+H10H200/ &rown 3hio 5854:om // I 0.$$+H10H200/ Gang 5akota -eyboard 1)) I (.$0+H10H200/ Gang California -eyboard 1)/ I (.$0+H10H200/ &oulard Te?as Smart Card 2,1 I 2$.)0+H10H200/ "arcia Te?as -eyboard 2/) I (.$0+H10H200/ Gang Alabama US& 5rive 1)2 I 12.+$+H10H200/ Smith lorida C54:om )/+ I 0.2$+H11H200/ "arcia lorida -eyboard +$ I (.$0+H11H200/ Gang Te?as @rinter )(+ I $+.00+H11H200/ itron Te?as -eyboard ++( I (.$0+H11H200/ Smith =evada 5854:om 12 I 0.$$+H11H200/ &rown assachusets US& 5rive ),( I 12.+$+H11H200/ Gang assachusets 5854:om 1%$ I 0.$$+H11H200/ &oulard assachusets Smart Card +21 I 2$.)0+H11H200/ itron =evada C54:om 22% I 0.2$+H1+H200/ Gang ichigan 5854:om )+ I 0.$$+H1+H200/ Smith assachusets US& 5rive +,, I 12.+$+H1+H200/ &rown 3hio 5854:om )2) I 0.$$+H1+H200/ Charlton =evada 5854:om )$1 I 0.$$+H1$H200/ Gang assachusets Smart Card /) I 2$.)0

  • 8/17/2019 Aufgaben Excel Workshop (1)

    37/338

  • 8/17/2019 Aufgaben Excel Workshop (1)

    38/338

    $H$H200/ itron assachusets @rinter )$ I $+.00$H%H200/ Gang Te?as -eyboard 1+, I (.$0$H%H200/ Charlton Alabama *ard drive 21( I ($.00$H(H200/ Charlton Te?as @rinter +%$ I $+.00$H(H200/ itron =evada @rinter 1+) I $+.00$H(H200/ &oulard Te?as -eyboard ))+ I (.$0$H(H200/ >ulian lorida 5854:om )(1 I 0.$$$H(H200/ Charlton assachusets -eyboard 21/ I (.$0$H/H200/ Gokuchi assachusets -eyboard )01 I (.$0$H/H200/ Smith =evada 5854:om 20% I 0.$$$H/H200/ &rown 3hio Smart Card 1)0 I 2$.)0$H/H200/ Gang =evada @rinter +,( I $+.00$H/H200/ Smith Te?as 5854:om $) I 0.$$$H,H200/ &oulard California Smart Card 10/ I 2$.)0$H,H200/ itron Te?as C54:om 1,) I 0.2$$H,H200/ &rown 3hio Smart Card 20) I 2$.)0$H,H200/ "arcia assachusets 5854:om 22, I 0.$$$H,H200/ Gokuchi lorida Smart Card 21( I 2$.)0

    $H12H200/ itron 5akota Smart Card +/ I 2$.)0$H12H200/ >ulian Te?as 5854:om (0 I 0.$$$H12H200/ >ulian assachusets @rinter 21+ I $+.00$H12H200/ Gokuchi assachusets 5854:om )(0 I 0.$$$H12H200/ itron Te?as *ard drive 22) I ($.00$H1)H200/ Smith lorida US& 5rive 2%1 I 12.+$$H1)H200/ Charlton lorida -eyboard 1$2 I (.$0$H1)H200/ >ulian =evada C54:om 1/+ I 0.2$$H1+H200/ Smith 3hio -eyboard 211 I (.$0$H1+H200/ "arcia Te?as C54:om 2/ I 0.2$$H1+H200/ Charlton 3hio @rinter +0$ I $+.00$H1+H200/ Gang Te?as @rinter $0 I $+.00$H1+H200/ >ulian California US& 5rive 1,1 I 12.+$$H1$H200/ >ulian Te?as 5854:om 10 I 0.$$$H1$H200/ Smith Te?as C54:om +1, I 0.2$$H1$H200/ Gokuchi assachusets @rinter )%0 I $+.00$H1$H200/ &oulard 3hio *ard drive +/% I ($.00$H1$H200/ >ulian assachusets Smart Card %0 I 2$.)0$H1%H200/ "arcia California 5854:om )/$ I 0.$$$H1%H200/ Charlton Alabama -eyboard $/ I (.$0$H1,H200/ Gang 5akota @rinter $10 I $+.00$H1,H200/ Gokuchi California 5854:om 10,0 I 0.$$$H1,H200/ Gokuchi California 5854:om +,+ I 0.$$$H1,H200/ >ulian lorida -eyboard +%) I (.$0$H20H200/ Charlton California @rinter )%$ I $+.00$H20H200/ Charlton Te?as -eyboard 2($ I (.$0$H21H200/ Charlton =evada 5854:om +,( I 0.$$$H21H200/ Gokuchi lorida Smart Card %( I 2$.)0$H21H200/ >ulian assachusets @rinter ++/ I $+.00$H21H200/ Gang Te?as -eyboard 2)( I (.$0

  • 8/17/2019 Aufgaben Excel Workshop (1)

    39/338

    $H21H200/ &rown California -eyboard )() I (.$0$H22H200/ Gang California Smart Card 2/, I 2$.)0$H22H200/ Charlton 3hio US& 5rive 2,) I 12.+$$H22H200/ Charlton Alabama US& 5rive +$) I 12.+$$H22H200/ Gang Te?as -eyboard (/ I (.$0$H2)H200/ Gokuchi California C54:om +(+ I 0.2$$H2)H200/ itron 5akota 5854:om +,$ I 0.$$$H2%H200/ "arcia Te?as @rinter 2$) I $+.00$H2%H200/ Gang California *ard drive 2+/ I ($.00$H2%H200/ Smith lorida C54:om 2$$ I 0.2$$H2(H200/ Smith ichigan 5854:om )22 I 0.$$$H2(H200/ &oulard Te?as Smart Card 2() I 2$.)0$H2/H200/ Gang Te?as 5854:om /0 I 0.$$$H2/H200/ &rown =evada C54:om 20( I 0.2$$H2/H200/ Gang 5akota C54:om 12$ I 0.2$$H2/H200/ &rown assachusets US& 5rive +1, I 12.+$$H2/H200/ &oulard =evada 5854:om 101 I 0.$$$H2,H200/ &rown California Smart Card +,) I 2$.)0$H2,H200/ &rown Te?as -eyboard )($ I (.$0$H2,H200/ Gokuchi assachusets Smart Card /% I 2$.)0$H2,H200/ >ulian ichigan @rinter 1%1 I $+.00$H2,H200/ &rown assachusets Smart Card )22 I 2$.)0$H2,H200/ itron Te?as 5854:om 12( I 0.$$$H2,H200/ Gokuchi California C54:om +++ I 0.2$$H)0H200/ Smith Te?as 5854:om 2+$ I 0.$$$H)0H200/ >ulian 5akota @rinter 2$, I $+.00$H)0H200/ >ulian assachusets 5854:om 2)1 I 0.$$$H)0H200/ Smith California @rinter 1+( I $+.00

    %H2H200/ "arcia assachusets -eyboard +0, I (.$0%H2H200/ Charlton assachusets US& 5rive 2%0 I 12.+$%H)H200/ Charlton Te?as 5854:om 10) I 0.$$%H)H200/ Gang California C54:om 20$ I 0.2$%H)H200/ itron California C54:om 2$$ I 0.2$%H)H200/ Charlton ichigan *ard drive 2)1 I ($.00%H)H200/ "arcia Te?as -eyboard +0, I (.$0%H+H200/ &rown Te?as *ard drive 20 I ($.00%H+H200/ >ulian assachusets -eyboard ),( I (.$0%H+H200/ Charlton Te?as US& 5rive (, I 12.+$%H+H200/ &rown assachusets *ard drive 1++ I ($.00%H$H200/ Smith California *ard drive 21$ I ($.00%H$H200/ &rown California C54:om 1%% I 0.2$%H$H200/ Gokuchi 5akota @rinter $+ I $+.00%H$H200/ >ulian ichigan Smart Card ++$ I 2$.)0%H$H200/ &oulard ichigan *ard drive 112 I ($.00%H%H200/ >ulian Te?as US& 5rive +/) I 12.+$%H%H200/ Gang Te?as Smart Card 2), I 2$.)0%H%H200/ Gokuchi Alabama US& 5rive 2/+ I 12.+$%H,H200/ &rown ichigan -eyboard )1+ I (.$0

  • 8/17/2019 Aufgaben Excel Workshop (1)

    40/338

    %H,H200/ &rown lorida *ard drive 1(% I ($.00%H10H200/ &rown Te?as -eyboard 2) I (.$0%H10H200/ itron assachusets US& 5rive 1%, I 12.+$%H11H200/ Gang assachusets *ard drive +// I ($.00%H11H200/ "arcia California 5854:om %) I 0.$$%H11H200/ Gang Alabama Smart Card )( I 2$.)0%H11H200/ &rown 3hio @rinter 1+, I $+.00%H11H200/ >ulian California Smart Card 2+) I 2$.)0%H11H200/ Gang California *ard drive ,/ I ($.00%H12H200/ itron California US& 5rive 22, I 12.+$%H12H200/ Charlton 3hio @rinter )1% I $+.00%H12H200/ Gokuchi California *ard drive ,1 I ($.00%H12H200/ Gokuchi assachusets -eyboard 21( I (.$0%H12H200/ >ulian 5akota @rinter 20+ I $+.00%H12H200/ "arcia ichigan @rinter 2%$ I $+.00%H1)H200/ Gokuchi assachusets *ard drive 1)/ I ($.00%H1)H200/ &rown California *ard drive )2+ I ($.00%H1%H200/ >ulian assachusets @rinter 12 I $+.00%H1%H200/ Gang assachusets US& 5rive )%2 I 12.+$%H1%H200/ "arcia assachusets @rinter 2+0 I $+.00%H1(H200/ >ulian Te?as C54:om )+1 I 0.2$%H1(H200/ itron Te?as @rinter $2 I $+.00%H1(H200/ "arcia California Smart Card 2+, I 2$.)0%H1/H200/ >ulian California Smart Card 1,0 I 2$.)0%H1/H200/ "arcia California C54:om 1$0 I 0.2$%H1/H200/ Gang lorida Smart Card %2 I 2$.)0%H1/H200/ >ulian lorida Smart Card +0$ I 2$.)0%H1/H200/ Gokuchi assachusets C54:om )$) I 0.2$%H1/H200/ itron Te?as @rinter )0, I $+.00%H1/H200/ >ulian Te?as *ard drive )// I ($.00%H1,H200/ itron Te?as C54:om )(% I 0.2$%H1,H200/ &oulard =evada C54:om 11+ I 0.2$%H1,H200/ >ulian =evada US& 5rive 20 I 12.+$%H1,H200/ Charlton 5akota C54:om 1+0 I 0.2$%H20H200/ Smith California @rinter ,, I $+.00%H20H200/ itron California C54:om 2+% I 0.2$%H2)H200/ itron 5akota -eyboard +)( I (.$0%H2)H200/ Charlton assachusets US& 5rive 10$ I 12.+$%H2)H200/ >ulian Te?as C54:om +10 I 0.2$%H2+H200/ Gang Te?as 5854:om +(1 I 0.$$%H2+H200/ "arcia lorida *ard drive +0 I ($.00%H2$H200/ Smith California *ard drive 2)2 I ($.00%H2$H200/ "arcia assachusets US& 5rive 2%0 I 12.+$%H2$H200/ Gokuchi 3hio US& 5rive 2+0 I 12.+$%H2%H200/ Gang California C54:om 1(/ I 0.2$%H2%H200/ Gokuchi assachusets Smart Card )1% I 2$.)0%H2%H200/ Gokuchi Te?as US& 5rive ++/ I 12.+$%H2%H200/ Gokuchi 3hio Smart Card 2,0 I 2$.)0

  • 8/17/2019 Aufgaben Excel Workshop (1)

    41/338

    %H2%H200/ itron California @rinter )%( I $+.00%H2%H200/ Charlton California C54:om 1%0 I 0.2$%H2(H200/ &oulard assachusets C54:om 21$ I 0.2$%H2(H200/ Gang Te?as US& 5rive 22, I 12.+$%H2(H200/ itron 5akota @rinter +/) I $+.00%H)0H200/ "arcia Te?as US& 5rive )0 I 12.+$%H)0H200/ &oulard California Smart Card ),2 I 2$.)0%H)0H200/ Gang Te?as US& 5rive +02 I 12.+$%H)0H200/ Smith lorida @rinter )$/ I $+.00%H)0H200/ Smith California -eyboard ++% I (.$0%H)0H200/ Smith Te?as @rinter +1% I $+.00

    (H1H200/ itron assachusets Smart Card )$/ I 2$.)0(H1H200/ &oulard California C54:om +%/ I 0.2$(H1H200/ itron assachusets Smart Card +() I 2$.)0(H1H200/ &rown Te?as 5854:om )/% I 0.$$(H1H200/ "arcia California -eyboard )10 I (.$0(H2H200/ Charlton Te?as *ard drive 2)( I ($.00(H2H200/ Charlton assachusets US& 5rive 2/( I 12.+$(H2H200/ itron assachusets Smart Card +2) I 2$.)0(H2H200/ Gang assachusets Smart Card )%$ I 2$.)0(H)H200/ Gang assachusets C54:om 1$/ I 0.2$(H)H200/ &rown Te?as @rinter ++% I $+.00(H)H200/ itron Te?as C54:om +/% I 0.2$(H)H200/ Gang Te?as *ard drive 1,% I ($.00(H)H200/ >ulian assachusets -eyboard ,$ I (.$0(H)H200/ itron California *ard drive 2,1 I ($.00(H)H200/ &rown 3hio 5854:om 22( I 0.$$(H)H200/ &oulard California Smart Card 1)0 I 2$.)0(H)H200/ &rown assachusets @rinter )2/ I $+.00(H)H200/ &oulard California *ard drive $/ I ($.00(H+H200/ Gokuchi Te?as C54:om 2+% I 0.2$(H(H200/ &oulard assachusets 5854:om 2/+ I 0.$$(H/H200/ Charlton Te?as -eyboard %0 I (.$0(H/H200/ >ulian =evada @rinter %) I $+.00(H,H200/ "arcia =evada Smart Card 1(1 I 2$.)0(H,H200/ Gang Te?as *ard drive 21) I ($.00(H,H200/ &oulard Te?as Smart Card 10/ I 2$.)0(H,H200/ Smith assachusets @rinter 101 I $+.00

    (H10H200/ &rown assachusets US& 5rive 2$0 I 12.+$(H10H200/ Smith Te?as @rinter 2/, I $+.00(H10H200/ &rown =evada @rinter 22/ I $+.00(H11H200/ &rown assachusets *ard drive 1%% I ($.00(H11H200/ Charlton California @rinter ,+ I $+.00(H11H200/ Gokuchi California @rinter 10, I $+.00(H1+H200/ &oulard Te?as -eyboard 1)%0 I (.$0(H1+H200/ Charlton Te?as @rinter 1)0 I $+.00(H1$H200/ >ulian =evada C54:om 2+/ I 0.2$(H1$H200/ >ulian California Smart Card +)) I 2$.)0

  • 8/17/2019 Aufgaben Excel Workshop (1)

    42/338

    (H1$H200/ Charlton Te?as US& 5rive +1/ I 12.+$(H1%H200/ Gang Te?as Smart Card )11 I 2$.)0(H1%H200/ &rown Te?as 5854:om 1$, I 0.$$(H1%H200/ &oulard Alabama @rinter 11, I $+.00(H1%H200/ >ulian California C54:om +// I 0.2$(H1%H200/ Gang =evada *ard drive +%) I ($.00(H1%H200/ Gokuchi Te?as @rinter 11$ I $+.00(H1%H200/ Charlton Te?as US& 5rive +$+ I 12.+$(H1(H200/ Charlton ichigan Smart Card +$2 I 2$.)0(H1(H200/ Gang Te?as -eyboard 2$2 I (.$0(H1(H200/ Charlton Te?as @rinter )/( I $+.00(H1(H200/ Smith California US& 5rive 2/$ I 12.+$(H1(H200/ "arcia =evada US& 5rive +), I 12.+$(H1(H200/ Smith =evada 5854:om 12, I 0.$$(H1(H200/ &rown assachusets 5854:om )11 I 0.$$(H1(H200/ &rown Te?as *ard drive ))$ I ($.00(H1(H200/ Smith assachusets Smart Card 112 I 2$.)0(H1(H200/ "arcia Alabama C54:om 1(% I 0.2$(H1/H200/ &rown assachusets -eyboard 1)$ I (.$0(H1/H200/ "arcia =evada -eyboard )2$ I (.$0(H1/H200/ Charlton California 5854:om ++, I 0.$$(H22H200/ Gang assachusets C54:om )/1 I 0.2$(H2)H200/ Gang Te?as *ard drive 1/, I ($.00(H2)H200/ &rown assachusets Smart Card )1/ I 2$.)0(H2)H200/ Smith assachusets *ard drive )/, I ($.00(H2)H200/ >ulian =evada @rinter )0$ I $+.00(H2)H200/ &oulard California Smart Card )20 I 2$.)0(H2)H200/ "arcia assachusets US& 5rive 22$ I 12.+$(H2)H200/ Gokuchi assachusets C54:om $0 I 0.2$(H2+H200/ Gokuchi 5akota Smart Card 122 I 2$.)0(H2+H200/ "arcia lorida @rinter 222 I $+.00(H2+H200/ "arcia lorida Smart Card 20( I 2$.)0(H2+H200/ &oulard Te?as Smart Card $% I 2$.)0(H2$H200/ &oulard ichigan Smart Card 22, I 2$.)0(H2$H200/ Gang assachusets Smart Card 2,0 I 2$.)0(H2$H200/ Smith Te?as 5854:om 2+$ I 0.$$(H2$H200/ &rown =evada C54:om $0 I 0.2$(H2/H200/ itron 3hio Smart Card 1/1 I 2$.)0(H2/H200/ Charlton ichigan *ard drive 2/$ I ($.00(H2/H200/ &rown =evada @rinter 2(2 I $+.00(H2,H200/ "arcia Te?as @rinter 2)2 I $+.00(H2,H200/ &rown assachusets Smart Card )/0 I 2$.)0(H)0H200/ Charlton Te?as 5854:om )0$ I 0.$$(H)0H200/ "arcia Te?as US& 5rive /) I 12.+$(H)0H200/ &rown California Smart Card ))0 I 2$.)0(H)0H200/ "arcia assachusets Smart Card 220 I 2$.)0(H)1H200/ >ulian =evada -eyboard +1$ I (.$0(H)1H200/ >ulian Te?as C54:om )(0 I 0.2$

  • 8/17/2019 Aufgaben Excel Workshop (1)

    43/338

    (H)1H200/ Charlton =evada US& 5rive $, I 12.+$(H)1H200/ Smith ichigan @rinter )1) I $+.00

    /H1H200/ Smith Alabama 5854:om 10) I 0.$$/H1H200/ &rown ichigan C54:om )2/ I 0.2$/H1H200/ itron California @rinter )1/ I $+.00/H+H200/ Charlton 5akota C54:om 21+ I 0.2$/H+H200/ &oulard California 5854:om 11+ I 0.$$/H+H200/ Gang Te?as -eyboard +1% I (.$0/H+H200/ &oulard California Smart Card 1($ I 2$.)0/H+H200/ Gang California US& 5rive 111 I 12.+$/H$H200/ Charlton Te?as -eyboard +1) I (.$0/H$H200/ itron California @rinter )0% I $+.00/H$H200/ itron assachusets US& 5rive )// I 12.+$/H%H200/ &rown California US& 5rive +%+ I 12.+$/H%H200/ Charlton assachusets C54:om )(1 I 0.2$/H%H200/ &oulard California US& 5rive +), I 12.+$/H%H200/ Gokuchi assachusets @rinter 1%1 I $+.00/H%H200/ itron California US& 5rive 120 I 12.+$/H%H200/ Gang assachusets C54:om +(+ I 0.2$/H%H200/ &oulard Te?as @rinter 1$+ I $+.00/H%H200/ Smith assachusets *ard drive 2/) I ($.00/H(H200/ Gang California *ard drive 220 I ($.00/H(H200/ Gokuchi California C54:om +2/ I 0.2$/H(H200/ "arcia California *ard drive 1%+ I ($.00/H/H200/ &rown California *ard drive )0, I ($.00/H/H200/ itron =evada C54:om /% I 0.2$/H/H200/ &oulard assachusets Smart Card ),+ I 2$.)0

    /H11H200/ itron Te?as 5854:om 2$) I 0.$$/H11H200/ Gang Alabama US& 5rive )21 I 12.+$/H11H200/ itron lorida 5854:om 2/1 I 0.$$/H12H200/ "arcia Te?as 5854:om 21 I 0.$$/H1)H200/ Gang California Smart Card +1) I 2$.)0/H1)H200/ >ulian California -eyboard 1$$ I (.$0/H1)H200/ &oulard California US& 5rive 202 I 12.+$/H1)H200/ "arcia California 5854:om %1 I 0.$$/H1+H200/ &rown Te?as -eyboard 1( I (.$0/H1+H200/ &oulard assachusets Smart Card +$( I 2$.)0/H1+H200/ Gang Te?as 5854:om 1$+ I 0.$$/H1+H200/ Gang Te?as Smart Card (, I 2$.)0/H1$H200/ Smith ichigan Smart Card +1 I 2$.)0/H1$H200/ Gang California C54:om +$0 I 0.2$/H1$H200/ "arcia California @rinter 1%2 I $+.00/H1$H200/ Smith California 5854:om +/( I 0.$$/H1/H200/ Smith ichigan Smart Card +1% I 2$.)0/H1/H200/ itron California *ard drive )) I ($.00/H1/H200/ "arcia 3hio *ard drive ++$ I ($.00/H1,H200/ Smith assachusets 5854:om 1(( I 0.$$/H1,H200/ Smith California 5854:om 21/ I 0.$$

  • 8/17/2019 Aufgaben Excel Workshop (1)

    44/338

    /H1,H200/ Smith assachusets 5854:om 2(1 I 0.$$/H20H200/ &rown =evada C54:om )1 I 0.2$/H20H200/ &oulard Te?as 5854:om +(% I 0.$$/H20H200/ Gang California C54:om /% I 0.2$/H20H200/ Smith assachusets @rinter 21( I $+.00/H20H200/ itron Alabama *ard drive +$ I ($.00/H21H200/ "arcia =evada 5854:om ),$ I 0.$$/H21H200/ "arcia Te?as @rinter 2(/ I $+.00/H22H200/ >ulian 5akota -eyboard 1/2 I (.$0/H2$H200/ itron assachusets *ard drive 110 I ($.00/H2$H200/ Gokuchi California Smart Card ),) I 2$.)0/H2$H200/ "arcia Te?as 5854:om 1%1 I 0.$$/H2$H200/ >ulian ichigan *ard drive +)% I ($.00/H2$H200/ Gang California 5854:om )0$ I 0.$$/H2%H200/ &rown Te?as C54:om +(2 I 0.2$/H2%H200/ &rown assachusets US& 5rive 2++ I 12.+$/H2%H200/ >ulian Te?as *ard drive ))% I ($.00/H2%H200/ "arcia California @rinter +/2 I $+.00/H2(H200/ Smith California -eyboard 1)2 I (.$0/H2(H200/ Smith Te?as C54:om +1) I 0.2$/H2(H200/ &oulard California US& 5rive 2+/ I 12.+$/H2(H200/ Gokuchi =evada *ard drive 2( I ($.00/H2(H200/ &rown Alabama US& 5rive 2(/ I 12.+$/H2(H200/ Smith 5akota -eyboard 12+ I (.$0/H2(H200/ >ulian assachusets *ard drive 1$, I ($.00/H2(H200/ itron lorida US& 5rive )/( I 12.+$/H2/H200/ itron 3hio *ard drive 2+2 I ($.00/H2/H200/ itron assachusets *ard drive 2$( I ($.00/H2/H200/ Gang Alabama @rinter +)% I $+.00/H2/H200/ &oulard California -eyboard 12)0 I (.$0/H2/H200/ &rown Te?as 5854:om 1+0 I 0.$$/H2/H200/ &rown lorida Smart Card 201 I 2$.)0/H2/H200/ Charlton California *ard drive 2,1 I ($.00/H2,H200/ &rown California Smart Card +11 I 2$.)0/H2,H200/ &oulard 5akota US& 5rive +%) I 12.+$/H2,H200/ Gokuchi California C54:om +1( I 0.2$

    ,H1H200/ &oulard Te?as C54:om )2) I 0.2$,H2H200/ &rown California C54:om )1+ I 0.2$,H2H200/ >ulian lorida -eyboard 1+ I (.$0,H)H200/ Gang =evada *ard drive 10+ I ($.00,H)H200/ Gang ichigan @rinter (, I $+.00,H)H200/ "arcia California Smart Card /( I 2$.)0,H)H200/ >ulian California *ard drive +)% I ($.00,H)H200/ Charlton Alabama *ard drive )0+ I ($.00,H+H200/ Gang Alabama US& 5rive 1(00 I 12.+$,H+H200/ Charlton assachusets C54:om 1)10 I 0.2$,H+H200/ &oulard assachusets US& 5rive 2) I 12.+$,H+H200/ Gokuchi 5akota 5854:om 1,1 I 0.$$

  • 8/17/2019 Aufgaben Excel Workshop (1)

    45/338

    ,H+H200/ &rown Te?as -eyboard 1/, I (.$0,H+H200/ Smith Te?as US& 5rive 1$+ I 12.+$,H+H200/ Charlton 3hio @rinter 1%+ I $+.00,H$H200/ Gokuchi =evada US& 5rive )% I 12.+$,H$H200/ Gang California -eyboard ++/ I (.$0,H$H200/ >ulian California 5854:om ++1 I 0.$$,H/H200/ "arcia Te?as Smart Card )0 I 2$.)0,H/H200/ Gokuchi 3hio 5854:om 11$ I 0.$$,H/H200/ &oulard 3hio US& 5rive 210 I 12.+$,H/H200/ itron assachusets C54:om )1$ I 0.2$,H,H200/ Gang Te?as *ard drive +$$ I ($.00,H,H200/ Gokuchi Te?as -eyboard )0% I (.$0,H,H200/ &oulard Alabama -eyboard 2%$ I (.$0

    ,H10H200/ Gang Te?as Smart Card 2$0 I 2$.)0,H10H200/ "arcia California @rinter )%$ I $+.00,H10H200/ &rown Te?as -eyboard )0+ I (.$0,H10H200/ >ulian assachusets Smart Card )00 I 2$.)0,H10H200/ Charlton California Smart Card 2+0 I 2$.)0,H11H200/ Gang assachusets 5854:om 1+( I 0.$$,H11H200/ Gokuchi Te?as -eyboard )2, I (.$0,H11H200/ Gang assachusets Smart Card 2) I 2$.)0,H11H200/ Gang California @rinter )$ I $+.00,H11H200/ >ulian =evada @rinter )(+ I $+.00,H11H200/ Charlton Te?as *ard drive +)+ I ($.00,H12H200/ "arcia Te?as -eyboard ),( I (.$0,H12H200/ Smith lorida C54:om $/ I 0.2$,H12H200/ Charlton Te?as @rinter $% I $+.00,H12H200/ &oulard California -eyboard +%0 I (.$0,H12H200/ Smith Alabama -eyboard +0$ I (.$0,H12H200/ Gang California C54:om +$( I 0.2$,H12H200/ Charlton California Smart Card 1%0 I 2$.)0,H12H200/ "arcia California 5854:om 21+ I 0.$$,H12H200/ &rown 3hio US& 5rive 1(/ I 12.+$,H1$H200/ Gokuchi Te?as C54:om +%) I 0.2$,H1$H200/ Gokuchi California 5854:om +,% I 0.$$,H1$H200/ "arcia =evada *ard drive 1+( I ($.00,H1%H200/ >ulian California 5854:om 1,( I 0.$$,H1%H200/ Gokuchi California -eyboard +10 I (.$0,H1%H200/ Charlton assachusets C54:om 2(/ I 0.2$,H1(H200/ &oulard assachusets US& 5rive +21 I 12.+$,H1(H200/ Charlton assachusets US& 5rive 101 I 12.+$,H1/H200/ itron California *ard drive 1,( I ($.00,H1/H200/ "arcia lorida @rinter 1$1 I $+.00,H1/H200/ Gang =evada -eyboard )1( I (.$0,H1/H200/ &oulard =evada US& 5rive 2+$ I 12.+$,H1/H200/ >ulian Alabama @rinter )(/ I $+.00,H1/