Hints for using Excel at the Math Emporium

Select a topic:

- Entering and Displaying Data
- Entering Data: Putting data in Excel
- Cell Formatting: Decimal places, centering, etc.
- Filling Series: Automatically fill in numbers

- Formulas
- Cell References: Identifying cells and ranges
- Entering Formulas: Calculating a value based on other cells
- Filling Down: Copying a formula down a row or column; creating a table of values
- Relative and Absolute References: Specifiying a fixed or variable cell address
- Special Functions in Excel: Sums,
*e*, ln, pi, and square roots^{x}

- Graphing
- Graphing a Function: Plotting basics
- Adding a Trendline: Create an approximate function from data

- Preparing for Printing
- Textbox: Used for displaying text answers; creating, moving, resizing.
- Print Preview: Making sure your document will print correctly

You are also encouraged to make use of Excel's built-in help, which is very good.

Return to Labs Page