alyssamcarrig1605 alyssamcarrig1605
  • 01-06-2021
  • Business
contestada

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.

Respuesta :

MrRoyal
MrRoyal MrRoyal
  • 01-06-2021

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

Ver imagen MrRoyal
Answer Link

Otras preguntas

I WILL GIVE YOU 85 POINTS
500ml of milk for 60p 4 litres for £3.20 Which bottle is better value for money?
How to recover yahoo password without phone number and alternate email?.
Identify and describe three types of competition and give an example of each
Sam buys a DVD player for $55. 95 and it is on sale for 40% off regular price. How much money will same save
The first confirmed detections of extrasolar planets occurred in ____________.
What are the assumptions on which the cosmological principle is based?.
What does William Seward, Andrew Johnson, and Abraham Lincoln have in common on the night of April 14, 1865?
Micturition in physiology
how mitochondra help a cell get the materials it needs?