2 Suggest the Excel functions that can be used for carrying out following operations : (i) To calculate total marks of a student if his marks in five subjects are given in five different cells. (ii) To calculate average sales made by salesman of a company, if sales made by each of the salesman is available. (iii) To find out the marks of top scorer in a class, if marks of all the students are available. (iv) To find out minimum quoted rate from various quotations available. 3 Explain what are the different methods of cell referencing in MS-Excel ?
Answers
Answered by
1
Answer:
2.
(i) =SUM(cell 1: cell 2)
(ii) =AVERAGE(cell1 : cell2)
(iii) =MAX(cell 1 : cell 2)
(iv) =MIN(cell 1 : cell2)
Make sure you enter the name of the cell, Here, I am giving an example of sum function:
=SUM(A1: C1)
3. There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.
Similar questions