The descriptions of the problems make it sound a little like algorithmic puzzles but your only tool is Excel instead of some programming language… Excel is pretty amazing in what you can do; I’ve regretted having to use Google Sheets for the last few years.
Yup. Not too long ago they added Python scripting. Definitely beats the weird cloud scripting you have to do with Google Sheets.
> but your only tool is Excel instead of some programming language
There is little difference between (if (> a b) c d) and =IF((A1 > B1), C1, D1)
Excel is the most widely installed functional programming language IDE.