1] The percentages scored by a student in various subjects are in columns A and B, the grades need to be mentioned in column C, and the grade values in column D as shown in the picture below.