Q382-Formatif
Authored by made suardana
Computers
8th Grade
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Fungsi yang digunakan untuk mendapatkan/mencari data dari sekumpulan data adalah
Lookup
Sumifs
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.raw_index_num.[range_lookup])
=Hlookup(Table_Array;Lookup_value;raw_index_num;[range_lookup])
=Hlookup(Lookup_value;raw_index_num;Lookup_value)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A2:H8
B2;H8
A2;H8
B2:H8
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
B3:B8
K4
K5
K6
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
Review rumus excel Kelas 8
Quiz
•
8th Grade
10 questions
O que Sabes? (1º Momento - TIC)
Quiz
•
6th - 8th Grade
10 questions
ANALISA DATA KELAS 8D 2024
Quiz
•
8th Grade
15 questions
ICT - Spreadsheet
Quiz
•
8th Grade
14 questions
Python Data types & Exceptions
Quiz
•
1st - 10th Grade
12 questions
Tabulkový editor - oblasti
Quiz
•
6th - 8th Grade
15 questions
Web Development for Teens
Quiz
•
6th - 8th Grade
15 questions
EXTRA PRACTICE - Coding
Quiz
•
8th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
29 questions
Alg. 1 Section 5.1 Coordinate Plane
Quiz
•
9th Grade
22 questions
fractions
Quiz
•
3rd Grade
11 questions
FOREST Effective communication
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
