![]() The AVERAGE function calculates the average of numbers in a range of cells. The first case is used if the cells are not continuous whereas the second case is used when the cells are continos. ![]() Similarly calculate average as =average(C2,D2,E2) or =average(C2:E2).For calculating sum for other students, click and drag the sum value of F2 till F6.To calculate sum, type =sum( in the cell F2 and click and drag the cells C2, D2 and E2 i.e., =sum(C2:E2) where : denotes the range to add maths physics and chemistry marks of student no1.The data is entered into the spreadsheet as shown below: Problem 2: Let us consider the problem of finding the total and average of 3 subject marks for five students in a class in the board exam. To add more than two numbers, add as many columns (number1, number2, number3 etc., and extend the formula as =A2+B2+C2+….The cell number represents the numbers (For e.g A2 and B2 are used which denote 3 and 5 respectively with a plus sign in between as in the case of normal addition.In excel calculations are prefixed with = sign followed by the operation on cells In C2, type in =A2+B2 and press enter to display the result.In A2 and B2, type in the numbers to be added. ![]() This is just for us to identify the values and they are not involved in the actual execution ![]() Open a spreadsheet and type in the labels called number 1 and number 2 in cells A1 and B1 and add in cell C1.
0 Comments
Leave a Reply. |