開始使用免費開始

Book 'em and count 'em

Now that you have a list of all precincts, you can determine which one had the highest number of crimes committed. You can use one of the "IF" functions you learned about (e.g., COUNTIF(), SUMIF(), AVERAGEIF()) to determine which precinct needs the most support.

Remember that these functions take a range of cells to evaluate, the criterion to evaluate, and the range of cells to which to apply the function.

本練習屬於課程

Google 試算表中的誤差與不確定性

檢視課程

練習說明

  • In cell G2, count the number of offenses for the West precinct.
  • Do the same for the South, Unknown, Southwest, North, and East precincts in cells G3:G7, respectively.

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習