Search Header Logo

Tes Formatif materi analisis data

Authored by dian ajisulistyo

Computers

8th Grade

Used 1+ times

Tes Formatif materi analisis data
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

Dari Tabel disamping untuk menghitung jumlah total adalah ... .

=C140*D140

=D140*E140

=C40*D40

=A140*D140

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

Bagaimana cara menambahkan simbol Rp di microsoft exel

Home - Font - Font size - Rp -Indonesia - ok

Insert - Number -Currency - Rp-Indonesia - ok

Home - Number -Currency - Rp-Indonesia - ok

Insert - Font - Font size - Rp -Indonesia - ok

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Untuk menghitung jumlah di Microsoft Exel menggunakan rumus fungsi .... .

SUM

AVERAGE

MAX

MIN

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Rumus atau Fungsi Microsoft Exel yang digunakan untuk pembacaan tabel dimana dua atau lebih tabel mempunyai data yang saling dihubungkan adalah ... .

Count

Sum

Vlookup

Countif

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Untuk menghitung rata - rata di Microsoft Exel menggunakan rumus fungsi .... .

Sum

Average

Count

Max

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

Dari tabel disamping tuliskan rumus jumlah

=Average(G140:G144)

=Sum(G140:G144)

=SUM(A140:G144)

=Average(A140:G144)

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

Rumus "Jenis Kamar " untuk tabel disamping adalah ... .

=VLOOKUP(A89,I89:K91,2,FALSE)

=HLOOKUP(AA89,AI89:AK91,2,FALSE)

=COUNTIF(AA89,AI89:AK91,2,FALSE)

=VLOOKUP(AA89,AI89:AK91,2,FALSE)

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?