ParallelDots interview question

Advanced excel formulas - Vookup, Hlookup, index match, conditional formatting, sorting, Pivot tables.