Computer Science, asked by krishnaadhana, 8 months ago

Which inbuilt feature calculates the sum of data arranged in contiguous rows or columns?

SUM

AUTOSUM

Count

all of the above​

Answers

Answered by vijaygajula1978
2

Explanation:

Sum function!! maybe

hope it helps you!

have a great dayy!

Answered by Anonymous
1

Answer:

options 1st

  • Sum every n rows down in Excel with formulas
  • Enter this formula into a blank cell where you want to put the result: =SUM(OFFSET($B$2,(ROW()-ROW($B$2))*5,0,5,1))

  • Tip: In the above formula, B2 indicates the started row number you want to sum, and 5 stands for the incremental row numbers.

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. Here's an example.

Similar questions