Question

U want to add 100 values stored in a worksheet and display the result in a cell.which spreadsheet function can help u do this?

Answer 1

Answer:

you can use the add function for the

Just select an empty cell directly below a column of data. Then on the Formula tab, click AutoSum > Sum. The spreadsheet  will automatically sense the range to be summed.