Sony interview question

questions regarding excel and its formula