Digitain Interview Question

Technical question regarding excel functions