Ask Question
13 July, 18:52

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?

+3
Answers (1)
  1. 13 July, 21:30
    0
    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.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “The spreadsheet below shows the age, grade level, major, and minor of four students in college. A purple background in the Major column ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers