Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

if possible can you please add the link of your spreadsheet to your reply so i can copy the data and have it as a

if possible can you please add the link of your spreadsheet to your reply so i can copy the data and have it as a pre set
image text in transcribed
image text in transcribed
1. Row 1 - merge and center across columns A thru L. Font should be Arial, 14 pt., bold 2. Row 2 - merge and center across columns A thru L. Font should be Arial, 12 pt. 3. Row 3 - merge and center across columns A thru L. Font should be Arial, 12 pt. 4. Add background color to rows 1, 2 and 3, light gray (any shade is fine). 5. Increase the width of Column B, so that all the account names are completely visible within the column. 6. Format all the numbers to remove any decimal places. Remove any decimal places that show up while working in the worksheet. 7. Add a new row after row 14. 8. In the new row, add the Account Name - Carrie Carson, Drawing, and a debit balance of $1,000 9. Total columns C and D using the SUM function. 10. Add a double underline to columns C and D using cell borders. Here is a sample of what your Worksheet should look like, after step #10 11. Adjustments - in the adjustments columns, add adjustments for: o Supplies - supplies on hand at the end of the month were $300. o Insurance - one of the twelve months of prepaid insurance has expired. Annual premium = $2,400. Record depreciation on the Equipment of $100 for the month 12. Total the adjustments columns and complete the rest of the worksheet. All columns should be totaled using the SUM function. If you use your calculator, and just enter the total, you will not receive credit for it. Add the accounting double under border where appropriate. When completing the rest of the worksheet, do not just type the amounts into the income statement and balance sheet columns. Try using cell referencing to complete the remaining columns

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Accounting questions