Spreadsheets I Exercise

In this exercise you create a balance sheet which calculates an organisation's quarterly balance by subtracting its total liabilities from its total assets.

What to do How to do it
Save a copy of the exercise file excel1.xls to your floppy disk.
  1. Right-click the link excel1.xls and click "Save Target As ..."
  2. Select 3 1/2 Floppy (A:) from the "Save In:" pull-down menu
  3. Double-click your folder
  4. Double-click the Spreadsheets folder
  5. Click the Save button
Open your copy of the file.
  1. Choose a file to be opened using one of the following methods:
    Open Microsoft Excel and either click File, Open, click the Open button, or Press Ctrl-O
    Open Windows Explorer or My Computer
  2. Double-click 3 1/2 Floppy (A:) or select it from the Look In: menu
  3. Double-click your folder
  4. Double-click the Spreadsheets folder
  5. Double-click excel1.xls
Display both Standard and Formatting toolbars.
  1. Check if the Standard and Formatting toolbars each take one row.
  2. If not, click View, Toolbars, Customize and click the Options tab.
  3. Remove the tick in the check box "Standard and Formatting toolbars share one row".
  4. You may also want to remove the tick "Menus show recently used commands first".
  5. Click the Close button.
Type Balance Sheet in the upper left cell.
  1. Click in cell A1.
  2. Type Balance Sheet and press Enter. Do not worry that the text goes beyond the cell border.
Put your name in cell A2.
  1. Type your first and last name and press Enter.
Put today's date in cell A3.
  1. Type in the date and press Enter.
Save your changes often.
  1. Press Ctrl-S.
Make column A just wide enough for the text in column A to fit.
  1. Move the cursor between column header buttons A and B.
    The cursor should become a double-arrow separated by a line.
  2. Double-click, or drag to the right until the text just fits.
Sum the assets for each quarter.
  1. Click in cell B15.
  2. Click the AutoSum button (Σ).
  3. Press Enter.
  4. Click in cell B15 again. You should see the formula =SUM(B7:B14).
  5. Repeat steps 1-3 for cells C15, D15 and E15.
Sum the liabilities for each quarter by filling right.
  1. Click in cell B23, click the AutoSum button and press Enter.
  2. Select cells B23 to E23.
    Either: drag with the mouse from the middle of cell B23 to the middle of E23,
    OR: Click in cell B23, hold down Shift, and press the right arrow key three times. 
  3. Click Edit, Fill, Right.
Add a column for total assets and liabilities. 
  1. Click in cell F5, type Total and press Enter.
Sum each of the assets.
  1. Click in cell F7, click the AutoSum button and press Enter.
  2. Click in cell F7 again.
  3. Move the mouse pointer to the fill handle (black square in lower right corner of cell F7). 
    The pointer should become a black +.
  4. Drag the fill handle down to cell F15.
Sum each of the liabilities.
  1. Click in cell F7 and click the Copy button.
  2. Click in cell F18 and click the Paste button.
  3. Drag the fill handle down to F23.
Calculate the balance for each quarter.
  1. Click in cell B25, type =B15-B23 and press Enter.
  2. Click in cell B25 and drag the fill handle across to cell F25.
Format all of the numbers as dollar currencies with no decimal places.
  1. Select the range of cells B7:F25.
    Either: drag with the mouse
    OR: Click in cell B7, hold down Shift, and click in cell F25
  2. Click the Currency ($) button on the formatting toolbar.
  3. Click the Decrease Decimal button on the formatting toolbar two times
    OR: click Format, Cells, make the Decimal places 0, and click OK
Make all text in column A bold.
  1. Select column A by clicking on the column (A) button. 
  2. Click the Bold (B) button on the formatting toolbar.
Fill the Balance row with yellow background.
  1. Select row 25 by clicking the row (25) button.
  2. Select the yellow colour from the Fill Color menu on the formatting toolbar.
Center the four quarters and total.
  1. Select from cell B5 to F5 (using the mouse or shift-click techniques described above).
  2. Click the Center button on the formatting toolbar.
Center the sheet title across the top of the document. 
  1. Select from cell A1 to F1.
  2. Click the Merge and Center button on the formatting toolbar.
Give the sheet title a different font and larger size.
  1. Select Arial Black or another font from the Font menu.
  2. Select 18 from the Font Size menu.
Save your changes to the document and exit.
  1. Press Ctrl-S to save the document.
  2. Click File, Exit to close Excel.