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
10 questions
PARTES DE LA COMPUTADORA
Quiz
•
1st - 2nd Grade
14 questions
Quiz sobre documentos y dibujos de google, y dispositivos
Quiz
•
1st - 6th Grade
11 questions
MATERIAS PRIMAS
Quiz
•
2nd - 3rd Grade
10 questions
Programa de MS Word
Quiz
•
2nd Grade
10 questions
INDUCCION BASE DE DATOS:
Quiz
•
2nd Grade
10 questions
WIX
Quiz
•
1st - 11th Grade
10 questions
Programação de Computadores - Aula - 5
Quiz
•
1st - 3rd Grade
10 questions
Insertar imágenes en Word
Quiz
•
2nd Grade
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
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
20 questions
Figurative Language Review
Quiz
•
6th Grade
Discover more resources for Computers
14 questions
Contractions
Quiz
•
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
19 questions
Subject-Verb Agreement
Quiz
•
2nd - 5th Grade
13 questions
Fractions
Quiz
•
1st - 2nd Grade
12 questions
2-Digit Subtraction with Regrouping
Quiz
•
2nd Grade
14 questions
Fractions
Quiz
•
2nd - 3rd Grade