Working with spreadsheets/Spreadsheet calculations/Functions

A function is a pre-defined formula that’s already in Excel. If you have a choice, use a function over a formula.

Other functions
Here is a brief explanation of the other functions that you can access from the Autosum (Σ) button:


 * =sum(A1:A6)
 * Adds up or sums the numbers in the range provided


 * =average(A1:A6)
 * Works out the average of the cell values in the range


 * =Max(A1:A6)
 * Returns the maximum value stored in the range


 * =Min(A1:A6)
 * Returns the minimum value stored in the range

Counts the number of cells that contains numbers only in the range
 * =Count(A1:A6)


 * = Counta(A1:A6)
 * Counts the number of cells that are not empty (different to the one above)

Summary
So far in this unit, you have learned how to:


 * Add new data to your spreadsheet
 * Apply formats like currency, colour, italics
 * Create formulae to perform basic maths
 * Use Excel functions
 * Copy and pasted formulae and functions
 * Provided a solution to a simple problem