Formulas - Functions

Spreadsheets have lots of built-in functions for formulas.

  1. In C2, enter the formula =sum(A2:A11)
  2. In C3, enter a formula to find the average of the values (hint: the function is average

Notice that the colon ':' is used to specify a range of values. For exmaple, A2:A11 is all of the cells from A2 up to and including A11.