Since the formatting of the templates is not protected by any password you may

Since the formatting of the templates is not

This preview shows page 1 - 3 out of 7 pages.

common presentation. Since the formatting of the templates is not protected by any password, you may change any of the formatting found in the templates to meet your desires. Where a yellow highlighted cell shows titles such as "Formula" you may enter the appropriate formula or enter a numerical value appropriate for that step of the challenge. Most of the values necessary for the appropriate formula are located on the template in cells with borders or in other yellow highlighted cells. The formula may be a simple "Look to" formula, an equal sign and a cell reference, "=E27" or more complex as "=E27*5," or something similar to the time-value-of-money formula. These are addressed in the tutorial text provided for Microsoft Excel. Where a yellow highlighted cell shows "Text" enter the appropriate text for that step of the challenge. This may be a memorandum entry for a journal entry or a lengthy text answer discussing the results of an analysis of a company's financials. These titles can simply be typed over. Where a yellow highlighted cell shows titles such as "Journal Number" or "Journ #" you should enter the appropriate number provided in the template and in the text for that step of the challenge. In general this will appear in instances such as "Record the following events in General Journal number six." Should you need to print, the print area is defined to fit onto 8 1/2" × 11" sheets in portrait or landscape mode as required. Margins are generally set to no less than 1/2" so most printers can print them without a problem. If you printer cannot accept margins less than 1" you may have to reformat the margins through Page Setup. The display may have "Freeze Pane" invoked so column titles remain visible during data entry. This can be removed by utilizing the View menu and selecting "Unfreeze Panes" under "Freeze Panes." When negative values are required, enter them by starting with a minus sign, "-". Negative values may be shown as ($400) or -$400. Negative values in formulas can be created by putting a minus sign in front of the cell reference - "=E10*-E11" will return a negative value if both cells E10 and E11 contain positive values. Microsoft Office and Microsoft Excel are products of, and copyrighted by, Microsoft Corporation, One Microsoft Way, Redmond, Washington 98052-6399
Image of page 1
Name: Peter Markovchick Date: 09/24/15 Instructor: Ingalls Course: BUA 201 Financial Accounting: Homework Chapter 4 E4-12, Prepare a correct income statement. The income statement of Garska Co. for the month of July shows net income of $2,000 based on Service Revenue $5,500 ; Salaries and Wages Expense $2,100 ; Supplies Expense $900 , and Utilities Expense $500 In reviewing the statement, you discover the following: 1. Insurance expired during July of $350 was omitted. 2. Supplies expense includes $200 of supplies that are still on hand at July 31.
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 7 pages?

  • Fall '10
  • LOVEJOY
  • Revenue, Expense, Generally Accepted Accounting Principles, Service Revenue

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture