1 2 3 4

Physics 220

Excel[TM]

IMAGE imgs/hints_for_using_excel05.gif

If you want to insert dollar signs, you can place the cursor in the cell reference

in the equation and type T. This will insert dollar signs automatically for
you.

  • You


can


also


enter


functions


in


your


equations,


such


as


the


function

AVERAGE(cell#:cell#)

IMAGE imgs/hints_for_using_excel06.gif

  • If you are unsure the exact format of
    a specific function, then you can use
    the Function Wizard to use a
    function.

IMAGE imgs/hints_for_using_excel08.gif

IMAGE imgs/hints_for_using_excel07.gif

  • You can adjust the number of significant figures that are displayed in a cell with
    these buttons:
    IMAGE imgs/hints_for_using_excel09.gif
  • If you want to erase the contents in a cell or a
    group of cells, then you should highlight the
    cells. Use the cursor to select the bottom
    corner (as if you were going to copy) and
    then, while still holding down the mouse
    button, drag the cursor back over all the
    selected cells. This will then erase all
    content from these cells.

IMAGE imgs/hints_for_using_excel10.gif