Excel - Operaciones

Quiz
•
Instructional Technology
•
University
•
Medium

JULIUS BEL
Used 30+ times
FREE Resource
41 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Operadores relacionales en Excel:
&, %, #, =, +
+, -, >, =, *
>, <, >=, <=, <>, =
+, /, -, *
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Cual es el numero de filas y columnas en Excel?
Filas = 1348276 - Columnas = 15384
Filas = 1487659 - Columnas = 14585
Filas = 1048576 - Columnas = 16384
Filas = 1048576 - Columnas = 16385
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
La unión entre una fila y una columna crea una:
Hoja de calculo
formula
Ninguna de las anteriores
celda
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Al comenzar una formula en excel, necesitas
agregar el signo +
Ingresar los valores o celdas a calcular
agregar el signo =
presionar la tecla enter
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Cúal es la formula para hallar el promedio de las 03 mejores notas?
=SUMA(B2:E2)/2 - MIN(B2:E2)
=PROMEDIO(B2:E2)
=(SUMA(B2:E2)-MIN(B2:E2))/3
=(MIN(B2:E2)-MAX(B2:E2))/3
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Si aplicamos el formato #,#00.00 al valor 9.9786 este se mostrara como:
10.99
09.95
09.98
19.95
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fórmula para contar cantidad de productos de color azul en la celda D1:
=CONTAR(B2:B11;"Azul")
=CONTARA(B2:B11;"Azul")
=SUMAR.SI(B2:B11;"Azul")
=CONTAR.SI(B2:B11;"Azul")
Create a free account and access millions of resources
Similar Resources on Wayground
40 questions
ELECTRÓNICA ANALÓGICA

Quiz
•
University
40 questions
DISEÑO DE LA EDUCACIÓN NO ESCOLARIZADA II

Quiz
•
University
45 questions
La carga

Quiz
•
University
37 questions
Aprenem amb l'hort!

Quiz
•
6th Grade - University
40 questions
Quiz despre Cloud Computing

Quiz
•
University
40 questions
04MTIC_UAI_ E-LEARNING E INNOVACIÓN TECNOLÓGICA

Quiz
•
University
38 questions
Primer_Par_CD2_2G

Quiz
•
University
40 questions
MÁQUINAS TÉRMICAS

Quiz
•
University
Popular Resources on Wayground
50 questions
Trivia 7/25

Quiz
•
12th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
11 questions
Negative Exponents

Quiz
•
7th - 8th Grade
12 questions
Exponent Expressions

Quiz
•
6th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade
20 questions
One Step Equations All Operations

Quiz
•
6th - 7th Grade
18 questions
"A Quilt of a Country"

Quiz
•
9th Grade