fungsi sum dll

Question 1

SUM

Answer 1

jumlah total

Question 2

SUMIF

Answer 2

jumlah total kriteria

Question 3

SUMIFS

Answer 3

jumlah total banyak kriteria

Question 4

AVERAGE

Answer 4

rata rata

Question 5

COUNT

Answer 5

hitung sel terpilih yang berisi angka

Question 6

COUNTA

Answer 6

hitung sel terpilih kecuali sel kosong

Question 7

COUNTIF

Answer 7

hitung sel terpilih dengan kriteria

Question 8

COUNTIFS

Answer 8

hitung sel terpilih dengan banyak kriteria

Question 9

jumlah total

Answer 9

SUM

Question 10

jumlah total kriteria

Answer 10

SUMIF

Question 11

jumlah total banyak kriteria

Answer 11

SUMIFS

Question 12

rata rata

Answer 12

AVERAGE

Question 13

hitung sel terpilih yang berisi angka

Answer 13

COUNT

Question 14

hitung sel terpilih kecuali sel kosong

Answer 14

COUNTA

Question 15

hitung sel terpilih kriteria

Answer 15

COUNTIF

Question 16

hitung sel terpilih banyak kriteria

Answer 16

COUNTIFS

Question 17

MIN

Answer 17

nilai terendah

Question 18

MAX

Answer 18

nilai tertinggi

Question 19

TRIM

Answer 19

menghapus spasi berlebih

Question 20

menghapus spasi berlebih

Answer 20

TRIM

Question 21

Replace

Answer 21

menggantikan

Question 22

menggantikan

Answer 22

Replace

Question 23

Unique

Answer 23

menulis data unik hanya 1 dari banyak data sama

Question 24

menulis data unik hanya 1 dari banyak data sama

Answer 24

Unique

Question 25

IF

Answer 25

perbandingan, true, false

Question 26

perbandingan, true, false

Answer 26

IF

Question 27

IF bertingkat

Answer 27

perbandingan, true, false bertingkat

Question 28

perbandingan, true, false bertingkat

Answer 28

IF bertingkat