Philips interview question

Data analysis questions on excel