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

20% of my money is £2.55 What is 2/5 of it?
A box contains bags of crisps. Each bag of crisps weighs 25 grams. Altogether, the bags of crisps inside the box weigh 1 kilogram. How many bags of crisps are i
What long-term effect do you think EU membership will have on nationalism in Europe? Explain.
what percentage of 1457 is 898?
In what respect does an atom of magnesium differ from a magnesium ion (Mg^{2+})? (A)The ion has a more stable electronic arrangement than the atom. (B)The pos
why is red onions purple
what did henry hudson claim land for
20% of my money is £2.55 What is 2/5 of it?
A certain test is worth 155 points. How many points (rounded to the nearest point) are needed to obtain a score of 65%?
What is the solution to this system of linear equations: y-x=4 and y+2x=1 1) (-1,3) 2) (0,4) 3) (1,-1) 4) (-3,3)