{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

SUA Spreadsheet Instructions

SUA Spreadsheet Instructions - SYSTEMS UNDERSTANDING AID...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
SYSTEMS UNDERSTANDING AID INSTRUCTIONS AND ASSIGNMENT SCHEDULE FOR USING THE ELECTRONIC SPREADSHEET PORTION OF THE ASSIGNMENT Option 1 The purpose of this exercise is to show you that the preparation of a year-end worksheet, financial statements, and a post-closing trial balance with the use of an electronic spreadsheet is extremely simple and is an important way to save time. 1. Do not begin the spreadsheet application until the entire Systems Understanding Aid project is completed, including "WRAPPING UP" on page 15 of the Instructions, Flowcharts, and Ledgers book. 2. Obtain instructions from your course instructor on how to obtain a copy of the SUA spreadsheet file. This file will be used to prepare Waren's year-end worksheet, financial statements, and post-closing trial balance. The spreadsheet is available in Microsoft Excel 97. Your instructor will provide you with the appropriate file. 3. After obtaining the appropriate file from your instructor, open it using MS Excel. If you are using transactions list A for the SUA project, the file you will use is named “SUA version A.xls.” If you are using transactions list B for the project, the file you will use is named “SUA version B.xls.” After opening the file, you will be in the year-end worksheet portion [sheet 1] of the file. The financial statements [sheets 2, 3, and 4] and the post-closing trial balance [sheet 5] are separate sheets stacked behind this front sheet.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}