In Excel, Modes can be arrays, numbers, names, or suggestions that contain numbers. The Mode function ignores values such as text, logical values, or empty cells in an array or reference argument.

This tutorial will show you how to remove disable or turn off the Compatibility Mode in Microsoft Excel. Without Compatibility Mode, some documents may display incorrectly.