Using Excel’s EXACT() function
This function is useful in terms of understanding data verification using double data entry (covered in the Cambridge International IT…
productivity through technology
This function is useful in terms of understanding data verification using double data entry (covered in the Cambridge International IT…
I am not sure I have ever seen an instance where these 2 functions are NOT used together! In this…
This function takes two or more arguments, and one of the arguments must return TRUE for the function to return…
The WEEKDAY() function returns a number for the day of the week corresponding to the date provided. The day is…
The RIGHT() function returns a specified number of characters from a string, starting from the right-hand side (essentially the opposite…
The LEFT() function returns a specified number of characters from a string, starting from the left-hand side. In this tutorial:…
Excel’s UPPER() function converts all text in a string to uppercase characters. Syntax =UPPER(text) Returns the text with all characters…
Excel’s LOWER() function converts all text in a string to lowercase characters. Syntax =LOWER(text) Returns the text with all characters…
This caught me out the other day: I was looking to do something that I at first pegged as a…
Excel’s PI function is one of four functions that do not require arguments. This is an awesome cross-curricular, experiential exercise,…