Question

1- Enter the marks of five students in five different subjects (Maths, Science, Hindi, English, S.St) using excel.

a. Find Total marks of every student.

b. Find Average marks in Maths, Science and English. c. If the marks are between 61 and 81 the cell should become light green fill with dark green text.

d. Prepare a column chart with the given data

e. Add chart title and Axis title to it.

how to do in notebook pls tell ​

Answer 1

Answer:

a. maths. science. Hindi. English. s.st.

99. 89. 90. 100. 97.

b. average by using the formula