ACCT 201 Case Spring 2014 Excel Directions: Purpose: Adjusted Trial Balance Page 16 Prepare a set of financial statements using Excel 1. Start Excel and open new worksheet Right click the Sheet 1 tab and rename the worksheet to Adjusted Trial Balance, and then press Enter 2. 3. To create a title for the trial balance and properly format it, click cell A1 4. Click cell A2 and type Adjusted Trial Balance, and then press Enter. 5. Click cell A3 and type December 31, 2017, then press Enter 6 Click and drag the mouse pointer over cells A1 through Di. To center the title over the Trial Balance worksheet and type Big Data Company, then press Enter adjusted trial balance, click the Merge and Center tool on the toolbor. This action me cells Al, B1, C1, and Dl and centers the text in cell Al over all four. rges Perform the same steps to merge and ce nter the statement title and period for cell A2 and then cell A3. (If your date is no longer displayed as December 31, 2017, you'll need to change the cell format to Date and this type of format under Type heading.) 7. 8. Click and drag the mouse pointer over all four newly merged cells, then click both the Bold and 9. Beginning in cell A5, type the account titles of all the accounts exactly as shown in the Big 10. Resize Column A to fit the account titles Italics tools on the format menu Data Comprehensive Case Adjusted Trial Balance. DO NOT ABBREVIATE In column C (for debits) and column D (for credits), enter the account balances in the appropriate column 11. 12. Ploce formulas in the appropriate cells to sum the debit and credit columns BE SURE TO CHECK THAT THE TOTALS IN THE DEBIT COLUMN EQUAL THE TOTALS IN THE CREDIT COLUMN To complete the Trial Balonce you will need to properly format the worksheet. you will need to format number cells with the comma format. In other cases it is necessary to format number cells with the currency format. Be sure to indicate subtotals and totals with 13 In some cases, the correct underlining (single or double). These can be found under the Font tab. 14. Place a customized footer in the document (found under insert). Place your name and date in the left section of the footer and the file name in the right section of the footer Finally, you should save your work and print the adjusted trial balance. Be sure to set the print option to print to one poge. (In page layout tab, set width to 1 page.) 15. ACCT 201 Case Spring 2014 Excel Directions: Purpose: Adjusted Trial Balance Page 16 Prepare a set of financial statements using Excel 1. Start Excel and open new worksheet Right click the Sheet 1 tab and rename the worksheet to Adjusted Trial Balance, and then press Enter 2. 3. To create a title for the trial balance and properly format it, click cell A1 4. Click cell A2 and type Adjusted Trial Balance, and then press Enter. 5. Click cell A3 and type December 31, 2017, then press Enter 6 Click and drag the mouse pointer over cells A1 through Di. To center the title over the Trial Balance worksheet and type Big Data Company, then press Enter adjusted trial balance, click the Merge and Center tool on the toolbor. This action me cells Al, B1, C1, and Dl and centers the text in cell Al over all four. rges Perform the same steps to merge and ce nter the statement title and period for cell A2 and then cell A3. (If your date is no longer displayed as December 31, 2017, you'll need to change the cell format to Date and this type of format under Type heading.) 7. 8. Click and drag the mouse pointer over all four newly merged cells, then click both the Bold and 9. Beginning in cell A5, type the account titles of all the accounts exactly as shown in the Big 10. Resize Column A to fit the account titles Italics tools on the format menu Data Comprehensive Case Adjusted Trial Balance. DO NOT ABBREVIATE In column C (for debits) and column D (for credits), enter the account balances in the appropriate column 11. 12. Ploce formulas in the appropriate cells to sum the debit and credit columns BE SURE TO CHECK THAT THE TOTALS IN THE DEBIT COLUMN EQUAL THE TOTALS IN THE CREDIT COLUMN To complete the Trial Balonce you will need to properly format the worksheet. you will need to format number cells with the comma format. In other cases it is necessary to format number cells with the currency format. Be sure to indicate subtotals and totals with 13 In some cases, the correct underlining (single or double). These can be found under the Font tab. 14. Place a customized footer in the document (found under insert). Place your name and date in the left section of the footer and the file name in the right section of the footer Finally, you should save your work and print the adjusted trial balance. Be sure to set the print option to print to one poge. (In page layout tab, set width to 1 page.) 15
