Question 1 of 10
The statement 1=1 is true, because 1 is equal to 1.
Would 1=2 evaluate to true or false?
| A | B | C | D | |
|---|---|---|---|---|
| 1 | OPERATOR | MEANING | ||
| 2 | = | Equal to | ||
| 3 | <> | Not equal to | ||
| 4 | < | Less than | ||
| 5 | > | Greater than | ||
| 6 | <= | Less than or equal to | ||
| 7 | >= | Greater than or equal to |
True & False - Free Excel Practice Online
This free, interactive exercise teaches you True & False in Excel through 10 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 True & False 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 True & False lesson
- In Excel, logical functions and decision-making are built with statements that evaluate to true or false. Excel has 6 logical operators to determine true or false, and they are listed in the table below. The statement 1=1 is true, because 1 is equal to 1. Would 1=2 evaluate to true or false? - We know that 1 is NOT equal to 2, so 1=2 is false.
- The statement 1<>1 evaluates to false, because <> means "not equal to," and it would be false to say "1 is not equal to 1."What would 1<>2 evaluate to? - We know that 1 is not equal to 2, so the statement 1<>2 would evaluate to true in Excel, because we are saying "1 is not equal to 2" which is true.
- The statement 4>=1 evaluates to true, because >= means "greater than or equal to," and 4 is greater than or equal to 1.What would 1 evaluate to? - The statement 1 says "1 is less than or equal to 2" which is true because 1 is less than 2.
- What would 1 evaluate to? - The statement 1 says "1 is less than or equal to 1" which is true because 1 is equal to 1.
- What would B5=C5 evaluate to? - The statement B5=C5 compares the values in B5 and C5. It says "The value in cell B5 is equal to the value in cell C5" which is true because both cells contain the number 950.
- What would B2>B3 evaluate to? - The statement B2>B3 says "the value in cell B2 is greater than the value in cell B3" which is false because the value in cell B2 (1000) is LESS THAN the value in cell B3 (1200).
- What would B2>=C6 evaluate to? - The statement B2>=C6 says "the value in cell B2 is greater than or equal to the value in C6" which is true because the value in cell B2 (1000) is equal to the value in cell C6 (1000).
- What would B2>=C4 evaluate to? - The statement B2>=C4 says "the value in cell B2 is greater than or equal to the value in C4" which is false because the value in cell B2 (1000) is LESS THAN the value in cell C4 (1050).
- What would B2<>C2 evaluate to? - The statement B2<>C2 says "the value in cell B2 is not equal to the value in cell C2" which is true because the value in cell B2 (1000) is NOT EQUAL to the value in cell C2 (875).
- What would B1<>C1 evaluate to? - The statement B1<>C1 says "the value in cell B1 is not equal to the value in cell C1" which is true, because the text "Revenues" is not equal to the text "Expenses".
True & False practice - FAQ
How do I practice True & False in Excel?
Open this free LogicExcel exercise and work through 10 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation - no Excel install and no signup needed.
Is the True & False exercise free?
Yes. Every LogicExcel exercise is 100% free with no account required. Your progress saves automatically in your browser.
What will I learn in this True & False lesson?
This lesson covers True & False as part of the Logical Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.