0
0
Excelspreadsheet~10 mins

Query Editor interface in Excel - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sample data table with names, ages, and cities to demonstrate Query Editor filtering.

CellValue
A1Name
B1Age
C1City
A2Alice
B230
C2New York
A3Bob
B325
C3Los Angeles
A4Charlie
B435
C4Chicago
Formula Trace
=FILTER(A2:C4, B2:B4>28)
Step 1: B2:B4>28
Step 2: FILTER(A2:C4, [TRUE, FALSE, TRUE])
Cell Reference Map
    A       B       C
1 | Name  | Age   | City     |
2 | Alice | 30    | New York |
3 | Bob   | 25    | Los Angeles |
4 | Charlie | 35  | Chicago  |

Formula references B2:B4 for age filter and A2:C4 for data to filter.
The formula uses the Age column (B2:B4) to filter the data range (A2:C4).
Result
    A       B       C
5 | Alice | 30    | New York |
6 | Charlie | 35  | Chicago  |
Filtered result showing only rows where Age is greater than 28.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the expression B2:B4>28 return?
A[TRUE, TRUE, TRUE]
B[TRUE, FALSE, TRUE]
C[FALSE, TRUE, FALSE]
D[FALSE, FALSE, FALSE]
Key Result
FILTER(range, condition) returns rows from range where condition is TRUE.