SBICAP Securities interview question

Advance Excel hands on task.