Due to the complexity of this week's Excel Lab, it will be split into five (5) parts.Each part is an individual assignment and must be completed.

You will be graded on the formulas you insert into each cell, so manually calculating or completing the sheets will earn you zero (0) points.

Excel Lab 4 Worksheet 1, with video

Excel Lab 4 Worksheet 1.xlsx

https://youtu.be/EpXwewz7rZM(Links to an external site.)

Links to an external site.

Minimize Video

Excel Lab 4 Worksheet 2, with video

Excel Lab 4 Worksheet 2.xlsx

https://youtu.be/46p-eI6XdD0(Links to an external site.)

Links to an external site.

Excel Lab 4 Worksheet 3, with video

Excel Lab 4 Worksheet 3.xlsx

https://youtu.be/kLWqSxN2Mcc(Links to an external site.)

Links to an external site.

Excel Lab 4 Worksheet 4, with video

Excel Lab 4 Worksheet 4.xlsx

https://youtu.be/9nQazv1OiDw(Links to an external site.)

Links to an external site.

Excel Lab 4 Worksheet 5, with video

Excel Lab 4 Worksheet 5.xlsx

https://youtu.be/imo9C6DMG5I(Links to an external site.)

Links to an external site.

Employee Hire Date Aemro, Abiye Afrah, Shimon Al Bahrani, Ibrahim Alakeely, Mohammed Anderson, Cassandra Beaulieu, Jade Billingsly, Tanesha Black, Margaux Louise Bostwick, Joseph Byron, Tumyra Crawford, Phyllis Dang, Trinh Eya, Alejo Hayes, James Henderson, Melissa Jerry, Andre Jones, Linda Keb, Madeline Kingsberry, Angelia Konetchy, Tory Laurent, Victorine Lin, Yan Mansfield, Zachary Moss, Andrea Mumpi, Yanosser Nguyen, Tram Patterson, Jeremi Perry, Kathryn Phillips, Candace Smoot, Carlis Stark, La'Shelle Suthar, Chandani Taylor, Jerry Tice, Alan Trotter, Anthony Wei, Baixi Winker, Joseph Wolfenbarger, Chaz 3/14/2015 10/6/2011 9/9/2004 7/21/2009 6/26/2014 1/17/2006 5/8/2016 4/22/2010 2/9/2001 6/13/2009 12/3/2013 6/15/2008 5/28/2010 12/6/2004 11/14/2000 7/12/2012 12/12/2009 1/20/2013 6/24/2010 3/19/2014 8/9/2009 10/19/2001 3/21/2006 12/20/2015 3/26/2000 2/9/2003 7/18/2007 12/3/2007 12/10/2004 12/24/2003 8/12/2011 10/10/2011 12/13/2014 10/9/2006 7/22/2005 12/20/2006 5/24/2007 12/4/2008 Yrs of Svc 1.67 5.10 12.18 7.31 2.38 10.82 0.51 6.56 15.76 7.42 2.94 8.41 6.46 11.93 15.99 4.34 6.92 3.81 6.39 2.65 7.26 15.07 10.65 0.90 16.63 13.76 9.32 8.94 11.92 12.89 5.25 5.09 1.92 10.09 11.31 9.90 9.47 7.94 Title Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Annual Pay $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 62,786 31,332 35,773 51,193 65,202 54,873 29,000 38,373 63,406 47,367 39,782 41,641 30,851 33,550 31,464 24,322 27,977 35,241 62,559 31,396 52,242 27,313 53,676 58,135 58,590 38,235 64,116 33,263 57,845 50,345 61,388 66,039 62,352 40,649 25,865 27,140 40,126 44,244 Hourly/Salary Pay Rate Hours Pay 30 14 27 59 39 15 35 28 17 37 32 59 27 15 57 51 40 46 22 45 22 33 33 55 16 39 38 10 51 46 37 45 43 15 10 57 22 60 Overtime Bonus Total Pay Employee Hire Date Aemro, Abiye Afrah, Shimon Al Bahrani, Ibrahim Alakeely, Mohammed Anderson, Cassandra Beaulieu, Jade Billingsly, Tanesha Black, Margaux Louise Bostwick, Joseph Byron, Tumyra Crawford, Phyllis Dang, Trinh Eya, Alejo Hayes, James Henderson, Melissa Jerry, Andre Jones, Linda Keb, Madeline Kingsberry, Angelia Konetchy, Tory Laurent, Victorine Lin, Yan Mansfield, Zachary Moss, Andrea Mumpi, Yanosser Nguyen, Tram Patterson, Jeremi Perry, Kathryn Phillips, Candace Smoot, Carlis Stark, La'Shelle Suthar, Chandani Taylor, Jerry Tice, Alan Trotter, Anthony Wei, Baixi Winker, Joseph Wolfenbarger, Chaz 3/14/2015 10/6/2011 9/9/2004 7/21/2009 6/26/2014 1/17/2006 5/8/2016 4/22/2010 2/9/2001 6/13/2009 12/3/2013 6/15/2008 5/28/2010 12/6/2004 11/14/2000 7/12/2012 12/12/2009 1/20/2013 6/24/2010 3/19/2014 8/9/2009 10/19/2001 3/21/2006 12/20/2015 3/26/2000 2/9/2003 7/18/2007 12/3/2007 12/10/2004 12/24/2003 8/12/2011 10/10/2011 12/13/2014 10/9/2006 7/22/2005 12/20/2006 5/24/2007 12/4/2008 Yrs of Svc 1.67 5.10 12.18 7.31 2.38 10.82 0.51 6.56 15.76 7.42 2.94 8.41 6.46 11.93 15.99 4.34 6.92 3.81 6.39 2.65 7.26 15.07 10.65 0.90 16.63 13.76 9.32 8.94 11.92 12.89 5.25 5.09 1.92 10.09 11.31 9.90 9.47 7.94 Title Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Annual Pay $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 62,786 31,332 35,773 51,193 65,202 54,873 29,000 38,373 63,406 47,367 39,782 41,641 30,851 33,550 31,464 24,322 27,977 35,241 62,559 31,396 52,242 27,313 53,676 58,135 58,590 38,235 64,116 33,263 57,845 50,345 61,388 66,039 62,352 40,649 25,865 27,140 40,126 44,244 Hourly/Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Pay Rate Hours Pay 30 14 27 59 39 15 35 28 17 37 32 59 27 15 57 51 40 46 22 45 22 33 33 55 16 39 38 10 51 46 37 45 43 15 10 57 22 60 Overtime Bonus Total Pay Employee Hire Date Aemro, Abiye Afrah, Shimon Al Bahrani, Ibrahim Alakeely, Mohammed Anderson, Cassandra Beaulieu, Jade Billingsly, Tanesha Black, Margaux Louise Bostwick, Joseph Byron, Tumyra Crawford, Phyllis Dang, Trinh Eya, Alejo Hayes, James Henderson, Melissa Jerry, Andre Jones, Linda Keb, Madeline Kingsberry, Angelia Konetchy, Tory Laurent, Victorine Lin, Yan Mansfield, Zachary Moss, Andrea Mumpi, Yanosser Nguyen, Tram Patterson, Jeremi Perry, Kathryn Phillips, Candace Smoot, Carlis Stark, La'Shelle Suthar, Chandani Taylor, Jerry Tice, Alan Trotter, Anthony Wei, Baixi Winker, Joseph Wolfenbarger, Chaz 3/14/2015 10/6/2011 9/9/2004 7/21/2009 6/26/2014 1/17/2006 5/8/2016 4/22/2010 2/9/2001 6/13/2009 12/3/2013 6/15/2008 5/28/2010 12/6/2004 11/14/2000 7/12/2012 12/12/2009 1/20/2013 6/24/2010 3/19/2014 8/9/2009 10/19/2001 3/21/2006 12/20/2015 3/26/2000 2/9/2003 7/18/2007 12/3/2007 12/10/2004 12/24/2003 8/12/2011 10/10/2011 12/13/2014 10/9/2006 7/22/2005 12/20/2006 5/24/2007 12/4/2008 Yrs of Svc 1.67 5.10 12.18 7.31 2.38 10.82 0.51 6.56 15.76 7.42 2.94 8.41 6.46 11.93 15.99 4.34 6.92 3.81 6.39 2.65 7.26 15.07 10.65 0.90 16.63 13.76 9.32 8.94 11.92 12.89 5.25 5.09 1.92 10.09 11.31 9.90 9.47 7.94 Title Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Annual Pay $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 62,786 31,332 35,773 51,193 65,202 54,873 29,000 38,373 63,406 47,367 39,782 41,641 30,851 33,550 31,464 24,322 27,977 35,241 62,559 31,396 52,242 27,313 53,676 58,135 58,590 38,235 64,116 33,263 57,845 50,345 61,388 66,039 62,352 40,649 25,865 27,140 40,126 44,244 Hourly/Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Pay Rate $ 30.19 $ 15.06 $ 17.20 $ 984.48 $ 31.35 $ 26.38 $ 13.94 $ 737.94 $ 30.48 $ 22.77 $ 19.13 $ 800.79 $ 14.83 $ 16.13 $ 15.13 $ 467.73 $ 13.45 $ 16.94 $ 30.08 $ 603.77 $ 25.12 $ 13.13 $ 25.81 $ 1,117.98 $ 28.17 $ 18.38 $ 1,233.00 $ 15.99 $ 27.81 $ 24.20 $ 1,180.54 $ 31.75 $ 29.98 $ 19.54 $ 497.40 $ 13.05 $ 19.29 $ 21.27 Hours Pay 30 14 27 59 39 15 35 28 17 37 32 59 27 15 57 51 40 46 22 45 22 33 33 55 16 39 38 10 51 46 37 45 43 15 10 57 22 60 Overtime Bonus Total Pay Employee Hire Date Aemro, Abiye Afrah, Shimon Al Bahrani, Ibrahim Alakeely, Mohammed Anderson, Cassandra Beaulieu, Jade Billingsly, Tanesha Black, Margaux Louise Bostwick, Joseph Byron, Tumyra Crawford, Phyllis Dang, Trinh Eya, Alejo Hayes, James Henderson, Melissa Jerry, Andre Jones, Linda Keb, Madeline Kingsberry, Angelia Konetchy, Tory Laurent, Victorine Lin, Yan Mansfield, Zachary Moss, Andrea Mumpi, Yanosser Nguyen, Tram Patterson, Jeremi Perry, Kathryn Phillips, Candace Smoot, Carlis Stark, La'Shelle Suthar, Chandani Taylor, Jerry Tice, Alan Trotter, Anthony Wei, Baixi Winker, Joseph Wolfenbarger, Chaz 3/14/2015 10/6/2011 9/9/2004 7/21/2009 6/26/2014 1/17/2006 5/8/2016 4/22/2010 2/9/2001 6/13/2009 12/3/2013 6/15/2008 5/28/2010 12/6/2004 11/14/2000 7/12/2012 12/12/2009 1/20/2013 6/24/2010 3/19/2014 8/9/2009 10/19/2001 3/21/2006 12/20/2015 3/26/2000 2/9/2003 7/18/2007 12/3/2007 12/10/2004 12/24/2003 8/12/2011 10/10/2011 12/13/2014 10/9/2006 7/22/2005 12/20/2006 5/24/2007 12/4/2008 Yrs of Svc 1.67 5.10 12.18 7.31 2.38 10.82 0.51 6.56 15.76 7.42 2.94 8.41 6.46 11.93 15.99 4.34 6.92 3.81 6.39 2.65 7.26 15.07 10.65 0.90 16.63 13.76 9.32 8.94 11.92 12.89 5.25 5.09 1.92 10.09 11.31 9.90 9.47 7.94 Title Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Annual Pay $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 62,786 31,332 35,773 51,193 65,202 54,873 29,000 38,373 63,406 47,367 39,782 41,641 30,851 33,550 31,464 24,322 27,977 35,241 62,559 31,396 52,242 27,313 53,676 58,135 58,590 38,235 64,116 33,263 57,845 50,345 61,388 66,039 62,352 40,649 25,865 27,140 40,126 44,244 Hourly/Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Pay Rate $ 30.19 $ 15.06 $ 17.20 $ 984.48 $ 31.35 $ 26.38 $ 13.94 $ 737.94 $ 30.48 $ 22.77 $ 19.13 $ 800.79 $ 14.83 $ 16.13 $ 15.13 $ 467.73 $ 13.45 $ 16.94 $ 30.08 $ 603.77 $ 25.12 $ 13.13 $ 25.81 $ 1,117.98 $ 28.17 $ 18.38 $ 1,233.00 $ 15.99 $ 27.81 $ 24.20 $ 1,180.54 $ 31.75 $ 29.98 $ 19.54 $ 497.40 $ 13.05 $ 19.29 $ 21.27 Hours Pay 30 14 27 59 39 15 35 28 17 37 32 59 27 15 57 51 40 46 22 45 22 33 33 55 16 39 38 10 51 46 37 45 43 15 10 57 22 60 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 905.57 210.89 464.36 984.48 1,222.54 395.72 487.98 737.94 518.22 842.59 612.03 800.79 400.47 241.95 605.08 467.73 538.02 677.71 661.68 603.77 552.56 433.33 851.59 1,117.98 450.69 716.91 1,233.00 159.92 1,112.40 968.17 1,180.54 1,269.98 1,199.08 293.14 497.40 521.92 424.41 850.85 Overtime Bonus Total Pay Employee Hire Date Aemro, Abiye Afrah, Shimon Al Bahrani, Ibrahim Alakeely, Mohammed Anderson, Cassandra Beaulieu, Jade Billingsly, Tanesha Black, Margaux Louise Bostwick, Joseph Byron, Tumyra Crawford, Phyllis Dang, Trinh Eya, Alejo Hayes, James Henderson, Melissa Jerry, Andre Jones, Linda Keb, Madeline Kingsberry, Angelia Konetchy, Tory Laurent, Victorine Lin, Yan Mansfield, Zachary Moss, Andrea Mumpi, Yanosser Nguyen, Tram Patterson, Jeremi Perry, Kathryn Phillips, Candace Smoot, Carlis Stark, La'Shelle Suthar, Chandani Taylor, Jerry Tice, Alan Trotter, Anthony Wei, Baixi Winker, Joseph Wolfenbarger, Chaz 3/14/2015 10/6/2011 9/9/2004 7/21/2009 6/26/2014 1/17/2006 5/8/2016 4/22/2010 2/9/2001 6/13/2009 12/3/2013 6/15/2008 5/28/2010 12/6/2004 11/14/2000 7/12/2012 12/12/2009 1/20/2013 6/24/2010 3/19/2014 8/9/2009 10/19/2001 3/21/2006 12/20/2015 3/26/2000 2/9/2003 7/18/2007 12/3/2007 12/10/2004 12/24/2003 8/12/2011 10/10/2011 12/13/2014 10/9/2006 7/22/2005 12/20/2006 5/24/2007 12/4/2008 Yrs of Svc 1.67 5.10 12.18 7.31 2.38 10.82 0.51 6.56 15.76 7.42 2.94 8.41 6.46 11.93 15.99 4.34 6.92 3.81 6.39 2.65 7.26 15.07 10.65 0.90 16.63 13.76 9.32 8.94 11.92 12.89 5.25 5.09 1.92 10.09 11.31 9.90 9.47 7.94 Title Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Executive Admin Sales Support Executive Admin Sales Support Executive Admin Sales Support Annual Pay $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 62,786 31,332 35,773 51,193 65,202 54,873 29,000 38,373 63,406 47,367 39,782 41,641 30,851 33,550 31,464 24,322 27,977 35,241 62,559 31,396 52,242 27,313 53,676 58,135 58,590 38,235 64,116 33,263 57,845 50,345 61,388 66,039 62,352 40,649 25,865 27,140 40,126 44,244 Hourly/Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Salary Hourly Hourly Hourly Pay Rate $ 30.19 $ 15.06 $ 17.20 $ 984.48 $ 31.35 $ 26.38 $ 13.94 $ 737.94 $ 30.48 $ 22.77 $ 19.13 $ 800.79 $ 14.83 $ 16.13 $ 15.13 $ 467.73 $ 13.45 $ 16.94 $ 30.08 $ 603.77 $ 25.12 $ 13.13 $ 25.81 $ 1,117.98 $ 28.17 $ 18.38 $ 1,233.00 $ 15.99 $ 27.81 $ 24.20 $ 1,180.54 $ 31.75 $ 29.98 $ 19.54 $ 497.40 $ 13.05 $ 19.29 $ 21.27 Hours 30 14 27 59 39 15 35 28 17 37 32 59 27 15 57 51 40 46 22 45 22 33 33 55 16 39 38 10 51 46 37 45 43 15 10 57 22 60 Pay Overtime $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 905.57 210.89 464.36 984.48 1,222.54 395.72 487.98 737.94 518.22 842.59 612.03 800.79 400.47 241.95 605.08 467.73 538.02 677.71 661.68 603.77 552.56 433.33 851.59 1,117.98 450.69 716.91 1,233.00 159.92 1,112.40 968.17 1,180.54 1,269.98 1,199.08 293.14 497.40 521.92 424.41 850.85 Bonus Total Pay 385.74 152.49 458.87 217.84 238.12 134.90 332.73 638.13 $ #DIV/0