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.
Explanation
Filters in Google Sheets narrow visible rows so patterns in grade data can be reviewed without manually scanning every entry. Filter views can also preserve different analysis views without changing the underlying spreadsheet for others. Charts convert spreadsheet values into visual summaries that make progress, comparisons, and trends easier to interpret. These features support efficient data analysis while keeping the original data in one organized sheet.
Why the other options are incorrect
Protect sheets helps prevent unwanted edits, but it does not analyze grade patterns.
Scan All is incorrect because Google Sheets does not use this named feature for data analysis.
Source for verification
https://support.google.com/docs/answer/3540681?hl=en
https://support.google.com/docs/answer/63824?hl=en
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.