Question

Ryan has a table containing student details. The students have enrolled for various courses including Sociology, Anthropology, Philosophy, and so on. Ryan currently wants to view only the details of students who have enrolled for Sociology. What action should Ryan perform?
Ryan should apply a
on the Courses column and view all courses that show Sociology.

Answer 1

Answer:

Ryan should apply a FILTER on the Courses column and view all courses that show Sociology.

Explanation:

A filter on the column will present him with a selection of the different values present in that column (in this case the course subjects) and allow him to pick one (or more) items from that list.

The spreadsheet will then display only the rows containing that value (or those values) in that column.

Ryan will then be able to see which students enrolled in Sociology and only those.