En base a la tabla que se muestra en la imagen calcular:
¿Cuánto suma el Sueldo Básico de los contratados?
Condicionales en Excel
10th Grade
•10 Qs
Similar activities
REVISÃO - 4º ANO - SEGURANÇA NA INTERNET 01
4th Grade - University
•15 Qs
Cuestionario de Excel
9th Grade - University
•10 Qs
Mis registros digitales
5th - 12th Grade
•10 Qs
Sistemático Excel 11mo
10th Grade
•10 Qs
Cap06_3roB_Naranjal
4th Grade - Professional Development
•10 Qs
EXAMEN DOCENTE
1st Grade - University
•10 Qs
EVALUACIÓN DE TECNOLOGÍA GRADO QUINTO
10th Grade
•12 Qs
grado 4º
10th Grade
•10 Qs
Condicionales en Excel
Quiz
•
Instructional Technology
•
10th Grade
•
Hard
Silvia Villa
Used 24+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
=SUMAR.SI(F5:F14;"contratado";G5:G14)
=SUMAR(F5:F14;"contratado")
=CONTAR.SI(F5:F14;"contratado";G5:G14)
=SUMAR.SI(F5:F14;"contratado")
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cuánto es el Promedio del SUELDO BÁSICO de los contratados?
=SUMAR.SI(F5:F14;"contratado";G5:G14)
=PROMEDIO.SI(F5:F14;"contratado";G5:G14)
=PROMEDIO.SI(F5:F14;"contratado")
=CONTAR.SI(F5:F14;"contratado";G5:G14)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cuántas personas tienen más de 19 años de servicio?
=CONTAR.SI(E5:E14;"<19")
=CONTAR.SI(E5:E14;" MÁS 19")
=CONTAR.SI(E5:E14;">19")
=CONTAR.SI(E5:E14;">19"; H5:H14)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cuántas películas tienen un costo de 1?
=SUMAR.SI(E3:E17; 1)
=CONTAR.SI(E3:E17; "1"; F3:F17)
=CONTAR(E3:E17; 1)
=CONTAR.SI(E3:E17; 1)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Calcular el PROMEDIO del alquiler de todas la películas con formato DVD"
=PROMEDIO.SI(D3:D17; "DVD"; E3:E17)
=CONTAR.SI(D3:D17; "DVD"; E3:E17)
=PROMEDIO(D3:D17; "DVD"; E3:E17)
=PROMEDIO.SI(D3:D17; "DVD")
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cuántos películas no están disponibles?
=CONTAR(F3:F17; "NO")
=CONTAR.SI(F3:F17; "NO"; D3:D17)
=CONTAR.SI(F3:F17)
=CONTAR.SI(F3:F17; "NO")
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Calcular el PROMEDIO del saldo de los clientes ?"
=PROMEDIO(H3:H18)
=PROMEDIO.SI(H3:H18; "SALDO")
=PROMEDIO.SI(H3:H18)
=SUMAR.SI(H3:H18)
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports
Microsoft
Apple
Others
Similar Resources on Quizizz
10 questions
Les Tableurs ( Microsoft Excel ) 1
Quiz
•
6th - 12th Grade
9 questions
Sistema binario
Quiz
•
7th - 10th Grade
14 questions
¿QUÉ TANTO SABES?
Quiz
•
1st - 12th Grade
12 questions
Tecnología e Informática - Prueba final P1
Quiz
•
10th Grade
10 questions
10º Relación de transmisión Poleas
Quiz
•
10th Grade
10 questions
Sistemático Excel 11mo
Quiz
•
10th Grade
10 questions
EXAMEN DOCENTE
Quiz
•
1st Grade - University
15 questions
Evaluación diagnóstica bloque 3: Herramientas Sw aplicación
Quiz
•
1st - 12th Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts
Quiz
•
4th Grade
20 questions
Math Review - Grade 6
Quiz
•
6th Grade
20 questions
math review
Quiz
•
4th Grade
5 questions
capitalization in sentences
Quiz
•
5th - 8th Grade
10 questions
Juneteenth History and Significance
Interactive video
•
5th - 8th Grade
15 questions
Adding and Subtracting Fractions
Quiz
•
5th Grade
10 questions
R2H Day One Internship Expectation Review Guidelines
Quiz
•
Professional Development
12 questions
Dividing Fractions
Quiz
•
6th Grade
Discover more resources for Instructional Technology
25 questions
Spanish preterite verbs (irregular/changed)
Quiz
•
9th - 10th Grade
10 questions
Juneteenth: History and Significance
Interactive video
•
7th - 12th Grade
8 questions
"Keeping the City of Venice Afloat" - STAAR Bootcamp, Day 1
Quiz
•
9th - 12th Grade
20 questions
Distance, Midpoint, and Slope
Quiz
•
10th Grade
20 questions
Figurative Language Review
Quiz
•
10th Grade
20 questions
Understanding Linear Equations and Slopes
Quiz
•
9th - 12th Grade