b. Gopal has made a table in Microsoft Word which contains name of the students and marks in five subjects. Help him to calculate total marks scored by each students. Write the steps to do so.
Answers
Answered by
0
If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
Answered by
0
Answer:
At first Gopal will click in the last cell of the row where he want to get the total. Then select 'formula' option from the 'Table menu'. The Formula dialog box is displayed. Formula to calculate the sum of marks to its left is already displayed in the Formula text box as =SUM(LEFT). Now Gopal will click OK button to get the sum in the selected cell.
Explanation:
While calculating row-wise, tha Formula shows 'LEFT' in the Formula brackets and when calculating column-wise in the last row, it shows 'ABOVE' in the Formula Brackets.
Similar questions