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 - 6 out of 9 pages.

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.
Background image
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."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
Background image
Background image
Background image
7f1961bd753d5edbe42cdecced364aa115ff53d5.xls, Problem P4-1A, Page 5 of 9 Page(s), 10/08/201808:26:19Name:Date:Instructor:Course:P4-1A, Prepare worksheet, fi nancial statements, and adjusting and closing entries.Omer Asik began operations as a private investigator on January 1, 2012. The trial balance columns of the worksheet for Omer Asik, P.I. at March 31 are as follows.OMER ASIK, P.I.WorksheetFor the Quarter Ended March 31, 2012Trial BalanceAdjustmentsAdjusted Trial BalanceIncome StatementBalance SheetAccount titlesDr.Cr.Dr.Cr.Dr.Cr.Dr.Cr.Dr.Cr.Cash11,400 Accounts Receivable5,620 Supplies1,050 Prepaid Insurance2,400 Equipment30,000 Notes Payable10,000 Accounts Payable12,350 Owner's Capital20,000 Owner's Drawings600 Service Revenue13,620 Salaries and Wages Expense2,200 Travel Expense1,300 Rent Expense1,200 Miscellaneous Expense200 55,970 55,970 Supplies ExpenseDepreciation ExpenseAccumulated Depreciation - EquipmentInterest ExpenseInterest PayableInsurance ExpenseTotals
Background image
Image of page 6

You've reached the end of your free preview.

Want to read all 9 pages?

  • Fall '14
  • Balance Sheet, Generally Accepted Accounting Principles, Account title

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture