Question: Mrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data efficiently without having to search through it manually?
- Protect the sheets to keep an original copy of the data in case of errors or accidental deletion of data.
- Use the “Scan All” function to locate specific values and student names.
- Use filters to display required data and hide unwanted data.
- Use charts to visually represent student progress.
The answer(s) to the question is highlighted in the BOLD text above. You can also find more questions and answers related to the exams on the “Google Educator Level 2” page.
