Riparian interview question

There was an excel test