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.

Scientific and mathematical formulas frequently use exponents and square roots, and you can create a function to compute the square, cube, or square root of a value by using the formula creator.