
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps

Knowledge Booster
Similar questions
- The employment income of an individual is reported on ________ slip, while investment income are reported on _________ or _________ slips.arrow_forwardThe top picture was helpful for the separately stated items and I got most of the numbers on my own, but how do you calculate the QBI and allocated wages for this problem?arrow_forwardHow do you find and calculate FUTA and SUTA on payroll register?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education


Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON

Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education