Quiz Microsoft Excel / Google Sheet

Quiz Microsoft Excel / Google Sheet

10th Grade

30 Qs

quiz-placeholder

Similar activities

TIK SMP

TIK SMP

7th - 12th Grade

25 Qs

Review Materi 1 dan 2

Review Materi 1 dan 2

8th - 10th Grade

25 Qs

Intro to Business Computer Applications Final Review

Intro to Business Computer Applications Final Review

9th - 12th Grade

25 Qs

pangkalan data lanjutan sains komputer tingkatan 5

pangkalan data lanjutan sains komputer tingkatan 5

1st Grade - Professional Development

25 Qs

Soal PAS Simulasi dan Komunikasi Digital  APHP & ATPH X (Ganjil)

Soal PAS Simulasi dan Komunikasi Digital APHP & ATPH X (Ganjil)

10th Grade

25 Qs

ulangan harian semester genap

ulangan harian semester genap

10th Grade

25 Qs

MS excel amaliy mashq

MS excel amaliy mashq

10th Grade

26 Qs

Quiz Analisis Data

Quiz Analisis Data

10th Grade

25 Qs

Quiz Microsoft Excel / Google Sheet

Quiz Microsoft Excel / Google Sheet

Assessment

Quiz

Computers

10th Grade

Practice Problem

Medium

Created by

SUYADI SUYADI

Used 31+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

30 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Jika Anda ingin menghitung rata-rata nilai siswa dari sel B2 sampai B11, rumus yang benar adalah …

=SUM(B2:B11)

=AVERAGE(B2:B11)

=MAX(B2:B11)/MIN(B2:B11)

=LEN(B2:B11)

=COUNTIF(B2:B11)

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Dalam sebuah worksheet, fungsi =IF(C2>=75,"Lulus","Remidi") akan menampilkan …

Nilai asli siswa

Jumlah seluruh nilai pada kolom C

Keterangan "Lulus" jika nilai ≥ 75, atau "Remidi" jika < 75

Hanya teks "Lulus"

Hanya teks "Remidi"

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Rumus =LEN("Informatika") akan menghasilkan …

11

10

12

9

Error

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Fungsi =LEFT("Komputer",3) akan menampilkan …

KOMP

KOM

PUT

TER

Error

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Dalam rumus =5+3*2, hasil yang benar adalah …

16

11

13

10

8

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Jika sebuah tabel berisi harga barang pada sel D2:D10, maka untuk mencari harga tertinggi digunakan rumus …

=SUM(D2:D10)

=AVERAGE(D2:D10)

=MAX(D2:D10)

=MIN(D2:D10)

=COUNT(D2:D10)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Fungsi =COUNTIF(A2:A15,"Laki-laki") digunakan untuk …

Menghitung jumlah karakter dalam sel

Menghitung rata-rata data

Menghitung jumlah data teks "Laki-laki"

Mencari nilai terbesar

Menghitung jumlah kolom

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

Already have an account?

Discover more resources for Computers