Answered

Get the answers you need at Westonci.ca, where our expert community is dedicated to providing you with accurate information. Find reliable answers to your questions from a wide community of knowledgeable experts on our user-friendly Q&A platform. Get detailed and accurate answers to your questions from a dedicated community of experts on our Q&A 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
Your visit means a lot to us. Don't hesitate to return for more reliable answers to any questions you may have. We appreciate your time. Please come back anytime for the latest information and answers to your questions. We're dedicated to helping you find the answers you need at Westonci.ca. Don't hesitate to return for more.