Here's the question bank on all the ICT topics.
Which of the following formula is used to add all the numbers in a range in MS-Excel?
SUM() is used to add all the numbers in a range in MS-Excel. Important PointsThe correct answer is SUM. SUM is used for the addition in MS Excel. The SUM function is located in the Home tab in the ribbon. SUM function adds all numbers in a range of cells and returns the result in MS Excel. The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example:=SUM(A2:A10) Adds the values in cells A2:10. =SUM(A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.
Scan QR code to download our App for
more exam-oriented questions
OR
To get link to download app