the spreadsheet below shows the age, grade level, major, and minor of four students in college. a purple…

the spreadsheet below shows the age, grade level, major, and minor of four students in college. a purple background in the major column indicates that a student has previously changed his or her major. which tool can be used so that the spreadsheet shows information only for students older than 20? sort by age from smallest to largest sort by age from largest to smallest filter by age on values greater than 20 filter by age on values less than 20

the spreadsheet below shows the age, grade level, major, and minor of four students in college. a purple background in the major column indicates that a student has previously changed his or her major. which tool can be used so that the spreadsheet shows information only for students older than 20? sort by age from smallest to largest sort by age from largest to smallest filter by age on values greater than 20 filter by age on values less than 20

Answer

Brief Explanations:

To show only students older than 20, we need to select data based on a specific age - related condition. Sorting arranges data in order but doesn't select based on a condition. Filtering allows us to pick data that meet a certain criterion. Here, the criterion is age values greater than 20.

Answer:

filter by age on values greater than 20