Most spreadsheet problems come from static cell ranges—Excel tables replace them with dynamic, self-managing data structures.

Averages calculated from a table provide a representative value that are used to summarise a dataset. When calculating averages from a frequency table, the method for finding each measure is different ...