{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ch04_06 - Solving Accounting Principles Problems Using...

This preview shows pages 1–3. Sign up to view the full content.

Solving Accounting Principles Problems Using Excel for Windows to accompany Accounting Principles Ninth Edition Rex A Schildhouse, LCDR, U.S. Navy, Retired, M.B.A. San Diego Community College District, Miramar Campus, San Diego, CA Jerry J. Weygandt, PhD, CPA, Arthur Andersen Alumni Professor of Accounting, University of Wisconsin, Madison, Wisconsin Donald E. Kieso, PhD, CPA, KPMG Peat Marwick Emeritus Professor of Accountancy, Northern Illinois University, DeKalb, IL Terry D. Warfield, PhD, CPA, PricewaterhouseCoopers Research Scholar, University of Wisconsin, Madison, Wisconsin

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

View Full Document
Section 2, Page 23 Common formatting tasks Chapter 4 BASIC EXCEL DATA Chapter Outline Basic Data Entry Nested Parentheses Sum Formula Recently Used Files Basic Formulas Undo And Redo Look To Formula Add Ins Mathematical Order Of Operations Basic Data Entry The best way to input data into Excel is in its most basic form and then let Excel format it through default or manually imposed formatting. Suppose you are asked to enter the value “123,456.789” into Excel. You may get “123.456.7890”, “123,456.789”, “123,456.79”, “123,456.8”, “123,457” or something else as Excel complies with its constraints of formatting and column width. This is shown in cell A1 of the “Inputs” tab of the Basic Data and Formulas reference file workbook. However, if you input “123456.789” without the comma, and then select the cell after input and click on the comma icon on the tool bar, shown in the screen print as one of the common formatting task, Excel will insert commas automatically. Once the commas are inserted, you can click on the decimal display icons, one to increase the significant digits displayed and one to decrease the significant digits displayed, to attain the correct number of decimals. Each click changes the decimal places by one place. Note: Changing the significant decimal places displayed does not change the significant digits held by Excel for computational purposes. Suppose that you had entered the “123,456.789” into cell E1 on the Input tab. In this cell there appears to be “####”. This is an indication by Excel that the numeric value in this cell exceeds the width or displayable area of the cell. If you click into this cell and make it the active cell, you will see that it contains the full value as keyed in. To resolve this presentation issue you can manually resize the column by placing your cursor over the small vertical line between the “E” column and the “F” column header markings. Your cursor will become a double-headed arrow with a vertical line through it such as: Once the arrow appears you can hold your left mouse button down and drag the column into a greater width. This should permit the full display of the contained value. You can try this on the “E” column of the Input tab of the Basic Data and Formulas workbook. You can also auto format the width of the column to the width of the widest data within the column by placing your cursor over the vertical line between the “E” and the “F” column and double- clicking the left mouse button when it becomes a double-headed arrow. This may not give you the full
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}