CSAV Process Executive interview questions

Advance Excel, I was told that this profile require excel but on very basic levels, but taking a test of vlookup, pivot table was a clear sign that we are not willing to hire you. Not only this but they were offering rs9500 in hand salary and they took "4" rounds of interview. huh.