WorksheetsComputerization of Accounting (Spreadsheet)
Total questions: 20
Worksheet time: 3mins
Rata-rata
SUM
MAX
MIN
AVERAGE
Rumus Statistik
SUM
MAX
IF
AVERAGE
Rumus Matematika
SUM
MAX
IF
AVERAGE
Program Pengolah Angka
Microsoft Word
Microsoft Access
Microsoft PowerPoint
Microsoft Excel
Microsoft Publisher
Nilai Terendah
MAX
MIN
SUM
IF
=3*3
9
6
1
0
=10/2
8
5
2
12
=2^3
5
6
8
9
Menjumlahkan data dengan kriteria tertentu
SUM
SUMIF
IF
COUNTIF
=3+5*2
16
8
10
13
=5-3-2
1
2
3
0
Menyisipkan Grafik
Insert Picture
Insert Table
Insert Chart
Insert Graph
Menghapus Tabel
Insert Table
Delete Table
Merge Table
Split Table
Grafik Batang
Line Chart
Bar Chart
Pie Chart
Scatter Plot
Grafik Lingkaran
Pie Chart
Line Chart
Bar Chart
Scatter Plot
=(12/2)-5
1
2
5
6
Menghapus Tabel
Split Table
Insert Table
Delete Table
Merger Table
Rumus untuk menghitung nilai terkecil data
SUM
MAX
MIN
AVERAGE
Teman Upin Ipin yang Pandai Berdagang
Ihsan
Fizi
Jarjit
=5+3-4-4
0
1
2
3
