Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Select the Summary Sheet. Enter a formula in B4 that pulls the total salaries and wages expense from the Qtr 1 sheet total for that
Select the Summary Sheet. Enter a formula in B4 that pulls the total salaries and wages expense from the Qtr 1 sheet total for that expense item. Repeat this formula input for Qtr 2, Qtr 3 and Qtr 4. Copy the formulas down from row 4 to rows 5 through 7. Fill without formatting. Use a sum function in row 8 to total the expenses. Sum the rows 4-8 in column F using the autosum Keep the accounting format on rows 4 and 8. Use comma formatting on the middle rows. Apply Total cell style to the numeric cells on row 8. Select the Unlock_Lock_Protect sheet. Unprotect the worksheet. Unlock the green cells (B4:B7). Then, re-protect the sheet so that the only cells that are able to be updated are the loan input cells (the green cells)
Step 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