Excel & Sheets practice: The IF Function & Boolean Tests

Chapter 2 · 2 questions · free to solve

Question 1 · easy
Big or regular?
In K2, return "Big" when the order's Revenue is 30,000 or more, otherwise "Regular". Fill down to K21.
Solve it in your browser
Question 2 · medium
Priority sheet orders
Tag an order "Priority" when its Category is Sheets and it has 10 or more Units. Otherwise leave the cell looking empty (""). Start in K2, fill to K21.
Solve it in your browser

These questions are free.

Make a free account to solve them, with instant checking and an AI tutor for hints.

Big or regular?