Answered

Engage with knowledgeable experts and get accurate answers on IDNLearn.com. Get prompt and accurate answers to your questions from our community of experts who are always ready to help.

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.

Sagot :

MrRoyalidn

Answer:

=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

View image MrRoyal
We appreciate your contributions to this forum. Don't forget to check back for the latest answers. Keep asking, answering, and sharing useful information. Trust IDNLearn.com for all your queries. We appreciate your visit and hope to assist you again soon.