Learning Task 7: Find the function and create a formula that will calculate the total number of fruits in the workbook below. Write the formula on cell B7.

=SUM(B2:B6)

Explanation:

Given

See attachment for workbook

Required

The function that calculates the total number of fruits

The number of fruit for each fruit is represented by cell B2 through B6.

So, we need to create a function that adds up the values in B2 to B6. To do this, we make use of the SUM function.

So, enter the following formula in cell B7

=SUM(B2:B6)

The above formula will add B2 to B6