Number filters: greater than and between

Tip: Choose Save as PDF in the print dialog to download. Use A4 paper size.

Number filters: greater than and between

Name:
Date:
Class:
A

Quick Questions

Shade in the A or B circle for each question.

1. You want to keep only students with a Maths mark above 80. Which Number Filter condition do you choose?
A Greater Than... 80
B Less Than... 80
2. You want only days with a Max temperature from 20 to 25. Which Number Filter fits best?
A Between... 20 and 25
B Equals... 20
3. After you apply a Number Filter, what happens to the rows that do not meet the condition?
A They are deleted forever
B They are hidden but still in the sheet
4. Which menu option lets you filter a column of numbers by a condition like Greater Than?
A Text Filters
B Number Filters
5. A shop sheet has Price in column C. You filter Price with Greater Than 10. Which item stays visible?
A Calculator at $25
B Pencil at $1.50
B

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left columnRight column
1Number Filters > Greater Than... 80 ADeleting the visible rows after filtering removes real data, but a filter should only hide rows, not delete them
2Number Filters > Between... 60 and 80 BShows only the rows where the number is above 80 and hides the rest
3Find every student who scored more than 90 in Maths CThe lower value should come first, so the limits are in the wrong order and the range makes no sense
4Show only items that cost from $10 to $30 DShows only the rows where the number falls from 60 up to 80
5Filter Maths column > Greater Than... 80 and then press Delete on the visible rows to tidy up EMaths column > Number Filters > Greater Than... 90
6Number Filters > Between... 80 and 60 FPrice column > Number Filters > Between... 10 and 30
C

Definitions

Number Filter
D

Fill in the Blanks

Complete each line of code by filling in the missing parts.

1.
Column: Maths Number Filters > ____________ 80
2.
Column: Maths Number Filters > _______ 60 and 80
3.
=FILTER(A2:D9,B2:B9_80)
4.
Maths >= 60 ___ Maths <= 80
5.
Column: Maths Number Filters > ______ Top 3 Items
E

Spot the Error

Shade in the letter of the line that contains an error.

Question 1
A Click a cell in the table
B Turn on Filter in Data tab
C Text Filters > Greater Than
D Type 80 and click OK
Question 2
A Filter the Maths column (B)
B Pick Number Filters > Top 10
C From 60 to 80, then click OK
Question 3
A Goal: days with Max above 25
B Open Number Filters on Max
C Choose Less Than, enter 25
Question 4
A Goal: the 3 highest marks
B Number Filters > Between
C Set Top, 3, Items, then OK
Question 5
A Check: =COUNTIF(C2:C9,>10)
B Number Filters > Greater Than
C Enter 10 in the box, click OK

Answer Key

Number filters: greater than and between
Section A: Quick Questions
Q1
A — Greater Than... 80
Q2
A — Between... 20 and 25
Q3
B — They are hidden but still in the sheet
Q4
B — Number Filters
Q5
A — Calculator at $25
Section B: Match the Pairs
Q1
Number Filters > Greater Than... 80 → Shows only the rows where the number is above 80 and hides the rest
Q2
Number Filters > Between... 60 and 80 → Shows only the rows where the number falls from 60 up to 80
Q3
Find every student who scored more than 90 in Maths → Maths column > Number Filters > Greater Than... 90
Q4
Show only items that cost from $10 to $30 → Price column > Number Filters > Between... 10 and 30
Q5
Filter Maths column > Greater Than... 80 and then press Delete on the visible rows to tidy up → Deleting the visible rows after filtering removes real data, but a filter should only hide rows, not delete them
Q6
Number Filters > Between... 80 and 60 → The lower value should come first, so the limits are in the wrong order and the range makes no sense
Section C: Definitions
Q1
Number Filter — A filter that keeps only the rows where a number meets a condition, such as greater than a value or between two values. The other rows are hidden, not deleted.
Section D: Fill in the Blanks
Q1
Column: Maths Number Filters > Greater Than 80
Q2
Column: Maths Number Filters > Between 60 and 80
Q3
=FILTER(A2:D9,B2:B9>80)
Q4
Maths >= 60 AND Maths <= 80
Q5
Column: Maths Number Filters > Top 10 Top 3 Items
Section E: Spot the Error
Q1
C — Marks are numbers, so the menu to use is Number Filters. Text Filters only appears for text columns. The line should be 'Number Filters > Greater Than'.
Q2
B — Top 10 keeps the highest few items, not a range of values. To keep marks from 60 to 80, pick 'Number Filters > Between'.
Q3
C — Less Than keeps days below 25, but the goal is days above 25. The line should be 'Choose Greater Than, enter 25'.
Q4
B — Between needs a low and a high value and does not pick the highest rows. To get the 3 highest marks, use 'Number Filters > Top 10'.
Q5
A — The condition in COUNTIF must be inside quotes. It should be =COUNTIF(C2:C9,">10") so it can be used to check the filtered row count.