to have sum of all column value in numeric table , which row will add and why.....class 9
Answers
Answer:
Explanation:
Summing (adding values) is an integral part of data analysis, whether you are subtotaling sales in the Northwest region or doing a running total of weekly receipts. Excel provides multiple techniques that you can use to sum data.
To help you make the best choice, this article provides a comprehensive summary of methods, supporting information to help you quickly decide on which technique to use, and links to in-depth articles.
Simple addition and subtraction
You can add and subtract numbers by using a simple formula, clicking a button, or by using a worksheet function.
Add the values in a cell by using a simple formula
If you just need a quick result, you can use Excel as a mini calculator. Do this by using the plus sign (+) arithmetic operator. For example, if you type the formula =5+10 in a cell, Excel displays 15 as the result.
Subtract the values in a cell by using a simple formula
Do this by using the minus sign (-) arithmetic operator. For example, the formula =12-9 displays a result of 3.
Add the values in a column or row by using a button
You can use AutoSum to quickly sum a range of numbers in a column or row. Click an empty cell below a column of numbers or to the right of a row of numbers, and then click AutoSum. Excel selects what it determines to be the most likely range of data. Click AutoSum again to accept the range that Excel selects, or select your own range and then click AutoSum.