Pergunta de entrevista da empresa Samsung Electronics

How are you? And Gave me an Excel problem to be solved using pivot tables and financial formulas.