I was asked a lot of questions on excel vba macros and advanced excel related operations.I was tested for my logical and critical thinking and reasoning skills.I was given a scenario and asked how to deal with it and what technique i would use to solve the issue and how would i start the programming process.