(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

Criteria This area is for queston 4 EmpGender 2937.50 Criteria EmpGender This area is for queston 5 EmpLastname Jones Payne Morgan Yuan Payne Clarkson Briones Reetz Jones Garza Lucio Baldwin Nguyen Bauer Kennemer Employee Data EmpFirstName EmpGender EmphireDate EmpBasePay Karen F 11-Aug-91 $2,000.00 Kathy F 05-Dec-94 $3,500.00 Adrian M 25-Oct-93 $6,000.00 Gail F 01-Mar-97) $5,000.00 Justin M 26-Apr-97 $5,000.00 Shandra F 30-May-97 $3,000.00 Richard M 28-Apr-98 $4,500.00 Melinda F 17-Oct-971 $3,000.00 William M 12-May-92 $3,500.00 Jeffery M 06-Jan-96 $2,500.00 Tanner M 29-Jun-931 $2,500.00 Kristina F 21-Mar-98 $2,000.00 James M 09-Jul-95 $2,000.00 Nelda F 08-Aug-98 $3,000.00 Mandi 07-Jul-99 $2,000.00 Criteria EmpGender EmpHireDate This area is for queston 6 Name: WhitfieldShamika || | || | || Instructions: Using the worksheet above to answer the following questions: 23500.00 (1) What is the total base pay for women? Using SUMIF function 26000.00 (2) What is the total of all base pay for men? Using SUMIF function 2.00 (3) How many employee make $3500 basepay? Using Countlf function 2937.50 (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