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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
