Below is payroll information for the upcoming payroll at Cards, Inc.

Payroll at Cards, Inc. is batch processed $($as opposed to processed in real$-$time$).$ ?The following rules should apply to Cards' payroll:

$-$Employee numbers are five$-$digits in length and range from $10000$ ?through $99999.$

Maximum pay rate is $$35,$ ?and minimum is $$15.$

$-$Hours worked should never exceed $40.$

$-$Deductions should be between $10\%$ ?and $35\%$ ?of gross pay.

$1$ ?Complete each of the requirements listed given the payroll information below.

$2$

$\backslash$table$[[$Employee Number,Pay rate,Hours worked,Gross Pay,Deductions,Net pay$],[46892,15\mathrm{.}00,28,420\mathrm{.}00,325\mathrm{.}00,95\mathrm{.}00],[35794,16\mathrm{.}50,50,825\mathrm{.}00,205\mathrm{.}00,620\mathrm{.}00],[81654,5\mathrm{.}00,40,200\mathrm{.}00,45\mathrm{.}00,245\mathrm{.}00],[96324,57\mathrm{.}60,40,2304\mathrm{.}00,10\mathrm{.}00,2294\mathrm{.}00]]$

$8$

$9$

$10$

REOUIREMENTS:

$2.$ ?The above dataset contains several errors. Using Cards' payroll rules as guidance, identify and describe all seven errors.

Select appropriate

Sheet $1$

Sheet$2$

Ready

Accessibility: Investigate

$.$ ?The above dataset contains several errors. Using Cards' payroll rules as guidance, identify and describe all seven errors.

$22.$

$23$

$24$

$25$

$26$

$27$

$28$

$30$

$11$

$32$

$33$

$34$

$35$

$36$

$37$

$38$

$3.$ ?Using the yellow highlighted fields $?$ext to the payroll data, add formulas that will allow you to verify that each net pay is alculated accurately and that the grand total of net pay is calculated accurately. $q,1.$ ?Copy and paste cells A$3$:F$7$ ?into a new worksheet. Then add control procedures that would prevent, or at least detect, each of he errors in the data set.

Headers should NOT include any type of validation.

$3$e sure to select "circle invalid data" upon entering all data validations.

$39$

lint: Use data validation tools for the first three rules at Cards, Inc. Use conditional formatting for the last rule.

Sheet$1$

Sheet$2$

Ready

Accessibility: Investigate

Slide $4$ ?of $9$

English $($United States$)$

Accessibility: Investigate