SEON interview question

Advenced excel knowledge was tested