Multiple choice technology

Formula for adding value from cell c1 to c5?

  1. sum(c1.c5)

  2. sum(c1;c5)

  3. sum(c1:c5)

  4. sum(c1,c5)
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In spreadsheet formulas, a range of cells is specified using a colon (c1:c5). The SUM function then adds all values in that range. Dots, semicolons, or commas are not used for range specification.

AI explanation

To add the values from cell C1 to C5, you can use the SUM function in Excel. The correct formula to achieve this is:

C. sum(c1:c5)

In this formula, the colon (:) is used to represent a range of cells. By specifying "C1:C5", you are telling Excel to sum the values in cells C1, C2, C3, C4, and C5.

Keep practicing — related questions