📑 Cheatsheet & Ringkasan Rumus Cepat
Kompilasi ringkas rumus Excel, tabel subnetting IP, warna kabel UTP, shortcut Microsoft Word, sintaks Dart, dan aturan grammar bahasa Inggris siap cetak.
🖧 TJKT: Tabel Subnetting IPv4 (/24 - /30)
| Prefix | Subnet Mask | Total IP | Host Valid |
|---|---|---|---|
| /24 | 255.255.255.0 | 256 | 254 host |
| /25 | 255.255.255.128 | 128 | 126 host |
| /26 | 255.255.255.192 | 64 | 62 host |
| /27 | 255.255.255.224 | 32 | 30 host |
| /28 | 255.255.255.240 | 16 | 14 host |
| /29 | 255.255.255.248 | 8 | 6 host |
| /30 | 255.255.255.252 | 4 | 2 host (PtP) |
🔌 TJKT: Pinout Kabel UTP RJ-45
Standar T568B (Straight-Through):
- Putih Oranye (Tx+)
- Oranye (Tx-)
- Putih Hijau (Rx+)
- Biru
- Putih Biru
- Hijau (Rx-)
- Putih Cokelat
- Cokelat
Straight: Ujung A T568B - Ujung B T568B (Router ke PC)
📈 Excel: 10 Fungsi Paling Penting
=SUM(A1:A10) --> Total nilai =AVERAGE(B1:B10) --> Rata-rata =IF(C2>=75, "LULUS", "REMEDI") =VLOOKUP(D2, $A$2:$F$50, 3, FALSE) =IFERROR(VLOOKUP(...), "Tidak Ada") =COUNTIF(E2:E30, "Hadir") =DATEDIF(F2, TODAY(), "Y") --> Umur📄 Word: Pintasan Keyboard Utama
Ctrl + B / I / U --> Bold / Italic / Underline Ctrl + L / E / R / J --> Left / Center / Right / Justify Ctrl + 1 / 2 / 5 --> Spasi 1.0 / 2.0 / 1.5 Ctrl + Enter --> Page Break Halaman Baru Ctrl + Shift + C / V --> Copy / Paste Format Ctrl + H --> Find and Replace Teks💻 Simkomdig: Operator Google Search
site:sch.id "jadwal ujian" filetype:pdf "silabus tjkt" "kata persis" -kata_dikecualikan intitle:"laporan k3lh" define:komputasional⚡ DART: Sintaks Esensial
void main() { print("Hello!"); } String? nama; // Null Safety List🌐 B. Inggris: Simple Present vs Past
Present Tense (Habit & Fact):
(+) S + V1 (-s/-es) | (-) S + do/does not + V1Past Tense (Recount / Past Event):
(+) S + V2 | (-) S + did not + V1