FLOOR and CEILING Practice - Free Excel Practice Online

This free, interactive exercise teaches you FLOOR and CEILING Practice 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 and CEILING Practice 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 and CEILING Practice 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?
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 and CEILING Practice practice - FAQ