Exp22_Excel_Ch11_CumulatveAssessment_Variation - Accountants

profileSolutions Aplus
afrhuj_Exp22_Excel_Ch11_CumulativeAssessment_Variation_Accountants1.xlsx
Home>Computer Science homework help>Exp22_Excel_Ch11_CumulatveAssessment_Variation - Accountants

Data

Year Date No. ID First Name Last Name Last, First Title Salary Phone Number Area Code Location City Miami & Columbus Tax Accountants
2007 1018 10 Camille Adams Senior Accountant $ 95,000 (305) 555-6105 MIAMI High Salary
2008 0218 11 Ava Hartvigsen Tax Accountant $ 88,000 (619) 555-0258 COLUMBUS Low Salary
2009 1015 12 Isaac Terriquez Tax Accountant $ 101,750 (214) 555-8435 DALLAS
2009 1214 13 Bradley Deberard Tax Accountant $ 100,795 (469) 555-6543 DALLAS Title Location
2011 0117 14 Oliver Laing Senior Accountant $ 110,500 (469) 555-2468 DALLAS Senior Accountant Columbus
2012 0417 15 Sophia Lenz Tax Accountant $ 94,750 (786) 555-2434 MIAMI
2014 0131 16 Audrey Unice Tax Accountant $ 98,750 (214) 555-1357 DALLAS Sr. Accountant Salary
2014 0303 17 Milia Omweg Senior Accountant $ 105,850 (518) 555-3145 ALBANY
2014 0605 18 Amanda Doering Tax Accountant $ 100,750 (518) 555-0470 ALBANY Lookup Salary
2014 0616 19 Torrie Barnes Tax Accountant $ 91,000 (858) 555-7418 COLUMBUS Enter last name Gomez
2014 0715 20 Eilijah Franklin Tax Accountant $ 92,240 (305) 555-9701 MIAMI Salary
2014 0918 21 Violet Garbett Tax Accountant $ 92,835 (305) 555-4464 MIAMI Location
2015 0903 22 Olivia Forgan Tax Accountant $ 90,250 (786) 555-8016 MIAMI
2015 1106 23 Melanie Peterson Tax Accountant $ 90,100 (786) 555-4567 MIAMI Functions
2016 1011 24 Lucas Gomez Tax Accountant $ 87,725 (619) 555-1023 COLUMBUS Cell P8
2016 1108 25 Dylan Selinger Tax Accountant $ 86,525 (619) 555-0430 COLUMBUS Cell P12
2018 0417 26 Abia Ikenberry Tax Accountant $ 97,125 (838) 555-7747 ALBANY Cell P13
2018 1104 27 Anthony Bacarella Tax Accountant $ 97,575 (214) 555-4739 DALLAS
2019 0626 28 Ethan Mentzer Tax Accountant $ 85,450 (858) 555-3480 COLUMBUS
2019 0830 29 Sebastian Mercado Tax Accountant $ 95,000 (838) 555-4433 ALBANY
2020 0108 30 Serenity Sae Tax Accountant $ 94,300 (838) 555-3435 ALBANY
2020 0309 31 Jon Chen Senior Accountant $ 100,800 (619) 555-6465 COLUMBUS
2020 0403 32 Liam Keone Tax Accountant $ 96,125 (469) 555-5431 DALLAS
2020 0714 33 Zoey Scholfield Tax Accountant $ 85,750 (305) 555-1040 MIAMI
2020 0813 34 Madison Nitz Tax Accountant $ 94,000 (469) 555-0918 DALLAS

Student Name &A &F

Summary

Average by City
Enter City: Miami
Average Salary

Albany

Year ID First Name Last Name Title Salary Phone Number City
2014 2014-0303-17 Milia Omweg Senior Accountant $ 105,850 (518) 555-3145 Albany
2014 2014-0605-18 Amanda Doering Tax Accountant $ 100,750 (518) 555-0470 Albany
2018 2018-0417-26 Abia Ikenberry Tax Accountant $ 97,125 (838) 555-7747 Albany
2019 2019-0830-29 Sebastian Mercado Tax Accountant $ 95,000 (838) 555-4433 Albany
2020 2020-0108-30 Serenity Sae Tax Accountant $ 94,300 (838) 555-3435 Albany
Average $ 98,605

Student Name &A &F

Columbus

Year ID First Name Last Name Title Salary Phone Number City
2008 2008-0218-11 Ava Hartvigsen Tax Accountant $ 88,000 (619) 555-0258 San Diego
2014 2014-0616-19 Torrie Barnes Tax Accountant $ 91,000 (858) 555-7418 San Diego
2016 2016-1011-24 Lucas Gomez Tax Accountant $ 87,725 (619) 555-1023 San Diego
2016 2016-1108-25 Dylan Selinger Tax Accountant $ 86,525 (619) 555-0430 San Diego
2019 2019-0626-28 Ethan Mentzer Tax Accountant $ 85,450 (858) 555-3480 San Diego
2020 2020-0309-31 Jon Chen Senior Accountant $ 100,800 (619) 555-6465 San Diego
Average $ 89,917

Student Name &A &F

Dallas

Year ID First Name Last Name Title Salary Phone Number City
2009 2009-1015-12 Isaac Terriquez Tax Accountant $ 101,750 (214) 555-8435 Dallas
2009 2009-1214-13 Bradley Deberard Tax Accountant $ 100,795 (469) 555-6543 Dallas
2011 2011-0117-14 Oliver Laing Senior Accountant $ 110,500 (469) 555-2468 Dallas
2014 2014-0131-16 Audrey Unice Tax Accountant $ 98,750 (214) 555-1357 Dallas
2018 2018-1104-27 Anthony Bacarella Tax Accountant $ 97,575 (214) 555-4739 Dallas
2020 2020-0403-32 Liam Keone Tax Accountant $ 96,125 (469) 555-5431 Dallas
2020 2020-0813-34 Madison Nitz Tax Accountant $ 94,000 (469) 555-0918 Dallas
Average $ 99,928

Student Name &A &F

Miami

Year ID First Name Last Name Title Salary Phone Number City
2007 2007-1018-10 Camille Adams Senior Accountant $ 95,000 (305) 555-6105 Miami
2012 2012-0417-15 Sophia Lenz Tax Accountant $ 94,750 (786) 555-2434 Miami
2014 2014-0715-20 Eilijah Franklin Tax Accountant $ 92,240 (305) 555-9701 Miami
2014 2014-0918-21 Violet Garbett Tax Accountant $ 92,835 (305) 555-4464 Miami
2015 2015-0903-22 Olivia Forgan Tax Accountant $ 90,250 (786) 555-8016 Miami
2015 2015-1106-23 Melanie Peterson Tax Accountant $ 90,100 (786) 555-4567 Miami
2020 2020-0714-33 Zoey Scholfield Tax Accountant $ 85,750 (305) 555-1040 Miami
Average $ 91,561

Student Name &A &F

Accountants

ID First Name Last Name Title Salary City ID First Name Last Name Title Salary City Cities
2007-1018-10 Camille Adams Senior Accountant $ 95,000 Miami
2008-0218-11 Ava Hartvigsen Tax Accountant $ 88,000 Columbus
2009-1015-12 Isaac Terriquez Tax Accountant $ 101,950 Dallas
2009-1214-13 Bradley Deberard Tax Accountant $ 100,825 Dallas
2011-0117-14 Oliver Laing Senior Accountant $ 110,500 Dallas
2012-0417-15 Sophia Lenz Tax Accountant $ 97,750 Miami
2014-0131-16 Audrey Unice Tax Accountant $ 98,850 Dallas
2014-0303-17 Milia Omweg Senior Accountant $ 105,850 Albany
2014-0605-18 Amanda Doering Tax Accountant $ 100,750 Albany
2014-0616-19 Torrie Barnes Tax Accountant $ 91,000 Columbus
2014-0715-20 Eilijah Franklin Tax Accountant $ 92,240 Miami
2014-0918-21 Violet Garbett Tax Accountant $ 92,835 Miami Top 5 Salaries
2015-0903-22 Olivia Forgan Tax Accountant $ 90,250 Miami
2015-1106-23 Melanie Peterson Tax Accountant $ 90,100 Miami
2016-1011-24 Lucas Gomez Tax Accountant $ 87,725 Columbus
2016-1108-25 Dylan Selinger Tax Accountant $ 86,525 Columbus
2018-0417-26 Abia Ikenberry Tax Accountant $ 97,125 Albany
2018-1104-27 Anthony Bacarella Tax Accountant $ 97,650 Dallas
2019-0626-28 Ethan Mentzer Tax Accountant $ 85,450 Columbus
2019-0830-29 Sebastian Mercado Tax Accountant $ 95,000 Albany
2020-0108-30 Serenity Sae Tax Accountant $ 94,300 Albany
2020-0309-31 Jon Chen Senior Accountant $ 100,800 Columbus
2020-0403-32 Liam Keone Tax Accountant $ 96,125 Dallas
2020-0714-33 Zoey Scholfield Tax Accountant $ 85,750 Miami
2020-0813-34 Madison Nitz Tax Accountant $ 94,000 Dallas