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?

Question

Raiden Friedman

Computers & Technology

21 April, 13:10

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?

+4

Answers (1)

Know the Answer?

Ariel Mora · Answer 1

apply a filter by age with a value more than 20

Explanation:

First, we must create the spreadsheet with the fields student, age, grade level, major and minor.

For example:

If we want to create a filter, we must mark headings with the left click, then we must go to the tab Home - -> at the section Editing, click in Sort & filter then Filter.

We must click in the field Age - -> number filters - -> greater than 20.