Excel10
Authored by alexander García
Computers
2nd Grade
Used 12+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
11 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
La función que permite determinar a qué cliente mayor de 20 años y consumo superior a 200 tendrá descuento es:
SI(Y(A2>20;B2>200);"descuento 20%";0)
SI(A2>20;"descuento 20%";0)
SI(O(A2>20;B2>200);"descuento 20%";0)
SI(B2>200;"descuento 20%";0)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
La función "Y" arroja valor verdadero en caso una de todas las premisas sea verdadera
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
La sintaxis correcta de la función Si es:
Si(valor_buscado; Valor_verdadero; Valor_Falso)
Si(prueba lógica; Valor si verdadero; Valor si Falso)
Si(prueba lógica; Valor si falso; Valor si verdadero)
Si(Indicador de fila; Valor si verdadero; Valor si Falso)
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
La función BuscarV en Microsoft Excel, busca un valor en la primera fila
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
La función O de Microsoft Excel, comprueba si algunos de los argumentos es verdadero y devuelve VERDADERO si al menos uno lo es
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
En la función BuscarV de Microsoft Excel, el "Indicador de columna" representa el número de la columna donde se encuentra el valor a devolver
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
16 questions
1er. EXAMEN FCYE 2° ABC
Quiz
•
2nd Grade
8 questions
2do primaria excel
Quiz
•
2nd Grade
9 questions
Los periféricos del computador
Quiz
•
1st Grade - Professio...
10 questions
COMPUTACIÓN
Quiz
•
2nd Grade
10 questions
JavaScript: Estruturas Condicionais 2 - IF...ELSE
Quiz
•
2nd Grade
10 questions
NORMAS DE CONVIVENCIA
Quiz
•
1st - 3rd Grade
10 questions
Virus Informáticos
Quiz
•
1st - 10th Grade
10 questions
COMPUTACIÓN BÁSICA
Quiz
•
1st Grade - Professio...
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
Discover more resources for Computers
22 questions
Equal Groups and Arrays
Quiz
•
2nd Grade
10 questions
Life Cycle of a Frog
Quiz
•
1st - 2nd Grade
10 questions
Exploring Rosa Parks and Black History Month
Interactive video
•
1st - 5th Grade
20 questions
Counting Coins
Quiz
•
2nd Grade
20 questions
Place Value
Quiz
•
KG - 3rd Grade
30 questions
DA Math Mania Bowl - Primary
Quiz
•
2nd Grade
19 questions
Subject-Verb Agreement
Quiz
•
2nd - 5th Grade
10 questions
Harriet Tubman
Quiz
•
2nd - 3rd Grade