Excel templates for statistics displaying incomplete answers

I am taking an intro to statistics class, and we are allowed to use software with built-in templates to solve problems (in fact it's encouraged), but I am not very confident as far as creating complex tables, and have been trying to find pre-built tables so that I don't have to either a) learn Excel to the level that I could comfortably design my own templates or b) make a spreadsheet from scratch for each problem. There is a free online course from OER Commons that has template that would help me get through the huge volume of very similar problems I have to do, so far it's the only resource I have found that covers everything I need (I have looked at many sites that offer templates, so far the second best is one called Real Statistics, which has some helpful things but is not comprehensive). BTW I have tried using StatCrunch, which has all the functions that these OER spreadsheets do, but I find Statcrunch extremely clumsy, especially because it is very bad for doing basic calculations.
When I download the templates from OER Commons, via a page called "Excel Templates as a Statistical Tool," to my untrained eye, it appears that some of the formulas are either not active or did not download successfully, as certain cells which should autopopulate with answers remain blank after I enter data. I am wondering whether these templates are flawed, or whether there is a setting that I need to adjust in order to activate their full functionality. I used the Control + ~ button to try to see what formulas are there and which are missing, and the screenshots below show that only one of the expected formulas appears to be working. There are many different sheets, for different types of problems, but all suffer from this same problem of having only one or two functioning formulas.

I am wondering if there might be some things I could try to in order to restore the full functionality of these templates.

Sheet with formulas not displayed

Same sheet, formulas displayed-- only one seems to be present