BASIC EXCEL - 7
Quiz
•
Computers
•
KG
•
Practice Problem
•
Hard
José Estrada
Used 16+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Function that returns the value found in the middle of a set of numbers or values
Fashion
Half
Median
Variance
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the following image, we are looking at the use of the COUNT function. What will be the value that should appear in cell E5?
8
3
7
5
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the following image, we are looking at the use of the COUNTA function. What will be the value that should appear in cell B7?
3
7
0
Ninguno
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
It is one of the functions that allows me to count the elements with a condition so that it can be executed correctly.
Count
COUNT SET
COUNT IF
COUNTBLANK
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the following image, we are looking at the use of the COUNTBLANK function. What will be the value that should appear in cell D1?
0
9
6
3
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
It is part of the logical functions and allows us to evaluate a condition to determine if it is true or false.
And
IF
OR
Concatenate
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the following figure using the IF function to place those conditions, which of the following is correct?
=SI(A2 > 18, "Menor de edad", SI(A2 <> 65, "Mayor de edad", "Tercera edad"))
=SI(A2 < 18, "Menor de edad", SI(A2 < 65, "Mayor de edad", "Tercera edad"))
=SI(A2 < 18, "Menor de edad", SI(A2 < 65, "Mayor de edad", "Mayor de 18 años"))
=SI(A2 < 18, "Menor de edad", SIA2 < 65, "Mayor de edad", "Tercera edad")
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
Contact Center Sevices
Quiz
•
7th - 10th Grade
10 questions
Questionário Aula 6 - Int. à Inf. (Segurança e Proteção)
Quiz
•
10th Grade
12 questions
ICT P2: Topic 5 - Recording & Presentation
Quiz
•
2nd Grade
12 questions
1.6 Ejemplo de aplicación Web
Quiz
•
12th Grade
10 questions
Quizz 3er Periodo 4°
Quiz
•
4th Grade
13 questions
Which of these softwares???
Quiz
•
4th - 5th Grade
10 questions
ICT as Platform for Change
Quiz
•
11th - 12th Grade
15 questions
Introducción Redes Tele1 IB
Quiz
•
10th Grade - University
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
4 questions
Conflict Resolution
Lesson
•
KG
20 questions
Place Value
Quiz
•
KG - 3rd Grade
20 questions
CVC Words
Quiz
•
KG - 1st Grade
24 questions
CKLA Unit 5 assessment K
Quiz
•
KG
10 questions
STAAR Review - Editing & Revising Clusters
Quiz
•
KG
10 questions
Reflexive Pronouns
Quiz
•
KG - 5th Grade
10 questions
Long i- igh, ie, and y Quiz
Quiz
•
KG - 3rd Grade
12 questions
Quarter Past, Half Past, and Quarter To
Quiz
•
KG - 12th Grade
