Questão em destaque · Q2859005

Considere a tabela a seguir. A B C D E 1 2 3 Produto Quantidade Valor unitário Total em R$ Total em US$ 4 5 Monitor de vídeo 4 R$ 399,00 R$ 1.596,00 $320,48 6 Mouse 15 R$ 12,40 $18

FUNPAR NC UFPR · IFPR · 2023

Resolva a questão abaixo e continue estudando com o banco de questões.

P2859005
ID: 2859005
InformáticaAssunto: Fórmulas e Funções · Microsoft Excel / LibreOffice Calc
Banca: FUNPAR NC UFPR
Ano: 2023
Nível: Médio

Considere a tabela a seguir.



A

B

C

D

E

1






2






3

Produto

Quantidade

Valor unitário

Total em R$

Total em US$

4






5

Monitor de vídeo

4

R$ 399,00

R$ 1.596,00

320,48</p></td></tr><trdata−row="7"><tddata−row="7"rowspan="1"colspan="1"data−cell−bg="rgb(242,242,242)"style="background−color:rgb(242,242,242)"><pclass="qlbt−cell−line"data−row="7"data−cell="1"data−rowspan="1"data−colspan="1"data−cell−bg="rgb(242,242,242)"style="text−align:center">6</p></td><tddata−row="7"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="7"data−cell="2"data−rowspan="1"data−colspan="1">Mouse</p></td><tddata−row="7"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="7"data−cell="3"data−rowspan="1"data−colspan="1"style="text−align:center">15</p></td><tddata−row="7"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="7"data−cell="4"data−rowspan="1"data−colspan="1"style="text−align:right">R320,48</p></td></tr><tr data-row="7"><td data-row="7" rowspan="1" colspan="1" data-cell-bg="rgb(242, 242, 242)" style="background-color: rgb(242, 242, 242)"><p class="qlbt-cell-line" data-row="7" data-cell="1" data-rowspan="1" data-colspan="1" data-cell-bg="rgb(242, 242, 242)" style="text-align: center">6</p></td><td data-row="7" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="7" data-cell="2" data-rowspan="1" data-colspan="1">Mouse</p></td><td data-row="7" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="7" data-cell="3" data-rowspan="1" data-colspan="1" style="text-align: center">15</p></td><td data-row="7" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="7" data-cell="4" data-rowspan="1" data-colspan="1" style="text-align: right">R 12,40

$186,00

37,35</p></td></tr><trdata−row="8"><tddata−row="8"rowspan="1"colspan="1"data−cell−bg="rgb(242,242,242)"style="background−color:rgb(242,242,242)"><pclass="qlbt−cell−line"data−row="8"data−cell="1"data−rowspan="1"data−colspan="1"data−cell−bg="rgb(242,242,242)"style="text−align:center">7</p></td><tddata−row="8"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="8"data−cell="2"data−rowspan="1"data−colspan="1">Teclado</p></td><tddata−row="8"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="8"data−cell="3"data−rowspan="1"data−colspan="1"style="text−align:center">9</p></td><tddata−row="8"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="8"data−cell="4"data−rowspan="1"data−colspan="1"style="text−align:right">R37,35</p></td></tr><tr data-row="8"><td data-row="8" rowspan="1" colspan="1" data-cell-bg="rgb(242, 242, 242)" style="background-color: rgb(242, 242, 242)"><p class="qlbt-cell-line" data-row="8" data-cell="1" data-rowspan="1" data-colspan="1" data-cell-bg="rgb(242, 242, 242)" style="text-align: center">7</p></td><td data-row="8" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="8" data-cell="2" data-rowspan="1" data-colspan="1">Teclado</p></td><td data-row="8" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="8" data-cell="3" data-rowspan="1" data-colspan="1" style="text-align: center">9</p></td><td data-row="8" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="8" data-cell="4" data-rowspan="1" data-colspan="1" style="text-align: right">R 25,60

R$ 230,40

46,27</p></td></tr><trdata−row="9"><tddata−row="9"rowspan="1"colspan="1"data−cell−bg="rgb(242,242,242)"style="background−color:rgb(242,242,242)"><pclass="qlbt−cell−line"data−row="9"data−cell="1"data−rowspan="1"data−colspan="1"data−cell−bg="rgb(242,242,242)"style="text−align:center">8</p></td><tddata−row="9"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="9"data−cell="2"data−rowspan="1"data−colspan="1">HardDisk</p></td><tddata−row="9"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="9"data−cell="3"data−rowspan="1"data−colspan="1"style="text−align:center">5</p></td><tddata−row="9"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="9"data−cell="4"data−rowspan="1"data−colspan="1"style="text−align:right">R46,27</p></td></tr><tr data-row="9"><td data-row="9" rowspan="1" colspan="1" data-cell-bg="rgb(242, 242, 242)" style="background-color: rgb(242, 242, 242)"><p class="qlbt-cell-line" data-row="9" data-cell="1" data-rowspan="1" data-colspan="1" data-cell-bg="rgb(242, 242, 242)" style="text-align: center">8</p></td><td data-row="9" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="9" data-cell="2" data-rowspan="1" data-colspan="1">Hard Disk</p></td><td data-row="9" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="9" data-cell="3" data-rowspan="1" data-colspan="1" style="text-align: center">5</p></td><td data-row="9" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="9" data-cell="4" data-rowspan="1" data-colspan="1" style="text-align: right">R 278,00

R$ 1.390,00

279,12</p></td></tr><trdata−row="10"><tddata−row="10"rowspan="1"colspan="1"data−cell−bg="rgb(242,242,242)"style="background−color:rgb(242,242,242)"><pclass="qlbt−cell−line"data−row="10"data−cell="1"data−rowspan="1"data−colspan="1"data−cell−bg="rgb(242,242,242)"style="text−align:center">9</p></td><tddata−row="10"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="10"data−cell="2"data−rowspan="1"data−colspan="1">GravadordeCD</p></td><tddata−row="10"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="10"data−cell="3"data−rowspan="1"data−colspan="1"style="text−align:center">18</p></td><tddata−row="10"rowspan="1"colspan="1"data−cell−bg="rgb(255,255,255)"style="background−color:rgb(255,255,255)"><pclass="qlbt−cell−line"data−row="10"data−cell="4"data−rowspan="1"data−colspan="1"data−cell−bg="rgb(255,255,255)"style="text−align:right">R279,12</p></td></tr><tr data-row="10"><td data-row="10" rowspan="1" colspan="1" data-cell-bg="rgb(242, 242, 242)" style="background-color: rgb(242, 242, 242)"><p class="qlbt-cell-line" data-row="10" data-cell="1" data-rowspan="1" data-colspan="1" data-cell-bg="rgb(242, 242, 242)" style="text-align: center">9</p></td><td data-row="10" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="10" data-cell="2" data-rowspan="1" data-colspan="1">Gravador de CD</p></td><td data-row="10" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="10" data-cell="3" data-rowspan="1" data-colspan="1" style="text-align: center">18</p></td><td data-row="10" rowspan="1" colspan="1" data-cell-bg="rgb(255, 255, 255)" style="background-color: rgb(255, 255, 255)"><p class="qlbt-cell-line" data-row="10" data-cell="4" data-rowspan="1" data-colspan="1" data-cell-bg="rgb(255, 255, 255)" style="text-align: right">R 115,00

R$ 2.070,00

415,66</p></td></tr><trdata−row="11"><tddata−row="11"rowspan="1"colspan="1"data−cell−bg="rgb(242,242,242)"style="background−color:rgb(242,242,242)"><pclass="qlbt−cell−line"data−row="11"data−cell="1"data−rowspan="1"data−colspan="1"data−cell−bg="rgb(242,242,242)"style="text−align:center">10</p></td><tddata−row="11"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="11"data−cell="2"data−rowspan="1"data−colspan="1"><br></p></td><tddata−row="11"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="11"data−cell="3"data−rowspan="1"data−colspan="1"><br></p></td><tddata−row="11"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="11"data−cell="4"data−rowspan="1"data−colspan="1"><br></p></td><tddata−row="11"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="11"data−cell="5"data−rowspan="1"data−colspan="1"><br></p></td><tddata−row="11"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="11"data−cell="6"data−rowspan="1"data−colspan="1"><br></p></td></tr><trdata−row="12"><tddata−row="12"rowspan="1"colspan="1"data−cell−bg="rgb(242,242,242)"style="background−color:rgb(242,242,242)"><pclass="qlbt−cell−line"data−row="12"data−cell="1"data−rowspan="1"data−colspan="1"data−cell−bg="rgb(242,242,242)"style="text−align:center">11</p></td><tddata−row="12"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="12"data−cell="2"data−rowspan="1"data−colspan="1"><strong>TotalemEstoque</strong></p></td><tddata−row="12"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="12"data−cell="3"data−rowspan="1"data−colspan="1"><br></p></td><tddata−row="12"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="12"data−cell="4"data−rowspan="1"data−colspan="1"><br></p></td><tddata−row="12"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="12"data−cell="5"data−rowspan="1"data−colspan="1"style="text−align:right">R415,66</p></td></tr><tr data-row="11"><td data-row="11" rowspan="1" colspan="1" data-cell-bg="rgb(242, 242, 242)" style="background-color: rgb(242, 242, 242)"><p class="qlbt-cell-line" data-row="11" data-cell="1" data-rowspan="1" data-colspan="1" data-cell-bg="rgb(242, 242, 242)" style="text-align: center">10</p></td><td data-row="11" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="11" data-cell="2" data-rowspan="1" data-colspan="1"><br></p></td><td data-row="11" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="11" data-cell="3" data-rowspan="1" data-colspan="1"><br></p></td><td data-row="11" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="11" data-cell="4" data-rowspan="1" data-colspan="1"><br></p></td><td data-row="11" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="11" data-cell="5" data-rowspan="1" data-colspan="1"><br></p></td><td data-row="11" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="11" data-cell="6" data-rowspan="1" data-colspan="1"><br></p></td></tr><tr data-row="12"><td data-row="12" rowspan="1" colspan="1" data-cell-bg="rgb(242, 242, 242)" style="background-color: rgb(242, 242, 242)"><p class="qlbt-cell-line" data-row="12" data-cell="1" data-rowspan="1" data-colspan="1" data-cell-bg="rgb(242, 242, 242)" style="text-align: center">11</p></td><td data-row="12" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="12" data-cell="2" data-rowspan="1" data-colspan="1"><strong>Total em Estoque</strong></p></td><td data-row="12" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="12" data-cell="3" data-rowspan="1" data-colspan="1"><br></p></td><td data-row="12" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="12" data-cell="4" data-rowspan="1" data-colspan="1"><br></p></td><td data-row="12" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="12" data-cell="5" data-rowspan="1" data-colspan="1" style="text-align: right">R 5.472,40

1.098,88</p></td></tr><trdata−row="13"><tddata−row="13"rowspan="1"colspan="1"data−cell−bg="rgb(242,242,242)"style="background−color:rgb(242,242,242)"><pclass="qlbt−cell−line"data−row="13"data−cell="1"data−rowspan="1"data−colspan="1"data−cell−bg="rgb(242,242,242)"style="text−align:center">12</p></td><tddata−row="13"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="13"data−cell="2"data−rowspan="1"data−colspan="1"><br></p></td><tddata−row="13"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="13"data−cell="3"data−rowspan="1"data−colspan="1"><br></p></td><tddata−row="13"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="13"data−cell="4"data−rowspan="1"data−colspan="1"><br></p></td><tddata−row="13"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="13"data−cell="5"data−rowspan="1"data−colspan="1"><br></p></td><tddata−row="13"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="13"data−cell="6"data−rowspan="1"data−colspan="1"><br></p></td></tr><trdata−row="14"><tddata−row="14"rowspan="1"colspan="1"data−cell−bg="rgb(242,242,242)"style="background−color:rgb(242,242,242)"><pclass="qlbt−cell−line"data−row="14"data−cell="1"data−rowspan="1"data−colspan="1"data−cell−bg="rgb(242,242,242)"style="text−align:center">13</p></td><tddata−row="14"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="14"data−cell="2"data−rowspan="1"data−colspan="1">Cotac\ca~odoDoˊlar</p></td><tddata−row="14"rowspan="1"colspan="1"><pclass="qlbt−cell−line"data−row="14"data−cell="3"data−rowspan="1"data−colspan="1"style="text−align:center">R1.098,88</p></td></tr><tr data-row="13"><td data-row="13" rowspan="1" colspan="1" data-cell-bg="rgb(242, 242, 242)" style="background-color: rgb(242, 242, 242)"><p class="qlbt-cell-line" data-row="13" data-cell="1" data-rowspan="1" data-colspan="1" data-cell-bg="rgb(242, 242, 242)" style="text-align: center">12</p></td><td data-row="13" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="13" data-cell="2" data-rowspan="1" data-colspan="1"><br></p></td><td data-row="13" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="13" data-cell="3" data-rowspan="1" data-colspan="1"><br></p></td><td data-row="13" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="13" data-cell="4" data-rowspan="1" data-colspan="1"><br></p></td><td data-row="13" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="13" data-cell="5" data-rowspan="1" data-colspan="1"><br></p></td><td data-row="13" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="13" data-cell="6" data-rowspan="1" data-colspan="1"><br></p></td></tr><tr data-row="14"><td data-row="14" rowspan="1" colspan="1" data-cell-bg="rgb(242, 242, 242)" style="background-color: rgb(242, 242, 242)"><p class="qlbt-cell-line" data-row="14" data-cell="1" data-rowspan="1" data-colspan="1" data-cell-bg="rgb(242, 242, 242)" style="text-align: center">13</p></td><td data-row="14" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="14" data-cell="2" data-rowspan="1" data-colspan="1">Cotação do Dólar</p></td><td data-row="14" rowspan="1" colspan="1"><p class="qlbt-cell-line" data-row="14" data-cell="3" data-rowspan="1" data-colspan="1" style="text-align: center">R 4,98




14







No LibreOffice Calc (v.7.1.5.2 - português), são fórmulas possíveis para as células D5 e E5, respectivamente:

Flashcards Master

Responda à questão para liberar o gabarito e as estatísticas.

Carregando plataforma de questões...