Mapup interview question

Explain the formula used in excel