
236 ◾ Computational Thinking for the Modern Problem Solver
Recall the case study of the three friends that used a spreadsheet to ana-
lyze their social network list of friends. Once they learn about functions,
the three classmates rewrite their spreadsheet to exploit the sum and aver-
age functions. ey decide to replace the formula of D2 that previously
read =A2+B2+C2 with the more concise =SUM(A2:C2). e value pro-
duced by this formula is the sum of the cells in the range A2:C2. ey
also decide to replace the formula of E2 that previously read =D2/3 with
=AVERAGE(A2:C2) since the average function produces precisely the
value that the classmates ...