Question

Which function is used to add the number in a given range of cell

Answer 1

AutoSum

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.