New Perspectives on Microsoft Excel 2010 1st Edition by June Jamrich Parsons ,Dan Oja,Roy Ageloff ,Patrick Carey

Exercise 14

A list of college students includes a code to indicate the student's gender (male or female) and a field to identify the student's major. Would you use a filter or a PivotTable to (a) create a list of all females majoring in history, and (b) count the number of males and females in each major