excel_tutorial

# excel_tutorial - Excel 2007 Basic I Physics Teaching...

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

Excel 2007 Basic I Physics Teaching Laboratory, HKUST

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

View Full Document
Do You Know How to? create scatter plot? add chart title and axis title? add trendline to scatter plot? find errors of slope and intercept? add error bars to a scatter plot? create plots of two data series on one graph?
How to enter information into Excel 2007 An Excel spreadsheet is a series of small blocks (cells) where the columns are labeled with capital letters and the rows are labeled with numbers. To enter data into Microsoft Excel, simply type each entry into its cell. Enter your x-axis data into left column (e.g. A); y-axis data into right column (e.g. B).

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

View Full Document
You can type worksheet function in an empty cell, here are some examples: Sum of two numbers =A1+A2 Logarithm =log(A1) Sine =sin(A1) * note: the unit of data in A1 cell is radian Average =average(A1:A10) * note: (A1:A10) is range of data from A1 to A10 cells. You can find more function using Excel Help
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 03/31/2011 for the course PHYS 1 taught by Professor Nianlin during the Spring '11 term at HKUST.

### Page1 / 12

excel_tutorial - Excel 2007 Basic I Physics Teaching...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online