Microsoft Excel is built on the power of and functions , which allow users to perform everything from simple math to complex data analysis. While often used interchangeably, they represent two different ways to manipulate data:
are predefined, "built-in" formulas already available in Excel, such as =SUM(A1:A10) . Core Principles Microsoft Excel Functions and Formulas
Every formula and function must begin with an equal sign. This tells Excel that the cell contains a calculation rather than just plain text. Microsoft Excel is built on the power of
Basic formulas use standard mathematical operators: + (addition), - (subtraction), * (multiplication), and / (division). "built-in" formulas already available in Excel