PERHATIKAN TABEL BERIKUT INI! 7 A B C D 1 DATA KEDATANGAN KARYAWAN PT.INSAN MAKMUR 2 3 No Nama Lengkap Jam Absen Tepat waktu? 4 1 Dwi Monika 07.05 Tepat Waktu 5 2 Novita Arisanti 09.55 Telat 6 3 Ika Sari 14.20 Telat 7 4 Dita Ambarwati 09.15 Telat 8 5 Tri Wulandari 07.45 Tepat Waktu 9 6 Ayu Sari 08.30 Tepat Waktu 10 7 Reni Anggriawan 13.56 Telat 11 8 Dina Wahyu 08.55 Tepat Waktu 12 9 Indah Novia 06.45 Tepat Waktu 13 10 Didik Setiaji 10.20 Telat 14 15 Tepat waktu jika absen sebelum jam 09:00 7 A B C D 1 DATA KEDATANGAN KARYAWAN PT.INSAN MAKMUR 2 3 No Nama Lengkap Jam Absen Tepat waktu? 4 1 Dwi Monika 07.05 Tepat Waktu 5 2 Novita Arisanti 09.55 Telat 6 3 Ika Sari 14.20 Telat 7 4 Dita Ambarwati 09.15 Telat 8 5 Tri Wulandari 07.45 Tepat Waktu 9 6 Ayu Sari 08.30 Tepat Waktu 10 7 Reni Anggriawan 13.56 Telat 11 8 Dina Wahyu 08.55 Tepat Waktu 12 9 Indah Novia 06.45 Tepat Waktu 13 10 Didik Setiaji 10.20 Telat 14 15 Tepat waktu jika absen sebelum jam 09:00 Rumus Fungsi IF kedatangan karyawan yang Bernama Ika Sari adalah ... A. =IF(C3 < TIME(9;0;0); ;Tepat Waktu";"Telat") B. =IF(C6 < TIME(9;0;0); "Tepat Waktu";"Telat") C. =IF( C4<TIME (9;0;0); "Tepat Waktu";"Telat") D.= IF(C6<TIME(9:0:0):"Tenat Waktu:"Telat")

B

The question asks to determine the correct Excel formula for determining if Ika Sari was on time or late. The formula uses the IF function, which has the general format =IF(condition, value_if_true, value_if_false). In this context, the condition is whether the time of arrival (mentioned in column C) is before 09:00. The employee is considered "Tepat Waktu" (on time) if they arrive before 09:00, and "Telat" (late) if they arrive at or after 09:00.- Option A uses "C3", which refers to the cell that might contain the time for a different employee, not Ika Sari.- Option B uses "C6", which is the correct cell for Ika Sari according to the table. The formula format is correct with a semicolon separating the arguments of the IF function and the TIME function correctly set up to compare the time.- Option C, like option A, refers to the wrong cell (C4).- Option D is incorrectly formatted and not a valid Excel formula syntax.Therefore, the correct formula is the one that refers to the correct cell (C6 for Ika Sari) and uses the IF and TIME functions correctly to determine if the arrival time is before 09:00.