Total Vision Interview Question

Excel formula. difference between some functions