Manipulation in excel and use macro

Hi,
Can anyone plz help with the correct answer for the uploaded image containing question.

Thanking you in advance