Step 1: Create a table, place the cursor in the cell where the formula needs to be inserted, and then click the fx button:

Step 2: Enter =sum (above) in the formula to automatically calculate the total score.

Step 3: Copy the formula to the other two columns.

Step 4: Press ctrl+A, select all, and then press F9 to recalculate the values of all formulas:

Note that if you change the values of cells, you can select all cells and press F9 to recalculate, or you can right-click the formula to update the fields.