Lucid Motors interview question

Few specific questions about advanced excel tools and data analytics.