Ask Question
10 June, 17:41

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)
  1. 10 June, 17:50
    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?
Find 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 and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers