The CONFIDENCE.T function is used when the population standard deviation is not known and needs to be estimated from the sample. In contrast, the CONFIDENCE.NORM function is used when the population standard deviation is known. Hence, CONFIDENCE.T is more commonly used in practice.