Write the formula to add the content of cells b2 b3 b4 and b5 and divide the sum by the content of cell c7
Answers
Answer:
In cell A6 = 371and G5=21
Display result in E5
Formula
Type =A6/G5
press Enter key
Answer in E5 =17.66
(b)
In cell B5 = 42.53 and G8=24.22
Display result in C3
Formula
Type = B5/G8
press Enter key
Answer in C3 = 17.55
(c)
In cell B5=523. cell D10 =27.31
Display result in C10
Formula
Type =B5/D10
press Enter key
Answer in C10=19.15
Thank you make me as a Brainlist answer
Thank you make me as a Brainlist answer
Answer:
You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.
Explanation:
Here’s a formula that uses two cell ranges: =SUM(A2:A4,C2:C3) sums the numbers in ranges A2:A4 and C2:C3. You’d press Enter to get the total of 39787.
To create the formula:
Type =SUM in a cell, followed by an opening parenthesis (.
To enter the first formula range, which is called an argument (a piece of data the formula needs to run), type A2:A4 (or select cell A2 and drag through cell A6).
Type a comma (,) to separate the first argument from the next.
Type the second argument, C2:C3 (or drag to select the cells).
Type a closing parenthesis ), and then press Enter.
#SPJ3