Bookmark and Share

Excel 2007
Knowledge for Physics

OpenOffice, a free alternative to Excel can be downloaded by click here or going to OpenOffice.org.

Objectives

  • Learn how to use Microsoft Excel
  • Learn how to insert data into a spreadsheet
  • Learn how to format data and cells in Excel
  • Learn how to sort data in Excel
  • Learn how to do calculations in Excel
  • Learn the difference between absolute and relative cell references
  • Learn how to add rows and columns in Excel
  • Learn how to insert text boxes in Excel
  • Learn Learn how to create graphs in Excel
  • Learn how to add and format trendlines in Excel

What is Microsoft Excel?

Microsoft Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis. Excel and other spreadsheet programs are used throughout the world in jobs, ranging from Accounting to Actuaries, from Insurance Agencies to Manufacturing industries, and in Academia and Science related fields like biology and physics.

Vocabulary

  • Absolute Reference –  Absolute ranges have a $ character before the column portion of the reference and/or the row portion of the reference.  The $ character indicates to Excel that it should not increment the column and/or row reference as you fill a range with a formula or as you copy a range. If you enter =A1 in a cell and then fill that cell down a column, the '1' in the reference will increment in each row. Thus, the formula in row 50 would be =A50. However, if you enter =$A$1 in a cell and fill down, the range reference will remain $A$1 -- it will not increment as you fill or copy down a column.

  • Automatic Cell Filling – The ability to fill out some cells with values that belong to a common series.


  • Cell – the small boxes where data exists in a spreadsheet

  • Column – Cells that are in a vertical line of each other

  • Function – just like in math, an operation performed on variables or constants

  • Rows – Cells that are in a horizontal line of each other

The Assignment

Your assignment is to complete all of the steps below and submit to your course instructor all of the pages that you are asked to print in the document below. These pages should be submitted in the order they appear, and should be stapled together.