Employee Data Criteria This area is for queston 4 EmpGender F EmpFirstName Karen Kathy Adrian Gail T371 Criteria EmpGender This area is for queston 5 EmpLastname Jones Payne Morgan Yuan Payne Clarkson Briones Reetz Jones Garza Lucio Baldwin Nguyen Bauer Kennemer EmpGender EmpHire Date EmpBasePay 11-Aug-91 $2,000.00 05-Dec-94 $3,500.00 . 25-Oct-93 $6,000.00 01-Mar-97 $5,000.00 26-Apr-97 $5,000.00 30-May-97 $3,000.00 M. 28-Apr-98 $4,500.00 17-Oct-97 $3,000.00 M. 12-May-92 $3,500.00 M. 06-Jan-96 $2,500.00 M. 29-Jun-93 $2,500.00 F 21-Mar-98 $2,000.00 M. 09-Jul-95 $2,000.00 08-Aug-98 $3,000.00 F 07-Jul-99 $2,000.00 Justin Shandra Richard Melinda William Jeffery Tanner Kristina James Nelda Mandi F Criteria EmpGender Emp Hire Date This area is for queston 6 Name: Ingle Maya MILIIT IL MIL. Instructions: Using the worksheet above to answer the following questions: (1) What is the total base pay for women? Using SUMIF function (2) What is the total of all base pay for men? Using SUMIF function (3) How many employee make $3500 basepay? Using CountIF function (4) What is the average basepay for women? Using DAVERAGE function (5) What is the total basepay for men? Using DSUM function (6) What is the total basepay for men hired before 1-jan-97? Using DSUM function (syntax for date is