EY Interview Question

Excel question