When it comes to making great-looking spreadsheets, Apple's Numbers app does a phenomenal job. Sure, it lacks some of the high-end features of an app like Microsoft Excel, but for the other 95% of us, it's a fantastic spreadsheet app.
One of the areas that it does really well in is making quick calculations. In this example, I have a simple spreadsheet to keep track of test scores.
In order to calculate the average score at the bottom of each test, there are a few ways we can do this:
- Perform a manual calculation then enter the static number in the appropriate cell
- Manually enter the equation to calculate the average
- Drag and drop the formula in place
I like to do things the easy way, so I will choose option 3. To do this, I will simply highlight the numbers I want to average. With the range of cells selected, you will notice a series of commonly used formulas at the bottom of the screen.
This is great reference information to have. To use one of these formulas in your spreadsheet, just drag and drop the formula into the cell where you want it, as shown below: