The previous Paycheck project made good use of the ability of Excel to rewrite formulas so that they can easily be moved around a spreadsheet. When the formula for the pay of one employee is copied or moved down to the next employee, the cell references are moved down as well so that the calculation is performed on a new set of data. Although this is extremely handy in most circumstances, it is not always the case, and this project involves such a scenario. There is also the opportunity to make visual use of that third dimension by creating a 3D graph to display an unfamiliar function.
This is a project that can be started from scratch. The first few steps should be familiar, but you will have to edit the functions in order to get them to copy correctly. Less attention will be dedicated to how the results should be achieved that to what the results are.
Create a spreadsheet called FunctionTables and save it with that exact name.
Rename the first tab to be called Addition.
In cell A1 enter the + symbol.
Enter 0 in cell B1 and 1 in cell C1.
Select both cells and then stretch the selection horizontally to cell K1 so that numbers 0 through 9 appear. (0 through 10 is also acceptable.)
Similarly enter 0 in cell A2 and 1 in cell A3.
Select both cells and then stretch the selection vertically to cell A11 so that numbers 0 thruogh 9 appear. (0 through 10 is also acceptable.)
In cell B2 enter the formula =B1+A2. You might enter the formula directly or click with the mouse to indicate which cells should be added.
Select cell B2 and stretch the selection horizontally and then vertically (or vice versa) so that the addition table is full.
Although the table is full, it contain the wrong answers. Why? The formula in C2 is =C1+B2. Its neighbor to the left has =B1+A2. That's not how the table should work. C2 should be =C2+A2. A2 should not have been changed to B2 because all the numbers to add are in the leftmost column and that shouldn't change as the formula is moved around. To pin the coordinate to the A column, put a dollar sign ($) in front of A in cell B2 so that the formula is =B1+$A2. Fill the table starting with that formula.
The results for the first row should now be correct. The values in the next rows, however, are not. B3 has changed from the original =B1+$A2 in B2 to =B2+$A3. B2 should have stayed B1, since the numbers to add are all in the first row. To prevent the change, add a dollar sign to make B$1. The formula for B2 should be =B$1+$A2. Fill the table with the correct formula and verify that answers are displayed correctly.
Rename the second tab Multiplication.
In the Addition tab, click on the corner between the A column and the 1 row so that the entire sheet is selected. Copy it with Ctrl+C, with a right mouse click, or with the menus. Change the the multiplication tab and paste. The entire table should appear in the new tab.
Change the corner cell from + to *. * is a common symbol used for multiplication in computer programming and applications.
Change cell B2 from =B$1+$A2 to =B$1*$A2.
Stretch B2 horizontally and then vertically (or vice versa) so that the entire table is filled with the products.
Rename the third tab Subtraction.
Copy the addition or multiplication table to the new sheet/tab.
Change the corner cell to -.
Change cell B2 to =B$1-$A2 or =$A2-B$1.
Stretch that cell again so that the entire table is filled with differences.
Insert a fourth sheet. One way to do this is to click on the tab next to the sheet names that has the tool tip "Insert Worksheet."
Call the sheet Division.
Copy a table to the new sheet.
Change the corner cell to /. It may be difficult to enter this character because it has other uses. You can type it into the Formula Bar.
Change cell B2 to =B$1/$A2 or =$A2/B$1.
Stretch that cell again so that the entire table is filled with quotients. Several of the cells should show #DIV/0! because, as you recall, division by zero is not allowed. They didn't just make that up for math class.
Insert a fifth sheet.
Call it Function.
Copy a table to the new sheet.
Change the corner cell to Function.
Make up a function for cell B2. See the Formulas tab for ideas. One example you can start with is =10-($A2*SIN(B$1*2*PI()/9))^2. Be sure to make some change to it, however. Preserve the $ sign in the cell names so that the formula copies properly to the other cells.
Stretch the cell to fill the entire table.
Now see what your functions look like by graphing them. Start with addition and make that sheet active. Select the portion of the table with the calculations (not the numbers to be added). Click on the Insert tab and find the Charts. You'll need a Surface which is usually categorized with the Other Charts. Choose it and you should see a 3D representation of addition. If you right click on the chart and choose 3-D Rotation... you can manipulate the chart for a better view. You might compare your chart to the sample document now because you will repeat this step four more times. It should look like an inclined plane.
Graph multiplication, which should look like a hill with increasing steepness.
Graph subtraction, which will be another inclined plane. This time it will extend below the z-axis.
Graph division. It is probably best to skip the cells with the division by zero error.
Graph your function. You can use Excel to visualize functions that you may not yet understand mathematically.
Compare your file with the sample document. Your function on the last sheet should not match the sample document. Use your own function instead. Email the file to the instructor or transfer it to the designated computer via a USB drive.
This project is just single sized. Each item listed in the instructions is worth a point.