Answer:
Option(c) i.e "=B1+B2+B3+B4+B5" is the correct answer for the given question.
Explanation:
The sum function in Microsoft Excel is used to calculate the sum of the cell This function is used to adding the two or more rows. The sum is the aggregate function which gives it gives a single value for the entire column in the microsoft excel.
We can use the sum function in Microsoft excel in the following methods
SUM(B1: B5): it sums the cell from cell B1 to B5 it may also be written as =B1++B2+B3+B4+B5.