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 - 4 out of 15 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.
Image of page 1
fdb75271e13ba3743b73bf0cace33d15ce77c612.xlsx, Page 2 of 15 Page(s), 10/05/201715:46:51 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 th 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 Genera 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 2
fdb75271e13ba3743b73bf0cace33d15ce77c612.xlsx, Page 3 of 15 Page(s), 10/05/201715:46:51 Name: Hannah Krasnow Date: 09/23/17 Instructor: Ingalls Course: BUA 201 Financial Accounting: Homework Chapter 4
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 15 pages?

  • Spring '14

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture