TikTok interview question

Excel test was presented on the spot