Excel Exercise: The One-Input Data Table

Pivot Tables. Pivot Tables can be used to analyze tables of data. Note that all examples in this section use the file Gr7 MAT7 Gr10 MCAS 2003 Que.xls supplied with the MCAS project. Using a Pivot Table to Tally Columns: Column I lists the performance level for the MCAS math scores (i.e. F, NI, P, A). ................
................