Spreadsheets

Informasi Umum dan Penggunaan Antar Muka Pengguna

Selamat datang di Bantuan %PRODUCTNAME Calc
Fitur %PRODUCTNAME Calc
Shortcut Keys (%PRODUCTNAME Calc Accessibility)
Tombol Pintas untuk Pengolah Angka
Kode Kesalahan dalam %PRODUCTNAME Calc
Tambahan bagi Pemrograman %PRODUCTNAME Calc
Instruksi dalam Menggunakan %PRODUCTNAME Calc

Rujukan Menu dan Perintah

Menu

Menu
Berkas
Sunting
Tampilan
Sisip
Format
Perkakas
Jendela
Data
Bantuan

Bilah alat

Baris Alat
Baris Pemformatan
Baris Properti Objek Menggambar
Baris Pemformatan Teks
Baris Rumus
Baris Status
Baris Pratinjau Halaman
Baris Gambar
Baris Perkakas
Baris Standar
Bilah Data Tabel
Baris Navigasi Formulir
Baris Desain Kuiri
Bilah Alat Desain Formulir

Functions Types and Operators

Panduan Fungsi
Fungsi oleh Kategori
Fungsi Susunan
Bit Operation Functions
Fungsi Basis Data
Fungsi Tanggal & Waktu
Fungsi Finansial Bagian Satu
Fungsi Finansial Bagian Dua
Fungsi Finansial Bagian Tiga
Fungsi Informasi
Fungsi Logika
Fungsi Matematika
Fungsi Statistik
Fungsi Statistika Bagian Satu
Fungsi Statistika Bagian Dua
Fungsi Statistika Bagian Tiga
Fungsi Statistika Bagian Empat
Fungsi Statistika Bagian Lima
Fungsi Pengolah Angka
Fungsi Teks
Fungsi Tambahan
Add-in Functions, List of Analysis Functions Part One
Add-in Functions, List of Analysis Functions Part Two
Operator di %PRODUCTNAME Calc
User-Defined Functions

Memuat, Menyimpan, Mengimpor, dan Mengekspor

Inserting External Data in Table (WebQuery)
Menyimpan dan Membuka Lembar Kerja dalam HTML
Importing and Exporting Text Files

Memformat

Rotating Text
Writing Multi-line Text
Formatting Numbers as Text
Text Superscript / Subscript
Changing Row Height or Column Width
Applying Conditional Formatting
Highlighting Negative Numbers
Assigning Formats by Formula
Entering a Number with Leading Zeros
Formatting Spreadsheets
Formatting Numbers With Decimals
Menamai Sel
Rotating Tables (Transposing)
Renaming Sheets
19xx/20xx Years
Using Rounded Off Numbers
Cells in Currency Format
Menggunakan Format Otomatis pada Tabel
Inserting and Editing Comments
Selecting Themes for Sheets
Entering Fractions

Filtering and Sorting

Applying Filters
Filter: Applying Advanced Filters
Menerapkan Saring Otomatis
Applying Sort Lists

Mencetak

Printing Rows or Columns on Every Page
Printing Sheets in Landscape Format
Printing Sheet Details
Defining Number of Pages for Printing

Data Ranges

Defining Database Ranges
Filtering Cell Ranges
Sorting Data

Pivot Table

Pivot Table
Creating Pivot Tables
Deleting Pivot Tables
Editing Pivot Tables
Filtering Pivot Tables
Selecting Pivot Table Output Ranges
Updating Pivot Tables

Scenarios

Using Scenarios

References

Addresses and References, Absolute and Relative
Referencing a Cell in Another Document
References to Other Sheets and Referencing URLs
Referencing Cells by Drag-and-Drop
Recognizing Names as Addressing

Viewing, Selecting, Copying

Changing Table Views
Displaying Formulas or Values
Freezing Rows or Columns as Headers
Navigating Through Sheets Tabs
Menerapkan Banyak Operasi
Only Copy Visible Cells
Memilih Banyak Sel

Formulas and Calculations

Calculating With Formulas
Copying Formulas
Entering Formulas
Displaying Formulas or Values
Kalkulasi dalam Pengolah Angka
Calculating With Dates and Times
Automatically Calculating Series
Menghitung Perbedaan Waktu
Entering Matrix Formulas

Protection

Melindungi Sel dari Perubahan
Mencabut Proteksi terhadap Sel

Miscellaneous

Deactivating Automatic Changes
Consolidating Data
Applying Goal Seek
Menerapkan Banyak Operasi
Menerapkan Banyak Operasi
Validity of Cell Contents