Excel & Sheets practice: Dynamic Array Filtering
Chapter 25 · 5 questions · included in full access
Question 1 · easy
All orders for one region
Solve it in your browserSpill the OrderID, Rep and Revenue of every order whose Region matches M1, starting in K2.
Question 2 · medium
Big Sheets orders (AND)
Solve it in your browserSpill the OrderIDs of orders in the Sheets category with Revenue over 30,000, starting in K2.
Question 3 · medium
North or small (OR)
Solve it in your browserSpill the OrderIDs of orders that are from the North or have Revenue under 10,000, starting in K2.
Question 4 · medium
FILTER, Sheets style
Solve it in your browserSpill the OrderIDs of South orders with Revenue above 15,000 from K2, giving FILTER the two conditions as separate arguments.
Question 5 · easy
#SPILL!
Solve it in your browser=SORT(UNIQUE(C2:C21))in K2 suddenly shows#SPILL!. What is the most likely cause?
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing