Sony Interview Question

questions regarding excel and its formula