Create a data table that shows the average Daily Pay by gender for each department number. Start the criteria in cell E40 and the data table in cell E44.

E40 Dept No 2Hourly Rate: 6.64 3Overtime Rate: 8.23 3 Computer 2 Sales 1 Manufacturing 5 Average Hours Worked by Males in Dept No 2: 8.933333333 Total Number of Overtime Hours: Total Orertime Pay: 10 Employees Cender Dept No Department tears Workad Orsriaoun Hours Worked Overtine Hour NoaOrertimeDailyDaily Pay Darrell, Bailey 2Salos 26.56 S 53.12 $ Sbelton, Kent 13 Diffoe, Kois 24 Stull, Marlene 15 Crenshaw, Sheila 16 Donton, Susie 1Maufacturing 3Compoter 3 Computer 1Manufacturing 1Manofacturing 2Sales 39.84 Overtime 69 58 61.35 46.48 33.20 86.04 Huntington, MikeM 18 Hall, Makce 19 Smith, Brian 20 Hill, Paggy Joan 21 Hill, Joy 22 White, Bill 23 Whitehead, BabbyM 24 Adkins, Dorinda 25 Boucher, Leslie 26 Clayton,Rex 4648 S 33.2 S Overtime 1Manufacturing Overtune 77.81 2 Sales 19.92 s 12 Overtime 3Computer 202.50 7.81 46.48 28 Webb, Willkam W.M Ovestime4648 2 Sales 3Computer 28ales 53.12 S 39.34 $ 4648 S 53.12 39 84 46 48 32 Hammone, Laury cumM 1Manufact 34 Tibberts, Rusty 5 Pierson. Tony 6 Pierce. Sarmmy 1Manufacturing 3 i Computs Overtima 94.27 Sheet1Sheet2 Ready Scroll Lock O Type here to search E40 Dept No 2Hourly Rate: 6.64 3Overtime Rate: 8.23 3 Computer 2 Sales 1 Manufacturing 5 Average Hours Worked by Males in Dept No 2: 8.933333333 Total Number of Overtime Hours: Total Orertime Pay: 10 Employees Cender Dept No Department tears Workad Orsriaoun Hours Worked Overtine Hour NoaOrertimeDailyDaily Pay Darrell, Bailey 2Salos 26.56 S 53.12 $ Sbelton, Kent 13 Diffoe, Kois 24 Stull, Marlene 15 Crenshaw, Sheila 16 Donton, Susie 1Maufacturing 3Compoter 3 Computer 1Manufacturing 1Manofacturing 2Sales 39.84 Overtime 69 58 61.35 46.48 33.20 86.04 Huntington, MikeM 18 Hall, Makce 19 Smith, Brian 20 Hill, Paggy Joan 21 Hill, Joy 22 White, Bill 23 Whitehead, BabbyM 24 Adkins, Dorinda 25 Boucher, Leslie 26 Clayton,Rex 4648 S 33.2 S Overtime 1Manufacturing Overtune 77.81 2 Sales 19.92 s 12 Overtime 3Computer 202.50 7.81 46.48 28 Webb, Willkam W.M Ovestime4648 2 Sales 3Computer 28ales 53.12 S 39.34 $ 4648 S 53.12 39 84 46 48 32 Hammone, Laury cumM 1Manufact 34 Tibberts, Rusty 5 Pierson. Tony 6 Pierce. Sarmmy 1Manufacturing 3 i Computs Overtima 94.27 Sheet1Sheet2 Ready Scroll Lock O Type here to search