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.