Question Bank - ICT

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?

A.
ADD()
B.
ADDN()
C.
SUM()
D.
SUMN()

Solution:

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.

For more questions,

Click Here

Download Gyanm App

free current affairs for competitive exams

Scan QR code to download our App for
more exam-oriented questions

free current affairs for competitive exams

OR
To get link to download app

Thank you! Your submission has been received. You will get the pdf soon. Call us if you have any question: 9117343434
Oops! Something went wrong while submitting the form.