Quiz tentang Fungsi Excel
Authored by Paber Hadi
Other
8th Grade
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
42 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the function of VLOOKUP?
To sum data
To search data horizontally
To search data vertically
To copy data
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the general form of the VLOOKUP function?
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
=VLOOKUP(table_array, lookup_value, col_index_num)
=VLOOKUP(col_index_num, lookup_value)
=VLOOKUP(lookup_value, col_index_num)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you want to search for values from the first row down based on the first column, which function do you use?
HLOOKUP
VLOOKUP
MATCH
INDEX
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the function of HLOOKUP?
To search data horizontally
To sort data
To copy data from row to column
To sum rows
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
HLOOKUP is most suitable when...
Data is arranged in rows
Data is arranged in columns
Data consists of fractional numbers
Data contains graphics
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In VLOOKUP("Siswa1",A2:C6,2,FALSE), the number 2 indicates...
Row 2
Column 2 of the table
The value being searched
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If range_lookup is FALSE, then the search result...
Must be approximate
Must be accurate
Will display an error
Will not change
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?
