Google Sheets:

Working with Functions

1. Open our example file. Make sure you're signed in to Google, then click File > Make a copy.
2. Select the Challenge sheet.
3. Fix the formula in cell C10 so it finds the average number of units sold by all of the troops.
4. In cell C11, write a function that will find the total amount of units sold by all of the troops.
5. In cell C12, write a function that will find the largest number of units sold by a troop.
6. When you're finished, your spreadsheet should look something like this:

Link to the complete lesson