Digitain interview question

Technical question regarding excel functions