NV Energy interview question

An Excel Test that was medium difficulty