Excel Spreadsheet Intro

Save these in a NEW WORKBOOK Titled "Excel Intro"

Excel has many functions

We will start by looking at basic functions and formats.

formula

Start by duplicating the information in each cell for Row 1, and Row 2.

The location of each black box is where a variable is entered.

Each cell where there is a 0 is the location of a formula of which there are 4. The formula is the mathmatical function in the equation before it. Example: Cell D3 is the mathmatical function of A3 X C3 also known as the product. There are 4 mathmatical functions. Each function deals with two numbers, (Cells) and a process.

Enter the correct formulas in the correct cells in the formula bar.

To see if you are correct enter 2, 3, 4, 5, 6 in all of the variable locations. Check with the instructor to see if your answer, therefore your equations are correct.

This tab needs to be titled "Formula" in this workbook.

Intro

On a second tab titled "Variables" we are going to create a variables chart that links to the formula tab. In this worksheet we are going to link to the "Formula" sheet so that information entered on this chart will automatically fill in the formula page, and display the answer from the formula page. There are 4 mathmatical functions. Each function deals with two numbers, (Cells) and a process.

Enter the correct formulas in the correct cells in the formula bar.