FUNCIÓN BUSCAR
Authored by Harry Elvis Ccoaquira Enriquez
Other
University
Used 8+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
¿Cuál es la función principal de BUSCARV en Excel?
Calcular promedios
Buscar un valor en una fila
Buscar un valor en la primera columna de una tabla
Ordenar datos alfabéticamente
2.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
¿Qué argumento se usa en BUSCARV para que el valor sea exacto?
VERDADERO
FALSO
0
BUSCAR
3.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
¿Cuál es la diferencia entre BUSCARH y BUSCARV?
BUSCARV es más rápida
BUSCARV busca en filas, BUSCARH en columnas
BUSCARV busca en columnas, BUSCARH en filas
No hay ninguna diferencia
4.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
¿Cuál de las siguientes funciones es adecuada para buscar un valor en una tabla horizontal?
BUSCARV
BUSCAR
BUSCARH
SUMA
5.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
¿Qué devuelve esta fórmula: =BUSCARV(12346, A2:C5, 2, FALSO) si en A3 está 12346 y en B3 'María'?
12346
C5
María
FALSO
6.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
¿Qué ocurre si BUSCARV no encuentra el valor buscado y no se usa SI.ERROR?
Da 0
Muestra 'No encontrado'
Muestra #N/A
Devuelve la celda vacía
7.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
¿Cuál es la sintaxis correcta de BUSCARV?
=BUSCARV(valor, rango)
=BUSCARV(valor, tabla, columna, [coincidencia exacta])
=BUSCARV(valor, columna)
=BUSCAR(valor, tabla, columna)
Access all questions and much more by creating a free account
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
Already have an account?
Similar Resources on Wayground
10 questions
CADENA DE CUSTODIA ICJEO
Quiz
•
University
10 questions
Les verbes: Être et Avoir
Quiz
•
KG - Professional Dev...
10 questions
Tema 2
Quiz
•
University
10 questions
UK Knowledge Test
Quiz
•
University
10 questions
Curso de inducción
Quiz
•
University
10 questions
Primeros Auxilios
Quiz
•
University
13 questions
Primer Parcial de Ética y Responsabilidad Social
Quiz
•
University
12 questions
Prueba_1er parcial
Quiz
•
9th Grade - University
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Other
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
23 questions
Subject Verb Agreement
Quiz
•
9th Grade - University
5 questions
What is Presidents' Day?
Interactive video
•
10th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
20 questions
Mardi Gras History
Quiz
•
6th Grade - University
10 questions
The Roaring 20's Crash Course US History
Interactive video
•
11th Grade - University
17 questions
Review9_TEACHER
Quiz
•
University