Physics 220

Excel[TM]

• If you want to clear the contents of a cell or agroup of cells, then select the cells
  
  and type: B.

• If you want to delete a cell or a group of cells entirely, then select the cells and
  
  type: K.

• The spreadsheet software can also graph data for you. Highlight the
  data you want graphed and then click the Graph Wizardbutton.

Answer the questions and Excelwill create a graph of the data. Make sure to
select xy scatterfor the chart type. This will create a graph as you usually do by
hand.

• If you would like to fit some data with an equation, first make a graph showing
  only the data you want to fit. Double click on that graph to make it active.
  Select the data series you wish to fit by clicking once on one of the data points.
  The entire set of data should then be highlighted. Select Trendline... under the
  Insert menu.

Choose the type of fit. Click on Options and select "Display equation on Chart".