Mamaraximov E

Mamaraximov E

Professional Development

14 Qs

quiz-placeholder

Similar activities

Microsoft Excel

Microsoft Excel

Professional Development

15 Qs

Bài4: Sử dụng Hàm để tính toán

Bài4: Sử dụng Hàm để tính toán

Professional Development

10 Qs

Septimo

Septimo

KG - Professional Development

10 Qs

Excel Game 1

Excel Game 1

Professional Development

15 Qs

Función SPARKLINE

Función SPARKLINE

KG - Professional Development

13 Qs

Word y excel

Word y excel

Professional Development

9 Qs

Excel básico

Excel básico

Professional Development

13 Qs

Kiến thức về bảng tính

Kiến thức về bảng tính

Professional Development

16 Qs

Mamaraximov E

Mamaraximov E

Assessment

Quiz

Computers

Professional Development

Medium

Created by

Elyor Mamaraximov

Used 13+ times

FREE Resource

14 questions

Show all answers

1.

FILL IN THE BLANK QUESTION

30 sec • 1 pt

Excel dasturida sonning kvadrat ildizini topuvchi funksiya nomini toping?

Katta harflarda kiriting
=????

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)

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?