Pergunta de entrevista da empresa Collegedunia

Basic excel questions, Explanation of the assignment