📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

Question

Which of the following formulas correctly calculates

the sum of values in cells A1 to A5 in Excel?

A =SUM(A1+A2+A3+A4+A5)

B =ADD(A1:A5)

C =SUM(A1:A5)

D =TOTAL(A1,A2,A3,A4,A5)

E =SUM(A1-A5)

Practice Next

More MS Office Questions

If ‘A’ means (÷), ‘B’ means (×), ‘C’ means (+), and ‘D’ means (-), then ____ is the value of the expression.

25 A 5 B 8 D 6 C 4...
If in a certain code language ‘+’ represents ‘×’, ‘–’ represents ‘+’, ‘×’ represents ‘÷’ and ‘÷’ represents ‘–’....
If 'A' stands for '-', 'B' stands for '×', 'C' stands for '+', and 'D' stands for '÷', then what is the value of the following expression.

45 D...
If ‘A’ denotes ‘÷’, ‘B’ denotes ‘x’, ‘C’ denotes ‘+’ and ‘D’ denotes ‘-’.Then find the value of 12 B 9 A 3 C 28 A 2 = ?...
If ‘$’ means ‘÷’, ‘#’ means ‘-’, ‘!’ means ‘×’ and ‘^’ means ‘+’, then the value of 84 ! 5 # 6 ^ 21 $ 7 is
...
In an imaginary mathematical system, symbol ‘@’ stands for addition, ‘$’ stands for division, ‘&’ stands for subtraction, and ‘#’ stands...
If 'P' means 'division', 'Q' means 'subtraction', 'R' means 'addition', and 'S' means 'multiplication', then what is the value of the expression:
...
If ‘$’ means ‘+’, ‘#’ means ‘-’, ‘*’ means ‘×’ and ‘@’ means ‘÷’, then what is the value of the given expression?

ask-question