Questão em destaque · Q1859090
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 determin
FUNRIO · Pre Sal Petroleo S A · 2017
Resolva a questão abaixo e continue estudando com o banco de questões.
P1859090
ID: 1859090
InformáticaAssunto: EXCEL 2013 · Fórmulas e Funções · Microsoft Excel / LibreOffice Calc
Banca: FUNRIO
Ano: 2017
Nível: Superior
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:
Responda à questão para liberar o gabarito e as estatísticas.
Carregando plataforma de questões...