arrow
arrow
arrow
Which MS Excel function can be used to sum up the numbers entered in a group of cells?
Question

Which MS Excel function can be used to sum up the numbers entered in a group of cells?

A.

COUNT

B.

AVERAGE

C.

MAX

D.

SUM

Correct option is D

The correct answer is (d) SUM.
SUM () is used to add all the numbers in a range in MS-Excel.
The SUM function is written as = SUM (range), where range is the group of cells you want to sum up. This function can handle both individual cell references and ranges, making it versatile for various summing tasks.
· To use the SUM function, you can type =SUM(A1:A10) in a cell to sum the values from cell A1 to A10
Information Booster:
AVERAGE: Calculates the average of a group of numbers.
MAX: Finds the maximum value in a range of cells.
COUNT: Counts the number of cells that contain numbers.

Free Tests

Free
Must Attempt

SSC GD PYP (Held on 4 Feb 2025 S1)

languageIcon English
  • pdpQsnIcon80 Questions
  • pdpsheetsIcon160 Marks
  • timerIcon60 Mins
languageIcon English
Free
Must Attempt

Hindi Section Test 1

languageIcon English
  • pdpQsnIcon20 Questions
  • pdpsheetsIcon40 Marks
  • timerIcon12 Mins
languageIcon English
Free
Must Attempt

SSC GD Constable Full Mock Test 1

languageIcon English
  • pdpQsnIcon80 Questions
  • pdpsheetsIcon160 Marks
  • timerIcon60 Mins
languageIcon English
test-prime-package

Access ‘SSC CHSL Tier I’ Mock Tests with

  • 60000+ Mocks and Previous Year Papers
  • Unlimited Re-Attempts
  • Personalised Report Card
  • 500% Refund on Final Selection
  • Largest Community
students-icon
354k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow