Data pasien di klinik memiliki banyak kolom kosong dan spasi ganda. Langkah awal yang harus dilakukan untuk merapikan?

D-6 Pre-Test STIKES

Quiz
•
Science
•
1st Grade
•
Hard
Uum Zakaria
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Gunakan fitur Trim dan Clean
Ubah warna
Ganti font
Freeze Panes
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Anda ingin membuat database sederhana untuk mendata kunjungan. Fitur apa yang memudahkan pencarian dan pemfilteran?
Wrap Text
Conditional Formatting
Format as Table
Group
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi rumus untuk menormalkan data teks dari “ Budi “ menjadi “Budi” adalah...
LEFT
TRIM
CLEAN
FIND
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Anda ingin mengambil 4 huruf pertama dari data “Pasien-2034”. Gunakan rumus...
=RIGHT(A1,4)
=MID(A1,1,4)
=LEFT(A1,4)
=LEN(A1)-4
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk menghitung banyaknya sel tidak kosong dalam kolom keluhan adalah...
COUNTA
COUNTBLANK
COUNTIF
IF
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Ketika data keluhan banyak yang ditulis manual dan tidak seragam ('demam', 'Demam', 'DEMAM'), Anda perlu...
Sorting
Pivot Table
Normalisasi data dengan UPPER/LOWER/PROPER
Replace all
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi apa yang digunakan untuk mendeteksi data ganda?
Find
Conditional Formatting > Duplicate Values
Wrap Text
Flash Fill
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
3R (Reduce, Reuse, Recycle)

Quiz
•
1st Grade - Professio...
14 questions
Cassette Clean Refresher

Quiz
•
1st Grade
10 questions
HaCS 2

Quiz
•
1st Grade
10 questions
Aplikasi Komputer

Quiz
•
1st Grade - University
10 questions
Perangkat Komputer

Quiz
•
1st Grade - University
15 questions
PKW01 - Dasar Keselamatan Kerja & Alat Pelindung Diri (APD)

Quiz
•
1st Grade
10 questions
D-8 Pre-Test STIKES

Quiz
•
1st Grade
15 questions
Sains Tahun 1 Organ Deria

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