Question

Suggest the Excel functions that can be used for carrying out following operations:1) To calculate total marks of a student of his marks in five subjects are given in five different cells.​

Answer 1

Answer:

Addition. If those marks were given in cells A1, A2, A3, A4, A5 and you have to display the marks in B6 then the formula will be like this B6=A1+A2+A3+A4+A5

Explanation:

Answer 2

"Sum(Cell_first:Cell_last)" is the correct answer for the above question

Explanation:

• The sum function is used in the MS-Excel to add the value of cells. When a user wants to add the value from Cell A1, A2and A3 then it can be written as "Sum(A1: A3)" in MS-Excel formula.
• So when a user wants to add the five marks which are written in 5 cells then he can use the Sum function which holds the first cell value and the last cell value separated by a colon.

Learn More:

• Function in MS-Excel : https://brainly.in/question/1918206