Skip to content
GridBelt
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign in
Start the free test
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign inCreate account
Start the free test
GridBelt

Practice Excel in your browser.

Excel Test

  • Level 1: Beginner
  • Level 2: Intermediate
  • Level 3: Expert
  • Excel test in 7 days
  • Leaderboard
  • Excel test for interview
  • Indeed Excel assessment

Practice

  • All exercises
  • Programs
  • For beginners

Guides

  • Excel formulas
  • Excel shortcuts

Company

  • About
  • Pricing
  • How we grade

© GridBelt. All rights reserved.

  • Privacy Policy
  • Terms of Use
  • Refund Policy

Excel is a trademark of Microsoft Corporation. Indeed, TestGorilla, SHL and other marks are the property of their owners. GridBelt is an independent practice site and is not affiliated with, endorsed by or sponsored by Microsoft, TestGorilla, SHL or Indeed.

  1. Practice
  2. Logic & Conditional Math

IF Function Practice Exercises: IF, AND, OR, Nested IF, IFS

Pass/fail flags, eligibility rules and tiered commissions on real-size datasets.

7 exercises, about 42 min

  1. 16Pass or Fail with IFBeginner~4 minBeginner, ~4 min
  2. 17Bonus eligibility with IF and ANDBeginner~5 minBeginner, ~5 min
  3. 18Free-shipping flag with IF and ORBeginner~6 minBeginner, ~6 min
  4. 19Flag rows with missing dataIntermediate~5 minIntermediate, ~5 min
  5. 20Margin % without #DIV/0!Intermediate~6 minIntermediate, ~6 min
  6. 21Commission tiers with nested IF, IFS or a lookupIntermediate~8 minIntermediate, ~8 min
  7. 22Region names from codes with SWITCH or IFSExpert~8 minExpert, ~8 min