Mamaraximov E

Mamaraximov E

Professional Development

14 Qs

quiz-placeholder

Similar activities

Ofimática

Ofimática

Professional Development

15 Qs

2. Empezando a trabajar con Excel

2. Empezando a trabajar con Excel

Professional Development

9 Qs

Consolidación de Datos en Excel

Consolidación de Datos en Excel

Professional Development

19 Qs

Ms Excel - Preguntas Básicas

Ms Excel - Preguntas Básicas

Professional Development

11 Qs

Quiz: Repaso de Google Sheets – Operaciones y Funciones Básicas

Quiz: Repaso de Google Sheets – Operaciones y Funciones Básicas

Professional Development

10 Qs

Excel Functions

Excel Functions

Professional Development

15 Qs

Excel Intermedio [01]

Excel Intermedio [01]

7th Grade - Professional Development

11 Qs

Evaluación Inicial Excel

Evaluación Inicial Excel

Professional Development

17 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

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?