View : 1526 kali.
Materi Kuliah Pengantar Aplikasi Komputer
11.01 Microsoft Excel - CELL, RANGE, COLUMN WIDTH, ROW HEIGHT, SUM, AVERAGE, MAX, MIN, COUNT
11.01 Microsoft Excel - CELL, RANGE, COLUMN WIDTH, ROW HEIGHT, SUM, AVERAGE, MAX, MIN, COUNT
Berapa jumlah baris dan kolom di MS EXCEL?
Versi Jumlah Baris Jumlah Kolom
Excel 2002/XP 65.536 256
Excel 2000 65.536 256
Excel 97 65.536 256
Excel 95 16.384 256
Excel Pro 2016 jumlah baris = 1,048,576
Kolom : A-Z lalu AA, AB, ... AZ, BA..BZ. CA... CZ, DA.. DZ, EA.. EZ, FA.. FZ, GA... GZ, HA...HZ, IA.. IZ, ... ZA..ZZ, AAA..AAB, ... XFD
Versi Jumlah Baris Jumlah Kolom
Excel 2002/XP 65.536 256
Excel 2000 65.536 256
Excel 97 65.536 256
Excel 95 16.384 256
Excel Pro 2016 jumlah baris = 1,048,576
Kolom : A-Z lalu AA, AB, ... AZ, BA..BZ. CA... CZ, DA.. DZ, EA.. EZ, FA.. FZ, GA... GZ, HA...HZ, IA.. IZ, ... ZA..ZZ, AAA..AAB, ... XFD
Latihan:
NEXT:
11.02 Microsoft Excel - FUNGSI COUNTIF dan SUMIF
PREV: