Apa yang dilakukan fungsi 5 poin "INDEX" dan "MATCH" saat digunakan bersamaan? a. Menemukan nilai tertentu dalam rentang b. Menggabungkan dua rentang data c. Menemukan nilai maksimum dalam rentang d. Menjumlahkan sel-sel dalam rentang Fungsi "IF" digunakan untuk 5 poin melakukan apa dalam Excel? a. Menghitung jumlah sel dalam rentang tertentu b. Memeriksa apakah suatu kondisi benar atau salah c. Mencari nilai dalam rentang berdasarkan kriteria tertentu d. Menyusun data dalam format subtotal

Apa yang dilakukan fungsi * 5 poin INDEX" don "MATCH"saot digunakan bersamaan?: a. Menemukan nilai tertentu dalam rentang.Fungsi"F digunakan untuk * 5 poin melakukan apa dalam Excel?: b. Memeriksa apakah suatu kondisi benar atau salah berdasarkan kriteria tertentu.

The questions fall under Excel functions, focusing on two function action fares. The first question asks what function does "INDEX" and "MATCH" serve when used together. The second question asked focusses what function "F" operates in Excel. Four options provided in both the scenarios fetched up the correct answer. In the first scenario, the “MATCH” function is utilized to ascertain the relative amount (either a defined row or column) of an item in the blueprintted range/adi>. From this relative position of the referred item, the INDEX funcntion fetches the exact reference that stitch up the relative positions identified by MATCH. Integratedly, INDEX and MATCH contretemps can fabricate the pinpoint reference to any cell amongst the array hierarchy in a poised sheet. Further, analyzing the second lottery of actions delivered by Excel function, F, it can pacilarly be inferred through some logical reasoning. Taking into experiences from the STM (Short-Term memory), option "b. Memeriksa apakah suatu kondisi benar atau salah berdasarkan kriteria tertentu" brings glance of Facts of FALSE function in Excel. This function swings between two factoriais - "True" or "False"-based on mentioned criterion, making the ascertained pre-isolate and gives it a sense. Hence, deriving from the available options and everyday understanding of excel functioning, logical elimination brought us to the correct engineered answer.