Digunakan untuk menarik data secara vertikal adalah fungsi dari rumus ?
Vlookup Hlookup
9th - 12th Grade
•8 Qs
Similar activities
Vlookup
10th Grade
•10 Qs
Latihan soal kelas 8_Analisis Data (Pencarian Data)
9th - 12th Grade
•10 Qs
Microsoft Excel Dasar
12th Grade - University
•10 Qs
Ms Excel 101 Series - Intermediate Level
12th Grade
•10 Qs
Kisi-kisi SAJ Informatika
9th Grade
•10 Qs
Google Sheets - Aritmatika dan $
11th Grade
•10 Qs
Spreadsheet Kelas X SMK
10th Grade
•10 Qs
PRETEST PEMBACAAN TABEL
10th Grade
•4 Qs
Vlookup Hlookup
Quiz
•
Computers
•
9th - 12th Grade
•
Easy
Nurbani Wulandari
Used 5+ times
FREE Resource
8 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Hlookup
Max
Average
Vlookup
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Digunakan untuk menarik data secara horizontal adalah fungsi dari rumus ?
Hlookup
Max
Average
Vlookup
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Tombol apa yang digunakan untuk mengunci sel berisi rumus ?
F1
Ctrl
Alt
F4
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Bagaimana penulisan rumus Vlookup yang benar ?
=vlookup(sel pertama:sel terakhir)
=vlookup(nilai;"kondisi terpenuhi";"kondisi tidak terpenuhi")
=vlookup(Kata kunci;tabel referensi;nomor kolom;false)
=vlookup(range;"kriteria")
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Kenapa kita perlu mengunci sel tabel referensi ?
Agar tidak terbang
Agar datanya tidak geser
Agar sel nya berwarna
membuat teksnya tebal
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Manakah menu yang berfungsi untuk menampilkan mata uang ?
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Tegak lurus dari atas ke bawah atau sebaliknya di sebut..
Persegi
Vertikal
Lingkaran
Horizontal
8.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Garis yang sejajar atau mendatar dari kiri ke kanan atau sebaliknya disebut....
Persegi
Vertikal
Lingkaran
Horizontal
Similar Resources on Quizizz
10 questions
Uji Kompetensi 2: Fungsi Spreadsheet
Quiz
•
10th Grade
10 questions
Quiz Fungsi Excel
Quiz
•
9th Grade - University
13 questions
QUIZ - Microsoft Excel
Quiz
•
10th Grade
8 questions
PRE-TEST INFORMATIKA TG 1
Quiz
•
10th Grade
10 questions
Hlookup
Quiz
•
10th Grade
10 questions
Review Komputer Mid SMA (2)
Quiz
•
10th Grade
10 questions
ULANGAN VLOOKUP dan HLOOKUP
Quiz
•
9th Grade
8 questions
QUIZ TIK KELAS XI
Quiz
•
11th Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts
Quiz
•
4th Grade
20 questions
Math Review - Grade 6
Quiz
•
6th Grade
20 questions
math review
Quiz
•
4th Grade
5 questions
capitalization in sentences
Quiz
•
5th - 8th Grade
10 questions
Juneteenth History and Significance
Interactive video
•
5th - 8th Grade
15 questions
Adding and Subtracting Fractions
Quiz
•
5th Grade
10 questions
R2H Day One Internship Expectation Review Guidelines
Quiz
•
Professional Development
12 questions
Dividing Fractions
Quiz
•
6th Grade
Discover more resources for Computers
25 questions
Spanish preterite verbs (irregular/changed)
Quiz
•
9th - 10th Grade
10 questions
Identify Slope and y-intercept (from equation)
Quiz
•
8th - 9th Grade
10 questions
Juneteenth: History and Significance
Interactive video
•
7th - 12th Grade
8 questions
"Keeping the City of Venice Afloat" - STAAR Bootcamp, Day 1
Quiz
•
9th - 12th Grade
26 questions
June 19th
Quiz
•
4th - 9th Grade
20 questions
Distance, Midpoint, and Slope
Quiz
•
10th Grade
20 questions
Figurative Language Review
Quiz
•
10th Grade
27 questions
STAAR English 1 Review
Quiz
•
9th Grade