A couple of days ago I helped a reader who needed a quick way to sort Google Forms responses so that the most recent submission was always easy to find. I’m guessing that there’s probably a Microsoft Forms user out there who would like to know how to do a similar thing. That’s why I created this short tutorial video. In the video that is embedded below you can see how to sort responses to Microsoft Forms according to most recent submission.
Applications for Education
Sorting the Google Sheet attached to a Google Form is something that I’ve done for years. The same can be done with Microsoft Forms and Excel. I do that so when I have students completing something like a practice quiz over the course of a week I can quickly find the latest submission and review it with a student without having to constantly scroll to the bottom of the sheet.