Homework Help is Here – Start Your Trial Now!
Business
Accounting
(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 <01/01/1997)

(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 <01/01/1997)

Quickbooks Online Accounting
Quickbooks Online Accounting
3rd Edition
ISBN:9780357391693
Author:Owen
Publisher:Owen
Chapter4: Operating Activities: Sales And Cash Receipts
Section: Chapter Questions
Problem 2.13C
See similar textbooks
icon
Related questions
Question
AutoSave Off H2C File Home Insert Draw Page Layout Formulas Data Review A26 X A B C D E 1 Employee Data 2 EmpLastname EmpFirstName EmpGender EmpHireDate EmpBasePay 3 Jones Karen F 11-Aug-91 $2,000.00 4 Payne F 05-Dec-94 $3,500.00 Kathy Adrian 5 Morgan M 25-Oct-93 $6,000.00 6 Yuan F 01-Mar-97 $5,000.00 M 26-Apr-97 $5,000.00 7 Payne 8 Clarkson Gail Justin Shandra Richard Melinda F 30-May-97 $3,000.00 9 Briones M 28-Apr-98 $4,500.00 17-Oct-97 $3,000.00 10 Reetz F 11 Jones William M 12 Garza Jeffery M 12-May-92 $3,500.00 06-Jan-96 $2,500.00 29-Jun-93 $2,500.00 13 Lucio Tanner M 14 Baldwin Kristina F 21-Mar-98 $2,000.00 15 Nguyen James M 09-Jul-95 $2,000.00 16 Bauer Nelda F 08-Aug-98 $3,000.00 17 Kennemer Mandi F 07-Jul-99 $2,000.00 18 19 Name: \| ||| |||| ||||| || 20 Instructions: Using the worksheet above to answer the following questions: 21 22 23 24 25 26 27 4 Ready fx View Add-ins G Criteria EmpGender F Criteria EmpGender M Criteria EmpGender EmpHireDate M <01/01/1997 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 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 <01/01/1997) Instructions TableTotal VLookUp Apothecary Sales Rep List Database Function + X N P EO Accessibility: Investigate e hp Search (Alt+Q) Developer F Help Khan, Ghulam J K This area is for queston 4 This area is for queston 5 H W KG 円 L Comments M This area is for queston 6 B E ? Share N + 110% 9:59 AM 5/22/2022
Transcribed Image Text:AutoSave Off H2C File Home Insert Draw Page Layout Formulas Data Review A26 X A B C D E 1 Employee Data 2 EmpLastname EmpFirstName EmpGender EmpHireDate EmpBasePay 3 Jones Karen F 11-Aug-91 $2,000.00 4 Payne F 05-Dec-94 $3,500.00 Kathy Adrian 5 Morgan M 25-Oct-93 $6,000.00 6 Yuan F 01-Mar-97 $5,000.00 M 26-Apr-97 $5,000.00 7 Payne 8 Clarkson Gail Justin Shandra Richard Melinda F 30-May-97 $3,000.00 9 Briones M 28-Apr-98 $4,500.00 17-Oct-97 $3,000.00 10 Reetz F 11 Jones William M 12 Garza Jeffery M 12-May-92 $3,500.00 06-Jan-96 $2,500.00 29-Jun-93 $2,500.00 13 Lucio Tanner M 14 Baldwin Kristina F 21-Mar-98 $2,000.00 15 Nguyen James M 09-Jul-95 $2,000.00 16 Bauer Nelda F 08-Aug-98 $3,000.00 17 Kennemer Mandi F 07-Jul-99 $2,000.00 18 19 Name: \| ||| |||| ||||| || 20 Instructions: Using the worksheet above to answer the following questions: 21 22 23 24 25 26 27 4 Ready fx View Add-ins G Criteria EmpGender F Criteria EmpGender M Criteria EmpGender EmpHireDate M <01/01/1997 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 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 <01/01/1997) Instructions TableTotal VLookUp Apothecary Sales Rep List Database Function + X N P EO Accessibility: Investigate e hp Search (Alt+Q) Developer F Help Khan, Ghulam J K This area is for queston 4 This area is for queston 5 H W KG 円 L Comments M This area is for queston 6 B E ? Share N + 110% 9:59 AM 5/22/2022
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS