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.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.