ODD and EVEN Functions - Free Excel Practice Online

This free, interactive exercise teaches you ODD and EVEN Functions 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 Statistical Functions track and works right in your browser - no Excel install, no download, and no signup.

Practising ODD and EVEN Functions 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 ODD and EVEN Functions lesson

1. The EVEN function takes a number and rounds it up to the nearest even integer. Try typing =EVEN(A2) to get 6.
2. The ODD function takes a number and rounds it up to the nearest odd integer. Try typing =ODD(A4) to get 7.
3. What would =EVEN(A5) return?
4. What would =ODD(A7) return?
5. What would =EVEN(A4) return?
6. What would =ODD(A5) return?
7. Write an EVEN function, using the numbers below, that returns 24.
8. Write an ODD function, using the numbers below, that returns 29.
9. Write an EVEN function, using the numbers below, that returns 6.
10. Write an ODD function, using the numbers below, that returns 1.

ODD and EVEN Functions practice - FAQ