
Función Buscar, BuscarV, BuscarH
Quiz
•
Computers
•
University
•
Medium
Luis Aragon
Used 7+ times
FREE Resource
Enhance your content in a minute
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Si mi información en una hoja de Excel se presenta en columnas es recomendable usar la función:
SI
BUSCARV
BUSCARH
CONTAR
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Cuando la información se presenta en forma horizontal en una hoja de Excel utilizo la función
COINCIDIR
BUSCARV
SI
BUSCARH
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
¿Cuál de estos es función de Buscar V correcta?
=Buscarv(valor_buscado,Matriz_busqueda,Indicador_columna,Tipo_busqueda)
=Buscarv(Matriz_busqueda, valor_buscado,,tipo_busqueda,Indicador)
=Buscarv(Matriz_busqueda, valor_buscado,Indicador_columna)
=buscarv(valor_buscado;matriz_buscar_en;indicador_columa;[ordenado])
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
¿Que hace la función BUSCARV?
Busca los valores mas altos en una matriz.
Busca los valores en una matriz de acuerdo a un criterio.
Busca los valores que se repiten en una matriz.
Suma los valores de una matriz.
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Selecciona la estructura correcta de la función BuscarH
BUSCARH(F47;B38:M43;3;FALSO)
BUSCARH(F47;B38 # M43;3;FALSO)
BUSCARH(F47;B38&M43;3;VERDAD
Ninguna de las anteriores
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Las funciones Buscar V y H hacen parte del grupo de formulas
Lógica y analítica
Busqueda y referencia
Matematicas
Ninguna de las anteriores
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
La función buscarH busca por
Celdas
Columnas
Filas
Hojas
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
16 questions
Cuestionario Importancia Diseño Editorial
Quiz
•
University
15 questions
Sinh hoạt lớp Tuần 7
Quiz
•
1st Grade - University
12 questions
EXAMEN DE WORD
Quiz
•
University
11 questions
Latex
Quiz
•
University
10 questions
AppSheet conceptos básicos
Quiz
•
University
17 questions
STIN (EM24) - Tecnologías 4.0 (T13)
Quiz
•
University - Professi...
10 questions
SQL JOINS
Quiz
•
University
10 questions
Función CONTAR
Quiz
•
KG - Professional Dev...
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
6 questions
FOREST Self-Discipline
Lesson
•
1st - 5th Grade
7 questions
Veteran's Day
Interactive video
•
3rd Grade
20 questions
Weekly Prefix check #2
Quiz
•
4th - 7th Grade
Discover more resources for Computers
7 questions
Different Types of Energy
Interactive video
•
4th Grade - University
20 questions
Definite and Indefinite Articles in Spanish (Avancemos)
Quiz
•
8th Grade - University
7 questions
Force and Motion
Interactive video
•
4th Grade - University
25 questions
Waves-8th Grade Physical Science
Quiz
•
KG - University
41 questions
Unit 8 Key Terms
Quiz
•
11th Grade - University
10 questions
Product & Quotient Derivative Rules
Quiz
•
University
5 questions
How to Calculate Force - Newton's 2nd Law of Motion
Interactive video
•
10th Grade - University
10 questions
Dichotomous Key
Quiz
•
KG - University
