1. The data in the Student Test Data worksheet has a couple of problems to fix:

The data should be organized alphabetically by student.

Format the data so the school faculty can use slicers to filter data. Use any style you want.

Display slicers so data can be filtered by month, by subject, or by student or by any combination of the three. Go ahead and display the slicers, but you don't need to apply any filtering.

Find and delete the duplicate records. There should be 90 unique records.

The data should include a Total row to calculate the average score.

February	Art	James	87
February	Art	James	63
February	Art	James	89
February	Art	James	81
February	Art	James	90
February	Literature	James	72
February	Literature	James	55
February	Literature	James	57
February	Literature	James	49
February	Literature	James	89
February	French	James	61
February	French	James	97
February	French	James	63
February	French	James	55
February	French	James	79
February	History	James	88
February	History	James	65
February	History	James	90
February	History	James	82
February	History	James	91
February	Math	James	76
February	Math	John	58
February	Math	John	78
February	Math	John	70
February	Math	John	79
February	Chemistry	John	93
February	Chemistry	John	60
February	Chemistry	John	81
February	Chemistry	John	90
January	Art	John	93
January	Art	John	65
January	Art	John	95
January	Art	John	87
January	Art	John	96
January	Engish	John	91
January	Literature	John	91
January	Literature	John	93
January	Literature	John	85
January	Literature	John	94
January	French	John	66
January	French	John	96
January	French	John	68
January	French	Lisa	60
January	French	Lisa	69
January	History	Lisa	85
January	History	Lisa	62
January	History	Lisa	87
January	History	Lisa	79
January	History	Lisa	88
January	Math	Lisa	69
January	Math	Lisa	57
January	Math	Lisa	71
January	Math	Lisa	63
January	Math	Lisa	72
January	Chemistry	Lisa	62
January	Chemistry	Lisa	39
January	Chemistry	Lisa	64
January	Chemistry	Lisa	63
January	Chemistry	Lisa	72
March	Art	Lisa	96
March	Art	Lisa	52
March	Art	Lisa	98
March	Art	Lisa	90
March	Art	Lisa	99
January	History	Mark	79
January	History	Mark	88
January	Math	Mark	69
January	Math	Mark	57
January	Math	Mark	71
January	Math	Mark	63
January	Math	Mark	72
January	Chemistry	Mark	62
January	Chemistry	Mark	39
January	Chemistry	Mark	64
January	Chemistry	Mark	63
January	Chemistry	Mark	72
March	Art	Mark	96
March	Art	Mark	52
March	Art	Mark	98
March	Art	Mark	90
March	Art	Mark	99
March	Engish	Mark	45
March	Literature	Mark	45
March	Literature	Mark	49
March	Literature	Mark	61
March	Literature	Mark	90
March	French	Mary	60
March	French	Mary	94
March	French	Mary	62
March	French	Mary	54
March	French	Mary	83
March	History	Mary	95
March	History	Mary	71
March	History	Mary	97
March	History	Mary	89
March	History	Mary	98
March	Math	Mary	75
March	Math	Mary	39
March	Math	Mary	77
March	Math	Mary	69
March	Math	Mary	78
March	Chemistry	Mary	45
March	Chemistry	Mary	47
March	Chemistry	Mary	59
March	Chemistry	Student	88