Question: With the range E5:K16 selected, use Quick Analysis tools to calculate the total regular pay, overtime pay, gross pay, taxable pay, withholding tax, FICA, and

With the range E5:K16 selected, use Quick Analysis tools to calculate the total regular pay, overtime pay, gross pay, taxable pay, withholding tax, FICA, and net pay on row 17. Note, Mac users, with the range selected, on the Home tab, in the Editing group, click AutoSum.

When I do this, it calculates the totals below the total row. How do I do it so it calculates in in the right spot?? I want the totals in row 7 not 8

 With the range E5:K16 selected, use Quick Analysis tools to calculate

Metropolitan Zoo Gift Shop Department Notes 1. The base workweek is 40 hours. Regular pay is based on hourly wane and haurs worked up to 40. 2. Overtime pay a beaed on owertme houra, the hourty wage, and the ovartime nate. 3. The gruss pay is the futal of the redular pay and overtime pay. 4. The taxable pay is the cifference betanen the gres oay and the paduct of the number af dapentents and dedluction par dapentent. 5. Federal wthholding tax is caloulated on the taxable pay basad on the tax table. 6. FIGA be calculatad an the amplayan's groas pay

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!