Imagem de fundo

Observe a planilha abaixo, no Excel 2013 BR...

Observe a planilha abaixo, no Excel 2013 BR.


A

B

C

D

E

1






2


1,0

8,0

15,0


3


2,0

9,0

16,0


4


3,0

10,0

17,0


5


4,0

11,0

18,0


6


5,0

12,0

19,0


7


6,0

13,0

20,0


8


7,0

14,0

21,0


9







Em determinado momento, é inserida a expressão =SOMA(B2:D8 B5;D5) na célula E9. Em consequência, a célula E9 deverá mostrar o seguinte resultado:


A

53.


B

28.


C

11.


D

22.


E

17.