Quiz tentang Fungsi Excel

What is the function of VLOOKUP?

• To sum data

• To search data horizontally

• To search data vertically

• To copy data

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)

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

What is the function of HLOOKUP?

• To search data horizontally

• To sort data

• To copy data from row to column

• To sum rows

HLOOKUP is most suitable when...

• Data is arranged in rows

• Data is arranged in columns

• Data consists of fractional numbers

• Data contains graphics

In VLOOKUP("Siswa1",A2:C6,2,FALSE), the number 2 indicates...

• Row 2

• Column 2 of the table

• The value being searched

If range_lookup is FALSE, then the search result...

• Must be approximate

• Must be accurate

• Will display an error

• Will not change

To search for values from rows based on the first row, the function used is...

• VLOOKUP

• HLOOKUP

• SUM

• IF

If no matching value is found in VLOOKUP, the result is...

• 0

• Empty text

• #N/A

• FALSE

To find the value "Mathematics" in a table with rows as subject categories, use the function...

• VLOOKUP

• HLOOKUP

• COUNTIF

• SUM