VLOOKUP
Authored by Wahyu Estiani
Computers
8th Grade
Used 8+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
8 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
pada rumus vlookup, kepanjangan dari huruf V adalah ....
velcro
ventilasi
vertikal
ventilasi
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Tuliskan range kolom value gambar terebut!
A13:f16
A13;f16
C13;f16
c13:f16
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Pada range tabel acuan, harus dituliskan rumus absolut dengan tanda ...
#
$
@
*
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Untuk memunculkan simbol absolut, perlu menekan tombol
F4
F5
F6
F7
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Tuliskan rumus vlookup GAJI POKOK Kevin pada tabel berikut
=VLOOKUP(C3;$C$14:$F$16;2;0)
=VLOOKUP(C4;$C$14:$F$16;3;0)
=VLOOKUP(C4;$C$14:$F$16;4;0)
=VLOOKUP(C4;$C$14:$F$16;2;0)
6.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Fungsi rumus vlookup adalah ....
menambahkan nilai mata uang
mengatur tanggal
memindahakan data ke suatu tabel lainm
emberi nilai desimal pada exel
7.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Untuk mengeluarkan microsoft excell menggunakan keyboard dengan menekan tombol
alt+f1
alt+f2
alt+f3
ALT+F4
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
Basic Computer Skills
Quiz
•
6th - 8th Grade
10 questions
Mengenal Microsoft Word
Quiz
•
1st - 9th Grade
11 questions
The keyboard and mouse
Quiz
•
4th Grade - Professio...
10 questions
Kuis 1.7 Informatika (Mengenal Enkripsi)
Quiz
•
8th Grade
13 questions
Tech Vocab I
Quiz
•
1st Grade - University
10 questions
Creando Gráficos en Google Sheet(@profejulio)
Quiz
•
4th - 8th Grade
12 questions
Kiểm tra cuối kì 2 Tin 9
Quiz
•
8th Grade
10 questions
Konsep Routing
Quiz
•
1st - 10th Grade
Popular Resources on Wayground
8 questions
2 Step Word Problems
Quiz
•
KG - University
20 questions
Comparing Fractions
Quiz
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Latin Bases claus(clois,clos, clud, clus) and ped
Quiz
•
6th - 8th Grade
22 questions
fractions
Quiz
•
3rd Grade
7 questions
The Story of Books
Quiz
•
6th - 8th Grade
