Seorang admin ingin tahu berapa pasien yang datang lebih dari 2 kali dan keluhannya ‘Demam’. Rumus terbaik?

D-6 Post Test STIKES

Quiz
•
Science
•
1st Grade
•
Hard
Uum Zakaria
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
IF + COUNT
COUNTIFS dengan dua syarat
SUM
MID
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Anda ingin menarik angka dari format campuran seperti “ID-20345”. Gunakan...
TRIM
CLEAN
RIGHT dengan LEN dan FIND
MAX
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk membersihkan karakter tak terlihat dari data hasil impor, gunakan...
UPPER
CLEAN
COUNTIF
MOD
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Ingin menggabungkan kolom “Nama Depan” dan “Nama Belakang” menjadi satu, gunakan rumus...
=A1&" "&B1
CONCATENATE(A1:B1)
SUM(A1:B1)
TEXTJOIN(A1:B1)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Anda menemukan data yang seharusnya angka tetapi dibaca teks oleh Excel. Solusi?
Ganti font
Gunakan VALUE() atau Text to Columns tanpa delimiter
Ubah warna
Pakai Conditional Formatting
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk menandai semua pasien yang umurnya > 60 tahun, gunakan...
Sorting
Conditional Formatting dengan rumus logika
Manual highlight
Chart
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus untuk menghitung durasi kunjungan pasien dari waktu masuk dan keluar adalah...
COUNTIF
=Waktu_Keluar - Waktu_Masuk
VLOOKUP
MOD
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
Quiz EKG

Quiz
•
1st Grade - University
10 questions
KMB II HEPATITIS

Quiz
•
1st Grade
10 questions
Қара-қоңыр топырақтар

Quiz
•
1st - 3rd Grade
10 questions
QUIZ KIMIA KLINIK 1

Quiz
•
1st Grade
10 questions
QH D3A TROMBO

Quiz
•
1st Grade
10 questions
D-4 Pre-Test

Quiz
•
1st Grade
15 questions
Investment Casting

Quiz
•
KG - Professional Dev...
10 questions
KUIS KK 2

Quiz
•
1st 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