Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 payStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started