FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
Bartleby Related Questions 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
expand button
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
Check Mark
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education