$6.$ On the Enrollment worksheet, insert a PivotTable using the Enrollment named range. Insert the PivotTable on a new worksheet named PivotAnalysis. Complete the following to create your PivotTable.a$.$ Add the Student$\_$ID$,$ Gender, and Class$\_$Name fields to the PivotTable.b$.$ Ensure Class$\_$name is in the Rows area.c$.$ Move Gender to the Columns area. d$.$ Move Student$\_$ID to the Values area.e$.$ In cell B$3,$ replace Column Labels with Gender. In cell B$4,$ replace F with Female. In cell C$4,$ replace M with Male. In cell A$3,$ replace Count of Student$\_$ID with Total Students. In cell A$4,$ replace Row Labels with Classes. f$.$ Resize the column widths as needed.g$.$ Apply Pivot Style Light $10$ to the PivotTable.Note, depending upon the version of Office being used, the style name may be Light Orange, Pivot Style Light $10.$