Pergunta de entrevista da empresa Bank of America

1) As this is heavily excel-based, thus interview question was on the excel problem.