Excel has a built-in function to determine each of them except for the range, which will require that you create a simple formula to find.