Pergunta de entrevista da empresa Greenwich Health

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