The most common reason why users find that the output of the template does not reflect the inputs is that the input data is not entered inside the tables correctly. To know if your data is inside the Table, click on the cell and see if Table Tools ribbon appears.
If it does, your data is inside the table. If not, it is not inside the Table and hence will not be reflected in any dependent calculations.
If you are inside the table and want to know the boundaries of the table, press Ctrl+A. Excel will select all the data cells inside the table and thus show us the boundaries.
To know more about the table, please check the below article: