Microsoft isn't trying to confuse you—Excel's three ranking functions balance flexibility, compatibility, and tie handling.

While technological advancements can help you work more efficiently, new technologies can sometimes cause problems that decrease productivity. Older versions of Microsoft Excel, for example, may not ...