Logical Functionslesson 44 of 95
IS, ODD, EVEN, YEAR and TODAY Practice
Loading the data...
IS, ODD, EVEN, YEAR and TODAY - Excel Practice Online
This interactive exercise teaches you IS, ODD, EVEN, YEAR and TODAY 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 and no download. Start free.
Practising IS, ODD, EVEN, YEAR and TODAY 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 Excel practice course.
What you'll practice in this IS, ODD, EVEN, YEAR and TODAY lesson
- Use an IS function (isblank, isnumber, istext, isodd, iseven), using the cell B2 below, to return TRUE.
- Use an IS function, using the cell B2 below, to return TRUE.
- Use the ODD function, using the cells below, to return 7.
- Use a function to get the current date.
- Get the year of the current date.
- Use YEAR, TODAY, and the cells below to get the year Rover was born.
- Use YEAR, TODAY, and the cells below to get the year Bandit was born.
- What would =EVEN(D2) return?
- What would =ODD(D2) return?
- What would =ISBLANK(D2) return?
IS, ODD, EVEN, YEAR and TODAY practice - FAQ
How do I practice IS, ODD, EVEN, YEAR and TODAY in Excel?
Open this 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. You need no Excel install.
Is the IS, ODD, EVEN, YEAR and TODAY exercise free?
Your first two lessons are free with a free account. After that the pass opens all 95 lessons, the Academy and the accounting course. Lessons you finish stay open.
What will I learn in this IS, ODD, EVEN, YEAR and TODAY lesson?
This lesson covers IS, ODD, EVEN, YEAR and TODAY as part of the Logical Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.