7 Excel functions you probably didn't know existed (and why they're surprisingly useful)

Excel has hundreds of functions, and I certainly don't know what all of them do. But every now and then, I find one that makes me wonder why I'd never come across it before. Here are seven that caught me by surprise.