Search Header Logo

UAS Informatika Semester Genap

Authored by YOGA PRIAWINATA

Other

10th Grade

Used 3+ times

UAS Informatika Semester Genap
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

40 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

2 mins • 2 pts

Bagaimana cara menyesuaikan lebar kolom ke konten secara otomatis?

Drag batas kolom sambil menahan Shift

Double-klik batas kanan header kolom

Home → Format → Column Width

View → Zoom to Selection

Insert > Audio > Record Audio

2.

MULTIPLE CHOICE QUESTION

2 mins • 2 pts

Langkah mengatur tinggi baris ke 25 poin adalah…

Klik kanan nomor baris → Row Height → ketik 25

Home → Format → Column Width → ketik 25

View → Row Height → ketik 25

Insert → Row Height → ketik 25

Insert > Picture > From File, lalu pilih video

3.

MULTIPLE CHOICE QUESTION

2 mins • 2 pts

Rumus untuk menghitung total nilai tugas pada range C2:C11 adalah…

=TOTAL(C2:C11)

=SUM(C2:C11)

=ADD(C2:C11)

=SUMIF(C2:C11)

4.

MULTIPLE CHOICE QUESTION

2 mins • 2 pts

Fungsi yang menghitung rata-rata nilai pada range D2:D11 adalah…

=AVERAGE(D2:D11)

=MEAN(D2:D11)

=AVER(D2:D11)

=MEDIAN(D2:D11)

AVERAGE(B2:B5)

5.

MULTIPLE CHOICE QUESTION

2 mins • 2 pts

Untuk mengetahui jumlah data (sel terisi) pada range E2:E11, gunakan fungsi…

=COUNTBLANK(E2:E11)

=COUNTA(E2:E11)

=COUNT(E2:E11)

=LEN(E2:E11)

COUNT(B2:B10)

6.

MULTIPLE CHOICE QUESTION

2 mins • 2 pts

Fungsi yang memberikan nilai maksimum di range F2:F11 adalah…

=MAX(F2:F11)

=LARGE(F2:F11)

=BIG(F2:F11)

=MIN(F2:F11)

MAX(B2:B10)

7.

MULTIPLE CHOICE QUESTION

2 mins • 2 pts

Fungsi yang mengambil nilai terkecil dalam G2:G11 adalah…

=MIN(G2:G11)

=SMALL(G2:G11)

=LOW(G2:G11)

=MINIMUM(G2:G11)

MIN(B2:B10)

Access all questions and much more by creating a free account

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?