Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock