Brother International WP230B Owners Manual - English - Page 241

Templates You can use any of the pre-formatted templates or create spreadsheets of your own. For all templates, enter the data in the blank cells only. Never enter data into the cells that contain a formula. Listed below are the templates that we have already designed for your use. These files come with an easy-to- use format. All you need to do is enter your data. The cells that are supposed to display a result already contain the appropriate formulas and format. After you have completed your work on the template spreadsheet, you can give your template a file name and save it on a diskette. Each time you select a template from the Template diskette, a new blank file appears. To recall a template that you previously worked with, recall it from the diskette by the file name you assigned. Description of the Templates INTRO -This template is actually an overview file that contains a written introduction to Spreadsheet. It discusses some of the features and capabilities of the Spreadsheet application. TELEPHONE AND ADDRESS DIRECTORY - This template allows you to keep an organized listing of names and addresses. With the sort capability, you can rearrange this file alphabetically after each addition or edit. CHECKBOOK - This Checkbook template resembles the ledgers that you receive from your bank. It calculates the balance after you enter your deposits and withdrawals. After entering your deposits and withdrawals, select RECALC from the function menu to process the balance column. If you later make changes or additions to the data you entered in the checkbook, use the RECALC function to determine the new balance. MONTHLY BUDGETING - This template helps you keep your personal finances in order. It outlines your monthly expenses. Once your expenses are itemized, use the RECALC function to determine your budget results. Later, if you make changes to the budget, use the RECALC function to determine the new totals. SALES ANALYSIS - This template helps monitor actual versus projected sales results of salespersons. Enter the data for all the cells with the exception of the cells containing formulas (zeros). After you have entered the information for each salesperson, use the RECALC function to determine the results. Later, if you make changes or additions to the template, use the RECALC function to see the new results. ANNUAL YIELD (COMPOUND) - This template figures annual yield according to the annual interest rate. Type in the annual interest rate. Use the RECALC function to see the results. Spreadsheet 229