Question

2) Enter the records of students in sheet1, as shown below: 5
i) In sheet2, copy the column Name from Sheetl.
ii) Add a column Total Marks in sheet2 and write the formula the total marks by creating
the reference to the marks of subjects stored in sheetl.
SHEET 1
А
B
С
D
E
ID
NAME ENGLISH HINDI MATH
2
101 Rohan
90
65
78
3
102 Mohan 70
76
56
4
103 Anuj
80
46
98
5
104 Maya
68
98
76
6
105 Reena
65
54
75
SHEET 2
A
B
TOTAL MARKS
1
2
3
4
5
6
NAME
Rohan
Mohan
Anuj
Maya
Reena
5​

Answer 1

Answer:

Lol .....

Explanation:

don't know please mention photo