excel assignment

profilecloud342
A1_MacysDeptStore1.xlsx

RawData

empFirst empLast rank department sales hours
Dorian Santana S2 Juniors $4,058.62 17
Quyn Ryan S2 Shoes $3,431.16 17
Lucian Hendrix AM Infants $9,200.22 32
Maryam Wright PT1 Juniors $3,615.60 37
Florence Terry S2 Mens $4,811.53 13
Grant Ballard PT1 Mens $2,907.98 25
Zelda Riley PT1 Childrens $4,123.00 22
Dacey Gilmore PT1 Womens $1,700.83 16
Sacha Short S1 Mens $4,840.11 28
Burke Carrillo PT2 Cosmetics $5,071.97 34
Phoebe Combs PT2 Shoes $4,208.62 28
Lacey Rosario S2 Juniors $5,082.76 31
Ori Sargent AM Housewares $5,741.27 15
Maggie England PT1 Childrens $2,621.92 16
Sandra George PT1 Cosmetics $1,556.65 16
Fay Meadows S2 Housewares $5,536.79 31
Jameson Salinas PT2 Cosmetics $4,191.60 30
Gretchen Diaz S1 Mens $5,387.26 36
Ursula Mann PT1 Mens $4,127.78 22
Laith Klein PT2 Mens $5,107.61 31
Freya Garrison AM Shoes $9,966.55 36
Vanna Doyle PT1 Womens $2,604.76 25
Suki Durham S2 Juniors $6,670.23 37
Paula Cruz S2 Shoes $6,144.88 34
Chelsea Mccormick S1 Childrens $5,371.48 39
Neve Todd S1 Childrens $2,560.45 13
Tarik Bond S1 Childrens $5,932.33 31
Blythe Arnold S1 Mens $3,854.82 21
Luke Pierce PT1 Womens $5,661.14 37
Tasha Robles PT2 Mens $4,778.29 38
Sylvia Page PT2 Housewares $3,866.30 23
Nigel Giles AM Mens $7,607.25 33
Elton Velez PT1 Cosmetics $2,852.76 21
Tyler Sherman PT2 Mens $4,720.20 32
Joseph Jordan PT2 Womens $4,774.93 26
Emma Melton PT2 Housewares $5,183.39 22
Indigo Rivers S2 Childrens $3,682.74 18
Candice Jarvis AM Mens $7,666.56 28
Nell Mclaughlin S2 Childrens $5,331.56 14
Curran Atkins S1 Childrens $5,152.47 28
Aubrey Byers PT1 Cosmetics $4,284.88 22
Cadman Quinn S1 Housewares $9,429.93 33
Ciara Ellison PT1 Mens $2,419.39 34
Keaton David PT2 Juniors $3,001.77 36
Merrill Herring S1 Shoes $7,139.76 27
Thor Workman S2 Infants $3,903.66 22
Leo Rich AM Shoes $13,949.09 40
Mari Noel S1 Juniors $4,289.02 19
Xenos Rosario S1 Infants $5,105.77 34
Virginia Benson PT2 Womens $5,563.78 13
Buckminster Riggs S1 Womens $3,198.20 18
Brianna William AM Infants $6,500.71 20
Octavia Saunders S1 Cosmetics $8,327.29 38
Deacon Winters PT2 Childrens $4,019.32 23
Sheila Rush S2 Mens $3,139.49 12
Jessica Dunn AM Housewares $5,820.31 34
Jolie Valencia PT2 Infants $2,670.70 40
Remedios Kirkland AM Juniors $5,770.51 12
Ocean Logan S2 Shoes $4,011.84 21
Hermione Fry S1 Womens $5,899.14 38
Violet Hewitt AM Shoes $7,064.45 32
Cedric Riddle S2 Shoes $8,203.00 39
Wyoming Hanson S2 Cosmetics $10,301.98 39
David Reese S2 Shoes $5,371.07 29
Shea Bartlett S2 Childrens $2,492.48 17
Aretha Lowe S1 Juniors $5,118.50 19
Constance Battle PT1 Shoes $3,651.89 32
Addison Vasquez PT2 Womens $5,500.42 27
Kane Shaw S1 Mens $5,468.32 25
Naomi Morgan S1 Cosmetics $4,933.21 31
Kenneth Oliver PT2 Infants $3,931.11 23
Claire Campbell PT2 Infants $1,905.60 15
Randall Hahn S1 Housewares $2,677.63 13
Ferdinand Valdez S2 Infants $3,867.03 37
Molly Potts PT1 Housewares $2,714.73 27
Pearl Woods AM Cosmetics $4,129.54 16
Fredericka Finch AM Cosmetics $5,891.39 21
Stone Gibbs S2 Cosmetics $5,148.18 37
Marsden Weeks S1 Mens $5,547.88 37
Evan Rush PT2 Shoes $3,181.29 16
Timon Castillo S1 Childrens $3,617.98 15
Kyle Church AM Housewares $8,525.62 37
Uriel Rosales PT2 Womens $4,668.16 23
Evelyn Montoya PT2 Womens $5,572.33 33
Finn Daugherty S2 Juniors $4,817.61 21
Justine Giles PT1 Juniors $558.71 23
Todd Leonard S2 Womens $8,023.37 39
Quintessa Vaughan S2 Childrens $5,151.93 20
Kelly Goodwin S1 Housewares $505.97 25
Martin Moses S1 Infants $3,212.78 19
Kaitlin Chan AM Childrens $3,865.65 24
Keefe Charles S1 Mens $7,881.11 32
Imani Mendez PT2 Cosmetics $6,273.35 33
Camille Rollins AM Cosmetics $7,665.89 26
Neve Daniels S2 Cosmetics $5,094.39 27
Willow Fitzgerald AM Shoes $3,669.70 20
Alan Bray PT1 Infants $2,964.82 22
Joan Massey AM Housewares $6,016.77 32
Eleanor Stanton PT1 Infants $4,521.55 30
Macy Salas PT1 Infants $4,739.80 38