You will see a drop-down list of the functions ... formula (=MAX (C6:C15) into the cell and get the result. That’s it. Read: How to add or change the Theme for Workbook in Excel.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Doing so gives you individual values; using BYCOL() returns an array. The real power here is that you can substitute MAX() with just about any Excel function. For example, Figure B shows the sum ...