AutoSense interview question

regarding excel basics and data visualisation