PB Payroll. xlsx - Excel sert
Ра
e what
you wan
Task Instructions
11
Х
00
-
Conditio
Formattin
Font
In cell 16, enter a formula using the DCOUNT function to
count the number of employees with a Rating of 3. Use the
table range A3:F16 as the database argument, the Rating
column heading in cell D3 as the field argument, and
range 14:15 as the criteria.
B
Last Name
Position
H
Rating
1
Salary
Bonus
3
Perfc
Burns
Patel
Davidson
White
Foreman
Foreman
Office Manager
Procurement
2.
$75,000
$67,000
$45.000
$7,500
$3,350
Rating
2.