Analyise the given data set using pivot and excel functions

Hi,

I am providing the link which has sample data

https://www.dropbox.com/sh/tovdou4mt5hgrfe/KD878psFt2

The total score the candidate can score is 30
cutoff scr is 25

1. I wanted to create three buckets

bucket 22, bucket >=24 and bucket 25

2. How do I create "Biggest contributor" performed by the candidate in all the parameters?

3. Which parameter a candidate has just missed with the cutoff score.?

4. Can you also help me with the charts and graphs to show the improvement areas in all the parameters?

Please advise

Thakur

AttachmentSize
SAMPLE DATA1.xls191.5 KB