Apa fungsi IF di Excel ?

Ulangan Excel 1

Quiz
•
Instructional Technology
•
8th Grade
•
Hard
Fatah Maulanov
Used 8+ times
FREE Resource
25 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
3 mins • 4 pts
Hitung rata-rata
Bandingkan dua nilai
Ubah format teks
Buat diagram
2.
MULTIPLE CHOICE QUESTION
3 mins • 4 pts
Jika A1 adalah 5, apa yang akan dikembalikan oleh rumus =IF(A1>10, "Besar", "Kecil")?
Ubah nilai sel
Tambahkan angka
Besar
Kecil
3.
MULTIPLE CHOICE QUESTION
3 mins • 4 pts
Apa fungsi AND dalam Excel?
Memeriksa apakah semua kondisi benar
Memeriksa apakah ada kondisi yang benar
Memeriksa kondisi yang salah
Memeriksa kesalahan data
4.
MULTIPLE CHOICE QUESTION
3 mins • 4 pts
Apa hasil dari =AND(5>3, 4<2)?
BENAR
SALAH
1
0
5.
MULTIPLE CHOICE QUESTION
3 mins • 4 pts
Kapan fungsi OR di Excel mengembalikan nilai TRUE?
Semua kondisi salah
Semua kondisi benar
Setidaknya satu kondisi benar
Semua kondisi baik salah maupun benar
6.
MULTIPLE CHOICE QUESTION
3 mins • 4 pts
Jika A1 = 4 dan B1 = 2, apa hasil dari rumus =IF(OR(A1>5, B1<3)?
Ya
Tidak
BENAR
Kesalahan
7.
MULTIPLE CHOICE QUESTION
3 mins • 4 pts
Hey Eko, what will =NOT(TRUE) return?
BENAR
SALAH
Kesalahan
0
Create a free account and access millions of resources
Similar Resources on Wayground
28 questions
TIN 7_KT GIỮA KỲ 2 2022

Quiz
•
1st - 12th Grade
25 questions
8 -р анги

Quiz
•
8th Grade
22 questions
UH TIK KELAS 8 YPPS

Quiz
•
8th Grade
20 questions
Pemeliharaan Sasis dan Pemindah Tenaga

Quiz
•
1st Grade - University
20 questions
Teknologi Informasi

Quiz
•
8th Grade
21 questions
Soluciones Tecnológicas :: Evaluación de Nivel 2

Quiz
•
7th - 12th Grade
20 questions
TIK SD

Quiz
•
7th - 12th Grade
20 questions
Latihan4

Quiz
•
8th Grade
Popular Resources on Wayground
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade