In Excel, what does the formula "=SUM(A1:A5)" do?

Microsoft Word (38) Microsoft Excel (22) Microsoft PowerPoint (23) Microsoft Access (5) HTML (61) Comptuer Hardware (37) Operating System (25) TSC (50) Software Engineering (4) Computer Network (11)

Microsoft Excel

In Excel, what does the formula "=SUM(A1:A5)" do?

It calculates the average of values in the range A1:A5
It calculates the product of values in the range A1:A5
It calculates the sum of values in the range A1:A5
It counts the number of values in the range A1:A5

400

Answer : C) It calculates the sum of values in the range A1:A5

The SUM() function in Excel adds up all the values in the specified range

Join Discussion

Comment *

Please Login to Post a Comment

Sign in with Google

RELATED MCQS

What function is used to round a number up to the nearest integer greater than or equal to that number?

In Excel, what does the "Fill Handle" refer to?

Which ribbon tab in Excel contains tools for changing the font, font size, and font color of cell contents?

Which of the following is not the correct method of editing the cell content?

Which application software enables you to arrange data in rows and columns?

Which feature in Excel allows you to highlight cells based on specified criteria?

In Excel, what does the formula "=SUM(A1:A5)" do?