Excel Exercises Playground

The EXACT function in Excel is pretty simple. It returns TRUE when the two given arguments are exactly the same. Otherwise, it returns FALSE. We’ve ...

This one’s an opportunity to practice your IFs, ANDs and ORs. You may find yourself combining these functions when you require more complex conditions. This ...

Count the number of blank rows (not cells) in the product table A1:B20 using the COUNTBLANK function. Alternatively, you can combine the total number of ...

Excel contains an IFERROR function that will return a different value if an error is given. But it does not contain an IFNOTERROR function that ...

Taking the minimum and the maximum of a range of cells is easy. However, you may sometimes need to think about how you combine the ...

In this exercise, we’re looking at the Iferror function. This function can be handy when you expect errors to exist, but you want to handle ...

In this exercise, we’re going to use the TODAY function, the YEAR function and the CONCATENATE function to create an up-to-date copyright message. The message ...

In this exercise, you need to combine the first and last name given and add a space (” “) in-between. You can use the Concatenate ...

You can use the Substitute function for all kinds of textual replacing. Try changing the X in cell A2 below into a 1 by using ...

Use the Average function to calculate the average of the numbers in the worksheet below. Fill in your answer in cell A7. That’s it! Your ...

Try writing your first formula! To let Excel know that a formula is coming, you need to write an equals sign (=). =formula here A ...

Use the SUM function or simply the plus + operator to calculate the total after expenses for this month. Well done! You’ve correctly summed the ...