Do you know the difference between an array and a range? How about differentiating between a function and a formula? Excel has hundreds of key terms, and some are more intuitive than others.

Manually finding and replacing parts of text can be exceedingly tedious for lengthy Excel spreadsheets. Luckily, Microsoft included a couple of useful tools for locating text parts and replacing them ...