Chapter 6. Function Fundamentals
In this chapter
The Basic Parts of a Formula
A function in Excel is a built-in formula that performs a mathematical operation or returns information specified by the formula. For example, if you had a list of a thousand numbers and wanted to manually look for the highest value, it could take a while. That’s where Excel can help. It has a
MAX function that searches a specified range and returns the highest value. Using another example, if you wanted to calculate the average ...