Write the steps for solving below problems using MS Excel.

Q1: Finding the Maximum and Minimum

You have a range of numbers in cells A1 to A10. Find the maximum value in this range and display it in cell B1. Similarly, find the minimum value and display it in cell B2.

Q2: Grade Calculation

You have student data in an Excel sheet, with their names in column A, and their scores for three exams (Exam 1, Exam 2, and Exam 3) in columns B, C, and D, respectively. Each exam is scored out of 100 points. Calculate the average score for each student and display it in column E.

1 Like

@mvaishali729

for 1st queation

We can follow this steps

1 In cell B1, enter the formula to find the maximum value we can use the MAX function the formula

would be: `=MAX(A1:A10)

2 In cell B2, enter the formula to find the minimum value. we can use the MIN function. The formula

would be: `=MIN(A1:A10)`

for 2nd queation

1 - Open your Excel sheet containing the student data with names in column A and scores for exam 1,

exam 2, and exam 3 in columns B, C, and D.

2 - In cell E1, enter the header for the average score column, such as â€śAverage Scoreâ€ť or â€śAvgâ€ť.

3 - In cell E2, enter the formula to calculate the average score for the first

student. we can use the AVERAGE function to find the average of the scores for the three exams.

The formula: `=AVERAGE(B2:D2)`

4 - Press Enter to execute the formula. This will display the average score for the first student in cell

E2.

5 - click on cell E2, then click and drag the fill handle down to fill the formula for the rest of the students

in column E. This will calculate the average score for each student based on their scores for exam

1, exam 2, and exam 3.