FLOOR & CEILING Functions - Free Excel Practice Online

This free, interactive exercise teaches you FLOOR & CEILING 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 FLOOR & CEILING 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 FLOOR & CEILING Functions lesson

1. The FLOOR function in Excel rounds a number (the first argument) down to the nearest multiple of the second argument.To round the price DOWN to the nearest 1 dollar, type =FLOOR(B1, 1)
2. To round down to the nearest multiple of 2, change the second argument to 2.What would =FLOOR(B1, 2) return?
3. To round upwards, use the CEILING function.Type a CEILING formula using the price below to return 17.
4. Type a CEILING formula using the price below to return 18.
5. What would =FLOOR(B1, 5) return?
6. What would =FLOOR(B1, -4) return? Hint: When both arguments of the FLOOR function are negative, the function rounds the first number toward zero.
7. What would =CEILING(B1, -4) return?
8. Write a ceiling formula using weight below that would return 18.
9. Write a ceiling formula using weight below that would return 19.
10. What would =CEILING(B1, 44) return?

FLOOR & CEILING Functions practice - FAQ