| This homework
counts for 5% of the homework grade. |
| Create a Times Table as described below. Bring
a printout of the entire table and a diskette with the Excel spreadsheet
containing your Times Table. To get full credit, you must be able
to demonstrate that the Times Table looks and functions as described. |
| At a minimum, your Times Table must
include: |
| An Excel table that shows all of the multiplication combinations
for 1x1 through 20x20 (see table below). If you plug in the correct equations,
then you only need to write about 5 different equations for the entire
table. Format your table using: lines/borders, number format, colors, fonts,
styles, alignment, column width, etc. Format your printout using headers
& footers. |
| The technical description of how your
Times Table should work is described below: |
| Times
Table |
|
1
|
1
|
2
|
3
|
...
|
19
|
20
|
|
1
|
1
|
2
|
3
|
...
|
19
|
20
|
|
2
|
2
|
4
|
6
|
...
|
38
|
40
|
|
3
|
3
|
6
|
9
|
...
|
57
|
60
|
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
|
19
|
19
|
38
|
57
|
...
|
361
|
380
|
|
20
|
20
|
40
|
60
|
...
|
380
|
400
|
|
| The green cells represent the numbers being multiplied.
The blue cells represent the results of the multiplication (i.e.
2 x 2 = 4). The yellow cells represent the columns and rows
for 4 through 18. Even though these are not shown above, they should be
included in your spreadsheet. |
| The red cell is a special value as
described below: |
When the red cell is 1, then the green cells increase
by 1 (i.e. 1, 2, 3, 4,...,19, 20), as shown above.
When the red cell is 2, then the green cells increase
by 2 (i.e. 2, 4, 6, 8,...,38, 40), as shown below.
When the red cell is 3, then the green cells increase
by 3 (i.e. 3, 6, 9,12,...,57, 60), not shown. |
|
2
|
2
|
4
|
6
|
...
|
38
|
40
|
|
2
|
4
|
8
|
12
|
...
|
76
|
80
|
|
4
|
8
|
16
|
24
|
...
|
152
|
160
|
|
6
|
12
|
24
|
36
|
...
|
228
|
240
|
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
|
38
|
76
|
152
|
228
|
...
|
1,444
|
1,520
|
|
40
|
80
|
160
|
240
|
...
|
1,520
|
1,600
|
|
|