Latihan soal SAT 2024

Quiz
•
Computers
•
8th Grade
•
Hard
made suardana
FREE Resource
11 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fungsi yang digunakan untuk mendapatkan/mencari data dari sekumpulan data adalah …
Lookup
Sumif
Average
Max
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika range data yang akan dicari disusun secara vertikal, maka fungsi yang digunakan adalah …
Lookup
Vlookup
Hlookup
Match
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jika range data yang akan dicari disusun secara horisontal, maka fungsi yang digunakan adalah …
Lookup
Vlookup
Hlookup
Match
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berikut penulisan fungsi Vlookup yang benar adalah …
=Vlookup(Lookup_value,Table_Array,Col_index_num,[range_lookup])
=Vlookup(Lookup_value.Table_Array.Col_index_num.[range_lookup])
=Vlookup(Table_Array;Lookup_value;Col_index_num;[range_lookup])
=Vlookup(Lookup_value;Col_index_num;Lookup_value)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Berikut penulisan fungsi Hlookup yang benar adalah …
=Hlookup(Lookup_value,Table_Array,Raw_index_num,[range_lookup])
=Hlookup(Lookup_value.Table_Array.Col_index_num.[range_lookup])
=Hlookup(Table_Array;Lookup_value;Raw_index_num;[range_lookup])
=Hlookup(Lookup_value;Col_index_num;Lookup_value)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Perhatikan data pada lembar kerja,
Range data dari tabel tersebut adalah …
A2:H8
B2;H8
A2;H8
B2:H8
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk mendapatkan data nama berdasarkan nomor absen yang di inputkan, maka nomer absen yang akan kita cari datanya diketikan pada cell ….
B3:B8
K4
K5
K6
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
Pencarian Data - Unit Analisis Data

Quiz
•
8th Grade
7 questions
BAB VI - A. Pencarian Data - KLS VIII - SMT II

Quiz
•
8th Grade
15 questions
Pencarian Data dengan Excel

Quiz
•
8th Grade
9 questions
Kuis Fungsi Lookup Excel

Quiz
•
8th Grade
10 questions
Uji Pemahaman Fungsi VLOOKUP dan HLOOKUP

Quiz
•
8th Grade
9 questions
Rumus

Quiz
•
8th Grade
10 questions
Formatif Infomatika 8 - Analisa Data

Quiz
•
8th Grade
10 questions
Quiz 1 Fungsi VLOOKUP dan HLOOKUP

Quiz
•
8th Grade
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
10 questions
UPDATED FOREST Kindness 9-22

Lesson
•
9th - 12th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
20 questions
US Constitution Quiz

Quiz
•
11th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
18 questions
Company Logos

Quiz
•
6th - 8th Grade
10 questions
Exploring Cybersecurity Techniques and Threats

Interactive video
•
6th - 10th Grade
10 questions
Understanding the Internet and Data Transmission

Interactive video
•
7th - 12th Grade
25 questions
How to Email a Teacher- https://youtu.be/NioeNhfpVfI

Quiz
•
6th - 8th Grade
20 questions
Computer Hardware

Quiz
•
6th - 8th Grade
21 questions
Gear Ratio Practice

Quiz
•
6th - 8th Grade