Login / Signup

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

Which of the following file extension denotes Microsoft Power Point Presentation
In MS Excel 365, which of the following is an example of absolute reference pointing to cell A1?
In Microsoft Excel, which shortcut key is used to insert a page break?
How many types of placeholder are there in PowerPoint ?
In MS Word, which feature is best suited for automatically generating a table of contents from document headings?
In MS Excel, which function is most appropriate to count only the cells that contain numbers in a range A1:A10
The overall design, construction, organization and interconnecting of the various components of a computer system is referred as.
Which of the following is a valid data type in MS Excel?
What is the keyboard shortcut to invoke the ‘Insert Hyperlink’ window in MS-Word 2016?
Which of the following shortcut key is used for print preview?

Hey! Ask a query

ask-question