GRUEN INTERNATIONAL SCHOOLS, PORT HARCOURTA pivot table is a spreadsheet tool for summarising and analysing large amounts of data. It can group information and calculate totals, counts and averages without manually creating many separate calculations.
The common areas are Rows, Columns, Values and Filters. Rows organise categories vertically, Columns organise categories horizontally, Values contain calculations such as Sum or Average, and Filters restrict the records displayed.
A relative reference such as A2 changes when copied. An absolute reference such as $A$2 remains fixed. A mixed reference fixes one part, such as $A2 or A$2. Correct references are essential when copying formulas across a worksheet.
SUM adds values, AVERAGE finds the mean, MIN and MAX find the smallest and largest values, and COUNT counts numerical entries. IF makes a decision based on a condition. SUMIF/SUMIFS add values that meet conditions, while COUNTIF/COUNTIFS count records that meet conditions. Lookup functions can retrieve related information from a table.
An IF formula can classify a result, for example =IF(B2>=50,"Pass","Fail"). AND requires all specified conditions to be true, while OR requires at least one condition to be true. Such formulas are useful for grading, eligibility and classification.
After calculations are performed, users should examine the values and identify patterns, totals, averages and differences. Spreadsheet results can support decisions in school records, business, accounting, stock control and survey analysis.