Teknologi Informasi

  https://docs.google.com/spreadsheets/d/1_hrt1PRFhgTm9Rc7yiAAHFIK9nOzfOkI/edit?usp=sharing&ouid=116505619213182963826&rtpof=true&sd=true Gambar 1 Gambar 2 Gambar 3

  Use VLOOKUP when you need to find things in a table or a range by row. For example,  look up a price of an automotive part by the part number, or find an employee name based on their employee ID . =VLOOKUP( lookup value , range containing the lookup value , the column number in the range containing the return value , approximate match (TRUE) or Exact match (FALSE) ) The VLOOKUP function consists of four required arguments, in the following order: lookup value , table array , column index number   and  exact match .   The lookup value is the value for which you want to find matching data and must appear in the first column of the lookup table; it can be a value, a text string, or a cell reference. VLOOKUP True https://www.educba.com/vlookup-true/ XLOOKUP https://kumparan.com/kabar-harian/fungsi-xlookup-dan-cara-menggunakannya-dalam-mengolah-data-di-microsoft-excel-22kxDtwIMM6/full

Conditional functions  perform calculations on a cell or range of cells only if those cells meet a certain condition . These functions test a given range and determine if the condition is true or false before continuing. Pada  https://brainly.co.id/tugas/46559633  terdapat penjelasan prinsip dasar algoritma Conditions can be any relational comparison, such as:   A3>14 : Whether the value of cell A3 is larger than the number 14 D5<=2 : Whether the value of cell D5 is less than or equal to the number 2 T47=”cheese” : Whether the value of cell T47 is “cheese” The IF function is one type of conditional function that sets a cell to a value if the condition is true, and to another value if the condition is false. IF(logical-test, value-if-true, value-if–false) IF(condition, Yes, No) ==>  IF(cond, Y, N) IF(condition, value_if_true, value_if_false) Where: condition:  value or a logical operation that evaluates to TRUE or FALSE value_if_true:...

Pada topik ini kita akan membahas pemakaian salah satu spreadsheet yaitu Microsoft Excel