Intensity interview question

Basics questions, plus a technical excel challenge