Statistical Functionslesson 36 of 95
FLOOR, CEILING, SUBSTITUTE and FIND Practice
Loading the data...
FLOOR, CEILING, SUBSTITUTE and FIND - Excel Practice Online
This 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 and no download. Start free.
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 Excel practice course.
What you'll practice in this FLOOR, CEILING, SUBSTITUTE and FIND lesson
- What would =FLOOR(B2, 2) return?
- What would =SUBSTITUTE(A3, "es", "ive") return?
- What would =CEILING(B3, 5) return?
- What would =FIND("n", A4) return?
- Write a CEILING function, using January's revenue, that returns 17.
- Write a FLOOR function, using February's expenses, that returns 10.
- 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".
- What would =FIND("E", A3) return?
- Write a FLOOR function that rounds March revenue down to the nearest multiple of 2.
- Write a CEILING function that rounds March expenses up to the nearest integer.
FLOOR, CEILING, SUBSTITUTE and FIND practice - FAQ
How do I practice FLOOR, CEILING, SUBSTITUTE and FIND 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 FLOOR, CEILING, SUBSTITUTE and FIND 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 FLOOR, CEILING, SUBSTITUTE and FIND lesson?
This lesson covers FLOOR, CEILING, SUBSTITUTE and FIND as part of the Statistical Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.