(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)

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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

Blurred answer
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education