HAVE FUN

HAVE FUN

11th Grade

10 Qs

quiz-placeholder

Similar activities

Entendendo funções no Excel

Entendendo funções no Excel

10th - 12th Grade

15 Qs

HOJA DE CALCULO APLICADA

HOJA DE CALCULO APLICADA

11th Grade

15 Qs

BAI 5 TU BAI TOAN DEN CHUONG TRINH 8C

BAI 5 TU BAI TOAN DEN CHUONG TRINH 8C

8th - 12th Grade

10 Qs

XI - Kuis AP 1

XI - Kuis AP 1

11th Grade

10 Qs

Among Us Review Game

Among Us Review Game

11th - 12th Grade

10 Qs

7 клас Підсумковий тест з інформатики

7 клас Підсумковий тест з інформатики

1st - 12th Grade

12 Qs

Asesmen PHP IF

Asesmen PHP IF

11th Grade

9 Qs

ASK F2 -KOD ARAHAN (PYTHON)

ASK F2 -KOD ARAHAN (PYTHON)

1st Grade - University

15 Qs

HAVE FUN

HAVE FUN

Assessment

Quiz

Computers

11th Grade

Medium

Created by

Wiwid Wulandari

Used 2+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Fungsi teks yang digunakan untuk mengambil sejumlah karakter dari suatu teks atau sel dimulai dari sebelah kiri adalah.......

CONCATENATE

LEFT

RIGHT

UPPER

LOWER

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Media Image

Formula yang benar untuk menuliskan hasil pada cell "B2" adalah....

=LEN(A1;4)

=LOWER(A2;4)

=MID(A2;4)

=REPT(A2;4)

=LEFT(A2;4)

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Media Image

Rumus yang digunakan untuk hasil pada B2 adalah......

=ROUND(B2;2)

=ROUNDUP(B2;2)

=ROUNDUP(B2;3)

=ROUNDDOWN(B2;2)

=ROUNDDOWN(B2;3)

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Media Image

Rumus yang tepat untuk cell "B2" adalah....

=MID(A2;5;4)

=MID(A2;4;5)

=LEFT(A2;3)

=RIGHT(A2;3)

=MID(A2;3;4)

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Media Image

Rumus/ formula Ms. Excel pada cell "B6" yang tepat adalah....

=AVERAGE(B2:B5)

=AVERAGE(C2:C5)

=MIN(B2:B5)

=SUM(C2:C5)

=SUM(B2:B5)

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Media Image

Formula yang tepat digunakan untuk menentukan hasil pada cell "C2" yaitu..........

=IF(OR(A2<50;B2>60);"LULUS";"GAGAL")

=IF(OR(A2<50;B2<60);"LULUS";"GAGAL")

=IF(OR(A2>50;B2>60);"LULUS";"GAGAL")

=IF(OR(A2<70;B2<60);"LULUS";"GAGAL")

=IF(OR(A2>50;B2<60);"LULUS";"GAGAL")

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Media Image

Fungsi yang tepat untuk semua hasil pada kolom keterangan yaitu......

=IF(A3<50;"LULUS";"GAGAL")

=IF(A2>=50;"LULUS";"GAGAL")

=IF(A6>=80;"LULUS";"GAGAL")

=IF(A5>=40;"LULUS";"GAGAL")

=IF(A4<=50;"LULUS";"GAGAL")

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?