Excel Formula Project

Company Sales Information RecordColumn1Column2Column3Column4Column5Column6Employee NameTenureOffice LocationMarch SalesApril SalesPhone NumberAnnual SalaryAlice Norman2Dallas, Oregon $               2,548.00 $     22,764.00503-902-2155 $        22,431.00Nathan Morson5LA, California $               3,669.00 $     20,866.00531-222-1111 $        21,609.00Harry Moore9Salem, Oregon $               4,723.00 $     23,655.00503-543-6808 $        20,547.00Lori Walter3Keizer,Oregon $               3,897.00 $     45,766.00531-675-8077 $        25,975.00Henry Morris6Portland, Oregon $               7,449.00 $     46,982.00503-380-5498 $        24,650.00Jacob Mark1Phoenix, Arizona $               5,493.00 $     44,211.00531-786-4444 $        27,098.00Rachel Jefferson12Las Vegas, Nevada $               3,652.00 $     43,523.00531-211-8355 $        25,438.00Jared Marcus4Dallas, Texas $               3,885.00 $     36,854.00333-222-1111 $        28,091.00Kelly Simpson7Mesa, Arizona $               9,558.00 $     32,097.00531-444-5555 $        30,654.00Karina Mason8Miami, Florida $               8,746.00 $     31,740.00531-231-7777 $        33,487.00Mary Dobson11Seattle, Washington $               5,997.00 $     24,331.00503-201-8888 $        32,108.00Kayla Stewart13Tacoma, Washington $               4,663.00 $     28,638.00503-896-4589 $        34,876.00Dan Kristin12Carson City, Nevada $               2,096.00 $     30,628.00503-231-0101 $        25,890.00Joan Lawrence10San Diego, California $               5,898.00 $     29,655.00503-888-9999 $        35,432.00Elizabeth Johnson13Atlanta, Georgia $               4,211.00 $     25,899.00503-431-6542 $        23,990.00Mikey Harrison15New York, New York $               5,998.00 $     21,809.00503-807-9021 $        37,092.00George Burton14Austin, Texas $               4,674.00 $     46,877.00503-901-5662 $        34,885.00Yasmin Harold18Keizer,Oregon $               4,317.00 $     42,901.00503-789-7654 $        33,881.00Mariko Kisaragi20LA, California $               4,867.00 $     41,806.00513-732-1329 $        39,012.00Yuriko Takashi24Boston, MA $               4,876.00 $     45,321.00523-543-8095 $        37,096.00AVERAGE $               5,060.85 $     34,316.15 $        29,712.10COUNT202020SUM $          101,217.00 $   686,323.00 $      594,242.00