1. Bagaimana cara Anda menamai sebuah range di Excel?
SOAL POST TEST MICROSOFT EXCEL INTERMEDIATE OF ADVANCED
Professional Development
•25 Qs
Similar activities
ULANGAN HARIAN INFORMATIKA
Professional Development
•20 Qs
Kuis BIMTEK KEMAS Representative Day 4
Professional Development
•20 Qs
Customer Service - Service Tools (1)
Professional Development
•20 Qs
Bahasa Melayu ( Penjodoh Bilangan)
1st Grade - Professional Development
•20 Qs
Mobile Legend Quiz
Professional Development
•20 Qs
SMW 2 M3 MARET 2022
5th Grade - Professional Development
•20 Qs
BAHASA MELAYU TINGKATAN 1
3rd Grade - Professional Development
•20 Qs
ACTIVE TRADER QUIZ (TOS)
Professional Development
•20 Qs
SOAL POST TEST MICROSOFT EXCEL INTERMEDIATE OF ADVANCED
Quiz
•
Other
•
Professional Development
•
Medium
Media Edutama
Used 1+ times
FREE Resource
25 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A. Mengetik nama range di kotak "Name Box"
B. Mengklik kanan pada sel dan memilih "Name Range"
C. Menggunakan fungsi =NAMERANGE()
D. Menambah nama range di menu "Insert"
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
2. Tuliskan rumus untuk menjumlahkan data dari sel A1 di Sheet1 dan sel A1 di Sheet2.
A. =SUM(Sheet1!A1+Sheet2!A1)
B. =SUM(A1, Sheet1!A1, Sheet2!A1)
C. =SUM(A1+Sheet1!A1+Sheet2!A1)
D. =Sheet1!A1+Sheet2!A1
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
3. Berikan contoh penggunaan fungsi TEXT untuk mengubah format angka menjadi teks.
A. =TO_TEXT(A1, "0.00")
B. =TEXT(A1,"0.00")
C. =TEXTFORMAT(A1, "0.00")
D. =TEXTCONVERT(A1, "0.00")
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
4. Apa perbedaan antara fungsi IF dan IFS? Berikan contohnya.
A. IF tidak mendukung logika ganda, IFS mendukung.
B. IFS digunakan untuk kondisi tunggal, IF untuk kondisi ganda.
C. IF digunakan untuk kondisi tunggal, IFS untuk kondisi ganda.
D. IF digunakan untuk perhitungan angka, IFS untuk teks.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
5. Bagaimana cara menggunakan VLOOKUP untuk mencari data di tabel? Berikan contoh rumusnya.
A. =VLOOKUP(A1, Table, 2, TRUE)
B. =VLOOKUP(A1, Table, 2, FALSE)
C. =LOOKUP(A1, Table, 2, FALSE)
D. =LOOKUP(A1, Table, 2, TRUE)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
6. Bagaimana cara membuat tabel dari rentang data di Excel?
A. Pilih data, klik "Home", lalu "Table".
B. Pilih data, klik "Data", lalu "Table".
C. Pilih data, klik "Insert", lalu "Table".
D. Pilih data, klik "Format", lalu "Table".
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
7. Sebutkan langkah-langkah untuk menambahkan kolom baru dalam tabel yang sudah ada.
A. Klik kanan pada tabel dan pilih "Insert Column".
B. Klik tab "Table Design" dan pilih "Insert Column".
C. Klik tab "Home" dan pilih "Insert Column".
D. Klik kanan pada kolom dan pilih "Insert".
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports
Microsoft
Apple
Others
Similar Resources on Quizizz
20 questions
Konjungsi (pemula 1)
Quiz
•
Professional Development
20 questions
QC MBS 2
Quiz
•
Professional Development
20 questions
Pengelolaan & Pemanfaatan TIK 2023
Quiz
•
Professional Development
30 questions
Shoutest Nihongo Zoom (#16-17-18)
Quiz
•
1st Grade - Professio...
20 questions
ULANGKAJI C04
Quiz
•
Professional Development
20 questions
Soalan Pengetahuan Am Pelajar
Quiz
•
1st Grade - Professio...
20 questions
POST- TEST Motion Graphics
Quiz
•
Professional Development
20 questions
UJI KOMPETENSI IGTM
Quiz
•
Professional Development
Popular Resources on Quizizz
15 questions
Character Analysis
Quiz
•
4th Grade
17 questions
Chapter 12 - Doing the Right Thing
Quiz
•
9th - 12th Grade
10 questions
American Flag
Quiz
•
1st - 2nd Grade
20 questions
Reading Comprehension
Quiz
•
5th Grade
30 questions
Linear Inequalities
Quiz
•
9th - 12th Grade
20 questions
Types of Credit
Quiz
•
9th - 12th Grade
18 questions
Full S.T.E.A.M. Ahead Summer Academy Pre-Test 24-25
Quiz
•
5th Grade
14 questions
Misplaced and Dangling Modifiers
Quiz
•
6th - 8th Grade