Baycrest Hospital interview question

excel analysis, formulas and thought process