Finalizing your workbook design

 

✦ Enter the title of the data table in the first cell, which forms the left and top edges of the table.

 ✦ Enter the row of column headings in the row below this cell, starting in the same column as the cell with the title of the table.

 ✦ Enter the row headings down the first column of the table, starting in the first row that will contain data. (Doing this leaves a blank cell where the column of row headings intersects the row of column headings.)

✦ Construct the first formula that sums columns of (still empty) cell entries in the last row of the table, and then copy that formula across all the rest of the table columns.

✦ Construct the first formula that sums the rows of (still empty) cell entries in the last column of the table, and then copy that formula down the rest of the table rows.

✦ Format the cells to hold the table values and then enter them in their cells, or enter the values to be calculated and then format their cells. (This is really your choice.)