excel tmbhan
TRANSCRIPT
7/31/2019 Excel Tmbhan
http://slidepdf.com/reader/full/excel-tmbhan 1/10
1) Tukarkan semua data di bawah mengikut format yang dikehendakinya.
harga(RM)tarikh (dd,mm,yyyy)
long date% , 0.00
2563 25 January, 2011 0.66 256423 2
2583 6/26/2011 0.02 256424 23
12 8/6/2011 0.568 256425 3
368 11/13/2011 0.00 256426 5
5698 4/7/2011 2 256427 9
7/31/2019 Excel Tmbhan
http://slidepdf.com/reader/full/excel-tmbhan 2/10
Bil Nama Peserta OO Writer OO Calc OO Impress OO Base Jumlah Purata
1 Abdullah Harun 90 87 79 86
2 Asraf Haris 90 80 60 78
3 Azizah Abdullah 90 78 45 91
4 Chan Kooi Chin 89 71 38 705 Dasuki Hj Ahmad 88 67 90 38
6 Ezina Shuib 75 50 39 88
7 Hayati Yusof 72 32 89 69
8 Izadi Ibrahim 68 32 78 67
9 Jyanthi A/P Manoharan 68 55 78 94
10 Karmila Nordin 37 86 79 80
7/31/2019 Excel Tmbhan
http://slidepdf.com/reader/full/excel-tmbhan 3/10
MASA8-9 9-10 10-11 11-12 12-1 1-2 2-3
ISNIN
SELASA
RABU
BBI 2420
EXPASP 5
(A1)
BT 3 (1B)
KHAMIS
JUMAAT
ASM 0402
EXPASP 5
(DR.MAT
YUSOFF)
ASC 0302
EXPASP 4
(DR. SITI SALWA)
ASM 0402 EXPASP
3 (DR.MAT
YUSOFF)
(DR
ASP 0502
EXPASP 3
(DR. ZAINAL ABIDIN)
ASB 0202
EXPASP 3
(DR.ABD RAHMAN)
BBI 2420
BT 3 (1A)
EXPASP 5 (1B)
(DR ABD
ASA 0102
AMALI
(DR.WAN MOHAMAD)
ASP 0502
AMALI
(P.M. DR. ZAINAL ABIDIN)
ASA
EKP
(DR, WAN
HARI
7/31/2019 Excel Tmbhan
http://slidepdf.com/reader/full/excel-tmbhan 4/10
3-4 4-5
ASC 0302
AMALI
SITI SALWA
ASB 0202
AMALI
AHMAN KURAIS)
102
SP 3
OHAMAD)
7/31/2019 Excel Tmbhan
http://slidepdf.com/reader/full/excel-tmbhan 5/10
1.) Asingkan senarai nama di bawah mengikut kelas
2.) Susun senarai nama mengikut urutan menaik
Bil Nama Kelas
1 Marzuki bin Mat Saad 2A
2 Rafidah Binti Mohd Azzali 2B
3 Kamarul Izuan Bin Jamaludin 2A
4 Fauziah Binti Ashaari 2A5 Luthfi Bin Lokhman 2C
6 Mohammad Wafiq Akif Bin Saifullah 2B
7 Damia Arisya Binti Mohd Zaman 2B
8 Yusliana Binti Yusoff 2C
9 Ridzuan Bin Mohd Zamani 2C
10 Aspalela Binti Asri 2C
11 Baizura Balkis Binti Hussin 2B
12 Tania Ashikin Binti Ahmad Fahmi 2A
13 Mohd Ismi Bin Mohamad Fadli 2A
14 Ismazatul Batisha Binti Abu Bakar 2B15 Sarah Solehah Binti Mohd Azmi 2A
7/31/2019 Excel Tmbhan
http://slidepdf.com/reader/full/excel-tmbhan 6/10
Harga Asal
RM 70% 50% 20%
Beg Tangan Rorine 195
Tali Pinggang Camel 150
Baju Kanak-Kanak KikiLala 99
Kasut Wanita Rorine 220
Kasut Lelaki Rorine 256Cadar Katil King Caster 356
Cadar Katil Queen Caster 289
Cadar Katil Single Caster 188
Potongan Harga= Harga asal-(harga asal * % potongan harga)
Jualan
Mega Sales
Potongan Harga
7/31/2019 Excel Tmbhan
http://slidepdf.com/reader/full/excel-tmbhan 7/10
7/31/2019 Excel Tmbhan
http://slidepdf.com/reader/full/excel-tmbhan 8/10
5
4
8
5
10
103
7/31/2019 Excel Tmbhan
http://slidepdf.com/reader/full/excel-tmbhan 9/10
Belajar Excel 5/29/2012 6:52 PM
Month 2000 2002(XP) 2003
January 9% 9% 65%
February 14% 13% 49%
March 15% 12% 55%April 10% 4% 56%
May 0% 18% 46%
June 2% 13% 54%
July 8% 13% 47%
August 14% 7% 50%
September 9% 7% 52%
October 10% 9% 54%
November 11% 9% 55%
December 8% 8% 49%
Sum
Count
Average
Min
Max
Range
* Range = Max – Min
OFFICE/ EXCEL VERSION
98542290.xlsx.ms_office 9
Latih
7/31/2019 Excel Tmbhan
http://slidepdf.com/reader/full/excel-tmbhan 10/10
Belajar Excel 5/29/2012 6:52 PM
2007
17%
25%
19%31%
36%
30%
32%
29%
32%
28%
26%
35%
98542290 xlsx ms office 10
Latih