Question

write the correct formula for adding the values in a1 to a10 cells in ms-excel

Answer 1

in excel, a formula is an expression that operates on values in a range of cells or a cell .for example:-a1+a2+a3 which finds the sum of the range of values from cell a1 to cell a3.

Answer 2

Excel is one of the data analysis tools that gives high functionality to user, starting from running basic arithmetic operations to carry out high end data analysis tools.

Therefore, to add some cells in excel, is surely a small task for the user. The following command gives the way to add 10 cells starting from a1 to a10:  SUM(A1:A10). With this sum can be calculated.