Analisis Data 7 - Informatika

Analisis Data 7 - Informatika

7th Grade

15 Qs

quiz-placeholder

Similar activities

Excel Quiz

Excel Quiz

KG - University

15 Qs

Tabeliarvutus (algus)

Tabeliarvutus (algus)

6th - 8th Grade

11 Qs

Excel-Các công cụ định dạng

Excel-Các công cụ định dạng

5th Grade - University

10 Qs

Introduction to Excel

Introduction to Excel

6th - 10th Grade

15 Qs

Balanced Lifestyles & Spreadsheets Quiz

Balanced Lifestyles & Spreadsheets Quiz

7th Grade

15 Qs

Sesión 03

Sesión 03

1st - 12th Grade

10 Qs

Yr 8.1 Spreadsheet/Excel Models

Yr 8.1 Spreadsheet/Excel Models

6th - 8th Grade

20 Qs

Bài 5. Thao tác với bảng tính

Bài 5. Thao tác với bảng tính

1st - 12th Grade

20 Qs

Analisis Data 7 - Informatika

Analisis Data 7 - Informatika

Assessment

Quiz

Computers

7th Grade

Practice Problem

Hard

Created by

Yohan Adi Setiawan

Used 5+ times

FREE Resource

AI

Enhance your content in a minute

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

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 2 pts

Fitur ini dapat memberi warna latar pada cell.

Absolute Cell References

Fill Color

Format Accounting

Format Number

2.

MULTIPLE CHOICE QUESTION

1 min • 2 pts

$C$9 merupakan contoh dari ....

Absolute Cell References

Format Currency

Mixed Cell References

Freeze Panes

3.

MULTIPLE CHOICE QUESTION

1 min • 2 pts

Formula untuk menghitung total jumlah

nilai pada range tertentu adalah ...

SUM

COUNT

IF

MAX

4.

MULTIPLE CHOICE QUESTION

1 min • 2 pts

Formula untuk menghitung jumlah Data pada range

tertentu adalah ...

SUM

COUNT

MAX

MIN

5.

MULTIPLE CHOICE QUESTION

1 min • 2 pts

Untuk satu kondisi tertentu dan datanya sama dengan yang akan dijumlahkan,

dapat langsung menggunakan formula ...

SUM

COUNT

SUMIF

COUNTIF

6.

MULTIPLE CHOICE QUESTION

1 min • 2 pts

Jika ingin mengetahui jumlah data berdasarkan satu kondisi tertentu saja,

dapat menggunakan fungsi formula ...

SUM

COUNT

SUMIF

COUNTIF

7.

MULTIPLE CHOICE QUESTION

1 min • 2 pts

Pada Cell A1 terdapat data 5 dan Cell B1 terdapat data 5. Dengan Formula pada Cell C1 =A1*B1, berapakah hasil formula tersebut ...

5

10

25

Nan

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?