Chat with AI
Excel Applications for Accounting Principles 4th Edition by Gaylord Smith
Edition 4ISBN: 978-1111581565Excel Applications for Accounting Principles 4th Edition by Gaylord Smith
Edition 4ISBN: 978-1111581565 Exercise 6
PROBLEM DATA
The trial balance of Wikki Cleaners at December 31, 2012, the end of the current fiscal year, is as follows:
Information for the adjusting entries is as follows:
a. Cleaning supplies on hand on December 31, 2012, $18,750.
b. Insurance premiums expired during the year, $1,800.
c. Depreciation on equipment during the year, $21,600.
d. Wages accrued but not paid at December 31, 2012, $1,830.
REQUIREMENT
Open the file F1WORK from the website for the book at cengagebrain.com. Enter the formulas in the appropriate cells on the worksheet. Then enter the adjusting amounts in columns E and G. Also, in column D or F, insert the letter corresponding to the adjusting entry (a-d). Column A is "frozen" on the screen to assist you in completing requirement 3.
The trial balance of Wikki Cleaners at December 31, 2012, the end of the current fiscal year, is as follows:
Information for the adjusting entries is as follows:
a. Cleaning supplies on hand on December 31, 2012, $18,750.
b. Insurance premiums expired during the year, $1,800.
c. Depreciation on equipment during the year, $21,600.
d. Wages accrued but not paid at December 31, 2012, $1,830.
REQUIREMENT
Open the file F1WORK from the website for the book at cengagebrain.com. Enter the formulas in the appropriate cells on the worksheet. Then enter the adjusting amounts in columns E and G. Also, in column D or F, insert the letter corresponding to the adjusting entry (a-d). Column A is "frozen" on the screen to assist you in completing requirement 3.
Explanation
Verified
Verified
In the worksheet, record the following t...
Excel Applications for Accounting Principles 4th Edition by Gaylord Smith
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
