If you've been using Google Sheets for a while, you probably know about the tips below. Click each dropdown to view a more advanced option.
Try double-clicking the divider between rows or columns to automatically make it the perfect size for any text it contains. This is a great way to eliminate empty space so that you can see more of your data!
A great next step is to represent your data visually using the Charts feature. Charts can be an accessible way to share your data with students or other stakeholders, and they update automatically when your data does.
You can take this to the next level by pulling data from other sheets. Just use ='SheetName'! followed by the cell or range.
Try conditional formatting to color-code your data, making it even more visually accessible. For example, you could assign colors to different score ranges so that you can assess students' performance with a quick glance. A great related option is alternating colors, which you can customize to make your data easier to view.
You can make changes to a Sheet without affecting the Form, making it easier to grade or give feedback in Sheets. For example, you can add checkboxes, apply conditional formatting, or alphabetize your student responses.