fungsi sum dll Flashcards

1
Q

SUM

A

jumlah total

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

SUMIF

A

jumlah total kriteria

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

SUMIFS

A

jumlah total banyak kriteria

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

AVERAGE

A

rata rata

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

COUNT

A

hitung sel terpilih yang berisi angka

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

COUNTA

A

hitung sel terpilih kecuali sel kosong

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

COUNTIF

A

hitung sel terpilih dengan kriteria

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

COUNTIFS

A

hitung sel terpilih dengan banyak kriteria

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

jumlah total

A

SUM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

jumlah total kriteria

A

SUMIF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

jumlah total banyak kriteria

A

SUMIFS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

rata rata

A

AVERAGE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

hitung sel terpilih yang berisi angka

A

COUNT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

hitung sel terpilih kecuali sel kosong

A

COUNTA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

hitung sel terpilih kriteria

A

COUNTIF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

hitung sel terpilih banyak kriteria

A

COUNTIFS

17
Q

MIN

A

nilai terendah

18
Q

MAX

A

nilai tertinggi

19
Q

TRIM

A

menghapus spasi berlebih

20
Q

menghapus spasi berlebih

A

TRIM

21
Q

Replace

A

menggantikan

22
Q

menggantikan

A

Replace

23
Q

Unique

A

menulis data unik hanya 1 dari banyak data sama

24
Q

menulis data unik hanya 1 dari banyak data sama

A

Unique

25
Q

IF

A

perbandingan, true, false

26
Q

perbandingan, true, false

A

IF

27
Q

IF bertingkat

A

perbandingan, true, false bertingkat

28
Q

perbandingan, true, false bertingkat

A

IF bertingkat