FLOOR, CEILING, SUBSTITUTE and FIND - Free Excel Practice Online

This free, interactive exercise teaches you FLOOR, CEILING, SUBSTITUTE and FIND 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 FLOOR, CEILING, SUBSTITUTE and FIND 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 FLOOR, CEILING, SUBSTITUTE and FIND lesson

1. What would =FLOOR(B2, 2) return?
2. What would =SUBSTITUTE(A3, "es", "ive") return?
3. What would =CEILING(B3, 5) return?
4. What would =FIND("n", A4) return?
5. Write a CEILING function, using January's revenue, that returns 17.
6. Write a FLOOR function, using February's expenses, that returns 10.
7. What would =SUBSTITUTE(A3, "e", "ive item", 2) return? - SUBSTITUTE matches capitals exactly, so the capital E at the start does not count. The first "e" is in "Expenses" and the second is just before the last letter, "Expenses". Only that second one becomes "ive item", and the final "s" stays where it was. That leftover "s" is why the answer is "Expensive items".
8. What would =FIND("E", A3) return?
9. Write a FLOOR function that rounds March revenue down to the nearest multiple of 2.
10. Write a CEILING function that rounds March expenses up to the nearest integer.

FLOOR, CEILING, SUBSTITUTE and FIND practice - FAQ