Answered

Get the answers you need at Westonci.ca, where our expert community is always ready to help with accurate information. Join our platform to connect with experts ready to provide precise answers to your questions in various areas. Experience the convenience of finding accurate answers to your questions from knowledgeable experts on our platform.

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 :

MrRoyal

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 hope our answers were helpful. Return anytime for more information and answers to any other questions you may have. We hope this was helpful. Please come back whenever you need more information or answers to your queries. Westonci.ca is committed to providing accurate answers. Come back soon for more trustworthy information.