Total Vision interview question

Excel formula. difference between some functions