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
12 questions
prep1-revision
Quiz
•
7th Grade
10 questions
Grade 2- PA1
Quiz
•
2nd Grade
15 questions
4.6.4 Logic Gates
Quiz
•
10th Grade - Professi...
12 questions
Wee Word Intro
Quiz
•
7th - 12th Grade
10 questions
Design Graphic Week 1
Quiz
•
7th Grade
10 questions
Què en saps de GSuite?
Quiz
•
University - Professi...
10 questions
THE PHOTOSHOP WINDOW
Quiz
•
7th - 8th Grade
10 questions
EXCEL AVANZADO - 6
Quiz
•
KG
Popular Resources on Wayground
8 questions
2 Step Word Problems
Quiz
•
KG - University
20 questions
Comparing Fractions
Quiz
•
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
10 questions
Latin Bases claus(clois,clos, clud, clus) and ped
Quiz
•
6th - 8th Grade
22 questions
fractions
Quiz
•
3rd Grade
7 questions
The Story of Books
Quiz
•
6th - 8th Grade
Discover more resources for Computers
8 questions
2 Step Word Problems
Quiz
•
KG - University
20 questions
Place Value
Quiz
•
KG - 3rd Grade
20 questions
CVC Words
Quiz
•
KG - 1st Grade
10 questions
Subject Verb Agreement
Quiz
•
KG - 2nd Grade
22 questions
Oh, Canada (Test Review)
Quiz
•
KG
10 questions
14.2 Independent/Dependent Variables
Quiz
•
KG - University
16 questions
CHARACTERIZATION
Quiz
•
KG - 8th Grade
18 questions
Great Lakes States
Quiz
•
KG - University
