Mamaraximov E
Authored by Elyor Mamaraximov
Computers
Professional Development
Used 13+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
14 questions
Show all answers
1.
FILL IN THE BLANKS QUESTION
30 sec • 1 pt
Excel dasturida sonning kvadrat ildizini topuvchi funksiya nomini toping?
Katta harflarda kiriting
=????
(a)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Excel dasturida yozilgan quyidagi misol javobini toping?
=CONCAT("O'z",IF(5>(2^(TRUE+2*3)),"bek","ak"))
O'zbek
O'zak
O'zbekak
O'zakbek
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Excel dasturida quyidagi to'g'ri yozilgan formulani toping?
=IF(AND(A1>10, B1<5), "Tugadi", "Tugamadi")
=IF(OR(A1>10, B1<5), "Tugadi"; "Tugamadi")
=IF(A1>10;"Tugadi"; IF(B1<5, "Tugadi";"Tugamadi"))
=IF(A1>10, "Tugadi", IF(B1<5, "Tugamadi"))
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Excel dasturida quyidagi formulani yozing?
=SUMIF(A1:A10, ">5", B1:B10)
=SUMIF(A1:A10, ">5", B1:B10)
=SUMIF(A1:A10, "<5", B1:B10)
=SUMIF(A1:A10, "=5", B1:B10)
=SUMIF(A1:A10, "5", B1:B10)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Excel dasturida quyidagi formulani yozing?
=INDEX(A1:A10, MATCH(5, B1:B10, 0))
=INDEX(A1:A10, MATCH(5, B1:B10, 0))
=MATCH(A1:A10, INDEX(5, B1:B10), 0)
=LOOKUP(A1:A10, 5, B1:B10)
=VLOOKUP(A1:A10, 5, B1:B10, FALSE)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Excel dasturida quyidagi formulani yozing?
=COUNTIF(A1:A10, ">5")
=COUNTIF(A1:A10, ">5")
=COUNTIF(A1:A10, "<5")
=COUNTIF(A1:A10, "=5")
=COUNTIF(A1:A10, "5")
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Excel dasturida quyidagi formulani yozing?
=AVERAGEIF(A1:A10, ">5", B1:B10)
=AVERAGEIF(A1:A10, ">5", B1:B10)
=AVERAGEIF(A1:A10, "<5", B1:B10)
=AVERAGEIF(A1:A10, "=5", B1:B10)
=AVERAGEIF(A1:A10, "5", B1:B10)
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?
