optional spreadsheet processing intregration activity help

Optional spreadsheet and word processing integration activity. Step 22: om the on on the Joyce Morrow, owner, asked you to create a spreadsheet report show ing only the cash receipt transactions entered into the accounting system for the month of December. Prepare an interoffice memoran- dum that contains this information. Use the following steps to complete this task a. Display and copy the general journal report to the clipboard in b. Start your spreadsheet software and load spreadsheet template file c. Select cell Al as the current cell (if not already selected) and paste d. Delete all rows of data that are not cash receipt transactions, change spreadsheet format. IA8 Spreadsheet 02-s. the general journal report into the spreadsheet. heet. the title of the report from General Journal to Cash Receipts, and replace the old totals with the sum of the debit and credit columns. Format the spreadsheet similar to Figure 2.32 e. Print the Cash Receipts report. f. Save your spreadsheet file to your disk or folder with a file name of 02-A Your Name. g. Select and copy the spreadsheet report to the clipboard. h. End your spreadsheet application. i Start your word pcessing application softwu mte IA8 Wordpnscessing 02 AB (load as ae and load tem n (load as a document file) name k Position the insertion point one line after the last ment and paste the spreadsheet report. Format Replace FROM Stulent Name with your Au lsheet report Format your do document Nan necessary Dir L Print the completed document. m. Save the document to your disk or folder with a file Your Name to the Integrated n. End your word processing application and retu Accounting application Step 23: Generate and post the closing journal entries. Click on the Gen. Led. navigation button, and then click the Closing Entries menu button. When the dialog box appe you want to generate closing jounal entries, clickYng i journal entries automatically generated by the computerwillclosing a dialog box. Click Post. When the general journal that the closing entries have been posted, click Close. howing Step 24: Display the closing entries. Click on the Gen. Led. navigation button, and then click the Jour Report choose the Journal option and the Gieneral Journal report (if not alread selected) and click OK. When the Journal Report Selection dialog box appears, choose the C erence restriction of Clo.Ent. so that only the closing entries are s menu button. When the Report Selection window appears. ustomize Journal Report option and enter a Ref- reported. p 25: Display a trial balance (called the post-closing trial balance). p 26: Save your data to disk with a file name of 02-AAC Your Name where 02-A is the problem, and AC is "After Closing." If you have access to the Internet, use the browser to find accounting serv- ices provided via the Internet. For example, use accounting services to narrow your search. Report what types of accounting services you find. Be sure to include the source and the URL (Web address) of your search. 7: Use the Check toolbar button to check your work. : End the Integrated Accounting 8e session. Optional spreadsheet and word processing integration activity. Step 22: om the on on the Joyce Morrow, owner, asked you to create a spreadsheet report show ing only the cash receipt transactions entered into the accounting system for the month of December. Prepare an interoffice memoran- dum that contains this information. Use the following steps to complete this task a. Display and copy the general journal report to the clipboard in b. Start your spreadsheet software and load spreadsheet template file c. Select cell Al as the current cell (if not already selected) and paste d. Delete all rows of data that are not cash receipt transactions, change spreadsheet format. IA8 Spreadsheet 02-s. the general journal report into the spreadsheet. heet. the title of the report from General Journal to Cash Receipts, and replace the old totals with the sum of the debit and credit columns. Format the spreadsheet similar to Figure 2.32 e. Print the Cash Receipts report. f. Save your spreadsheet file to your disk or folder with a file name of 02-A Your Name. g. Select and copy the spreadsheet report to the clipboard. h. End your spreadsheet application. i Start your word pcessing application softwu mte IA8 Wordpnscessing 02 AB (load as ae and load tem n (load as a document file) name k Position the insertion point one line after the last ment and paste the spreadsheet report. Format Replace FROM Stulent Name with your Au lsheet report Format your do document Nan necessary Dir L Print the completed document. m. Save the document to your disk or folder with a file Your Name to the Integrated n. End your word processing application and retu Accounting application Step 23: Generate and post the closing journal entries. Click on the Gen. Led. navigation button, and then click the Closing Entries menu button. When the dialog box appe you want to generate closing jounal entries, clickYng i journal entries automatically generated by the computerwillclosing a dialog box. Click Post. When the general journal that the closing entries have been posted, click Close. howing Step 24: Display the closing entries. Click on the Gen. Led. navigation button, and then click the Jour Report choose the Journal option and the Gieneral Journal report (if not alread selected) and click OK. When the Journal Report Selection dialog box appears, choose the C erence restriction of Clo.Ent. so that only the closing entries are s menu button. When the Report Selection window appears. ustomize Journal Report option and enter a Ref- reported. p 25: Display a trial balance (called the post-closing trial balance). p 26: Save your data to disk with a file name of 02-AAC Your Name where 02-A is the problem, and AC is "After Closing." If you have access to the Internet, use the browser to find accounting serv- ices provided via the Internet. For example, use accounting services to narrow your search. Report what types of accounting services you find. Be sure to include the source and the URL (Web address) of your search. 7: Use the Check toolbar button to check your work. : End the Integrated Accounting 8e session