Shopee interview question

Excel formula and pivot table.