Operators - Free Excel Practice Online

This free, interactive exercise teaches you Operators in Excel through 6 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Logical Functions track and works right in your browser - no Excel install, no download, and no signup.

Practising Operators this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this Operators lesson

1. The & operator joins text together. Join the item name and its actual figure by typing =A2&": "&C2 in E2. - & glues values into one piece of text. A2 is Widget, the ": " in quotes is literal text, and C2 is 60, giving Widget: 60. Anything inside quotes is used exactly as typed.
2. The comparison operators =, >, <, >=, <= and <> return TRUE or FALSE. Did the Widget beat its target? Type =C2>B2 in E2. - > asks "is the left side bigger?". Actual is 60 and Target is 50, so the answer is TRUE. A comparison always returns TRUE or FALSE, never a number.
3. <> means "not equal to". Check whether the Gizmo missed its target by typing =B4<>C4 in E4. - Gizmo targeted 30 and hit exactly 30, so "not equal" is FALSE. <> is Excel's way of writing the not-equal sign.
4. >= means "greater than or equal to". Did the Doohickey reach its target? Type =C5>=B5 in E5. - Actual is 140 and Target is 100, so >= is TRUE. Use >= rather than > when hitting the target exactly should also count.
5. Operators also go inside functions, wrapped in quotes. Count how many actuals beat 50 by typing =COUNTIF(C2:C6, ">50") in E6. - When an operator is part of a criterion it goes inside quotes: ">50". The actuals are 60, 75, 30 and 140, and three of them are above 50.
6. A pair of quotes with nothing between them, "", means empty text. The Thing has no actual figure yet. Type =IF(C6="", "Missing", "Present") in E7. - "" is empty text, so C6="" asks "is this cell blank?". C6 has nothing in it, so the answer is Missing. This is the usual way to check for a blank before doing anything with it.

Operators practice - FAQ