
Prueba de Excel
Quiz
•
Computers
•
Professional Development
•
Medium
WLADIMIR AVILA
Used 6+ times
FREE Resource
16 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Excel es una aplicación que pertenece a
Microfsosft Office
Iworks de Apple
Google drive
Ninguna de las Anteriores
2.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
La siguiente función =CONTAR.SI hace:
Contar el numero de elementos basados en un criterio especifico
Cuenta las celdas en blanco
Cuenta las celdas que tienen valor Numerico
Cuenta solo si hay numeros
3.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Según la grafica, para contar los empleados que pertenecen a la región sur, utilizo:
=CONTAR.SI(H3:H25;"sur")
=CONTAR(H3:H25;"sur")
=CONTAR.SI.CONJUNTO(H3:H25;"sur")
=CONTAR.CONJUNTO(H3:H25;"sur")
4.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Para generar el correo en donde este todo en minúsculas, la letra del primer nombre, el apellido y el dominio @empresa.com utilizo
=MINUSC(CONCATENAR(IZQUIERDA(B2;1);A2;"@empresa.com"))
=MINUSCULAS(CONCATENAR(IZQUIERDA(B2;1);A2;"@empresa.com"))
=CONCATENAR(IZQUIERDA(B2;1);A2;"@empresa.com")
=MINUSC(UNIR(IZQUIERDA(B2;1);A2;"@empresa.com"))
5.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
3. La formula para colocar en una misma celda el nombre y el apellido todo en minúscula es:
=MINUSC(CONCATENAR(B2;" ";A2))
=MINUSC(UNIR(B2;" ";A2))
=MINUSCULAS(CONCATENAR(B2;" ";A2))
=MINUSC(CONCATENAR(B2;A2))
6.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Para halla el subtotal de ventas se usa:
=SUMA(G2:J2)
=SUMAR(G2+J2)
=(G2:J2)
=SUMA(G2;J2)
7.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Para halla el promedio de las ventas de los trimestres pares, utilizó
=PROMEDIO(H2:H21;J2:J21)
=PROMEDIO(G2;I2)
=PROMEDIO.SI(F2:F21;"Bogota";K2:K21)
No se puede realizar
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
14 questions
DIrecciones IP
Quiz
•
Professional Development
18 questions
Introducción a los Sistemas Informáticos
Quiz
•
Professional Development
20 questions
Actic Prova inicial
Quiz
•
Professional Development
11 questions
Git - Github - GitHub Pages
Quiz
•
Professional Development
20 questions
Seguridad Informática
Quiz
•
10th Grade - Professi...
14 questions
Sistema Operativo Windows
Quiz
•
1st Grade - Professio...
20 questions
Hack Windows 10
Quiz
•
University - Professi...
12 questions
Google Sheets
Quiz
•
KG - Professional Dev...
Popular Resources on Wayground
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
20 questions
Halloween Trivia
Quiz
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
4 questions
Activity set 10/24
Lesson
•
6th - 8th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
How to Email your Teacher
Quiz
•
Professional Development
15 questions
Order of Operations
Quiz
•
5th Grade
30 questions
October: Math Fluency: Multiply and Divide
Quiz
•
7th Grade
Discover more resources for Computers
10 questions
How to Email your Teacher
Quiz
•
Professional Development
11 questions
NFL Football logos
Quiz
•
KG - Professional Dev...
16 questions
Spooky Season Quiz
Quiz
•
Professional Development
10 questions
Halloween Trivia
Quiz
•
Professional Development
20 questions
Context Clues: Multiple Meaning Words
Quiz
•
Professional Development
18 questions
Do or Does
Quiz
•
Professional Development
31 questions
Servsafe Food Manager Practice Test 2021- Part 1
Quiz
•
9th Grade - Professio...
