Question

What do the following denote in Excel?
(a) C26
(b) A:E
(c) =SUM (A3:A7)
(d) =($A$2* C4)
(e) #REF!​

Answer 1

Answer:

No D) is the correct answer..

hope it helps you army..

Answer 2

The correct answer is (c) =SUM (A3:A7).

SUM function

The SUM function is easier to use when you’re working with more than a few numbers.

For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.

Here’s a formula that uses two cell ranges: =SUM(A2:A4,C2:C3) sums the numbers in ranges A2:A4 and C2:C3.

To create the formula:

1. Type =SUM in a cell, followed by an opening parenthesis (.
2. To enter the first formula range, which is called an argument (a piece of data the formula needs to run), type A2:A4 (or select cell A2 and drag through cell A6).
3. Type a comma (,) to separate the first argument from the next.
4. Type the second argument, C2:C3 (or drag to select the cells).
5. Type a closing parenthesis ), and
6. Then press Enter.

   #SPJ2