📢 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

In a clock, the time is 12:00 pm. If the minute hand is pointing toward the South, where is the hour hand pointing?
It will be Saturday on November 12, 2022. What will be the day on November 12, 2028?
If 10^th of the month falls on the day preceding Sunday, on what day will 1^st of the month fall?
What will be the angle formed between the hour hand and minute hand of a clock at 6:48am?
At 9:45 in a clock, the angle between the minute and hour hands is:
What was the day of the week on ‘2nd July 2003’?
If the sixth day of a month is four day earlier than Monday what day will it be eighteenth day of month?
If 6th March 2005 was Monday, then what was the day on 6th March 2004?
If today is Tuesday, then what day of the week will it be after 153 days?
If the sixth day of a month is four days before Monday, then which day will be the eighteenth day of month?

ask-question