Greenwich Health interview question

What does COUNTA do in Excel? What does LET do in Excel? What is data normalisation?