Aina Book Store ( Documentation)

Transcript

 PR  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] DOCUMENTATION  NAME : MUHAMMAD ASYRAF ASYRAF BIN NORAHAIRUZAN POSITION : CHIEF EXECUTIVE OFFICER  COMPANY NAME : AINA BOOK STORE COMPANY COMPANY ADDRESS ADDRESS : NO 2323 , JALAN ISMAIL NAGORE , GEORGE TOWN , 11!! , PULAU PINANG CONTACT NUMBER : !11"1#2$1#! FAX FAX NUMBER : !3"#$%&'! EMAIL : SALAPIAHNORDIN(GMAIL)CO SA LAPIAHNORDIN(GMAIL)COM M AICT003-4-1-PITS 1  PR  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] ACKNOWLEDGMENT T*+-. /0 G0 , + 4+5.6 76 /0 A+* SWT , T*6 L04 08 /*6 9564.6 , ;*0 *+. <56 =6  76685>6/ + <00 *6+/* .0 /*+/ I +76 /0 855.* /*5. +..5<=6/ ) P6+>6 + S++= +46 +;+?.  76..6 + 0946 0; 90 094 7606 P40*6/ M9*+==+ SAW +. /*6 +./ P40*6/ ) T*5. +..5<=6/ +46 0/ >0=6/6 ;5/*09/ .0=6 .904/ 804 =+? 606 ) I ;09 5-6 /0 08864 =? <46+/6./ +46>5+/50 /0 =? 6>/9464 804 /*6 P4+>/5>+ IT .-5. @PITS , MISS AKANSHA MANDHANA MANDHANA 804 *64 65>+/50 0 /6+>*5< =6 /*6.6 40<4+=. I += 9.5< 804 /*6 >0=+? ) I ;+/ /0 646.. =? 646..6 <4+/5/96 /0 =? 6>/9464 804 /*6 <95+>6 , >0446>/50 , <46+/ +//6/50 + +/56>6 , ;*5>* 85+? 6+76 =6 /0 855.* =? +..5<=6/ ) Y09 Y09 *+6 +? + ? .5>646./ <4+/5/96 )  N6/ , /*6 75<<6./ /*+-. 804 =? 7606 +46/. , MOHAMAD NORDIN BIN ISMAIL ISMAIL + SALAPIAH BINTI ISMAIL ) I /*+- =? +46/. 804 /*654 >0./+/ .904/ + 6>094+<6=6/ ;5/*09/ ;*0= 5/ ;+. 5=0..576 804 =6 /0 >0=6/6 =? +..5<=6/ ) F5+? , I += /*+-89 /0 =? 860; 8456. ;*0 *66 =6 ;5/* /*6 6/+5. 804 /*5. 0>9=6/+/50 ) W5/*09/ /*6= , /*5. <956 ;5 0/ 76>0=6 >0=6/6 + 6+.564 804 /*6 0/*64. /0 46864 ;5/* ) T*654 6>094+<6=6/ .904/6 =6 + /5=6 +0< ) TABLE OF CONTENTS AICT003-4-1-PITS 2  PR  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] ACKNOWLEDGMENT T*+-. /0 G0 , + 4+5.6 76 /0 A+* SWT , T*6 L04 08 /*6 9564.6 , ;*0 *+. <56 =6  76685>6/ + <00 *6+/* .0 /*+/ I +76 /0 855.* /*5. +..5<=6/ ) P6+>6 + S++= +46 +;+?.  76..6 + 0946 0; 90 094 7606 P40*6/ M9*+==+ SAW +. /*6 +./ P40*6/ ) T*5. +..5<=6/ +46 0/ >0=6/6 ;5/*09/ .0=6 .904/ 804 =+? 606 ) I ;09 5-6 /0 08864 =? <46+/6./ +46>5+/50 /0 =? 6>/9464 804 /*6 P4+>/5>+ IT .-5. @PITS , MISS AKANSHA MANDHANA MANDHANA 804 *64 65>+/50 0 /6+>*5< =6 /*6.6 40<4+=. I += 9.5< 804 /*6 >0=+? ) I ;+/ /0 646.. =? 646..6 <4+/5/96 /0 =? 6>/9464 804 /*6 <95+>6 , >0446>/50 , <46+/ +//6/50 + +/56>6 , ;*5>* 85+? 6+76 =6 /0 855.* =? +..5<=6/ ) Y09 Y09 *+6 +? + ? .5>646./ <4+/5/96 )  N6/ , /*6 75<<6./ /*+-. 804 =? 7606 +46/. , MOHAMAD NORDIN BIN ISMAIL ISMAIL + SALAPIAH BINTI ISMAIL ) I /*+- =? +46/. 804 /*654 >0./+/ .904/ + 6>094+<6=6/ ;5/*09/ ;*0= 5/ ;+. 5=0..576 804 =6 /0 >0=6/6 =? +..5<=6/ ) F5+? , I += /*+-89 /0 =? 860; 8456. ;*0 *66 =6 ;5/* /*6 6/+5. 804 /*5. 0>9=6/+/50 ) W5/*09/ /*6= , /*5. <956 ;5 0/ 76>0=6 >0=6/6 + 6+.564 804 /*6 0/*64. /0 46864 ;5/* ) T*654 6>094+<6=6/ .904/6 =6 + /5=6 +0< ) TABLE OF CONTENTS AICT003-4-1-PITS 2  PR  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] ACKNOWLEDGMENTS ))2 TABLE TABLE OF CONTENTS CONTENT S  3 3 " # ABSTRACT $ INTRODUCTION   ))% ))% "  BODY CONTENT :    WALKTHROUGH )) 5) MAIN MAIN PAGE        & & " ' 55) 55) INVE INVENT NTOR ORY Y        ))) )))1! 1! " 11 11 555) 555) SALE SALES S         ) ))1 )12 2 5) 5) EMPL EMPLOY OYEE EE         )1 )13 3 " 1# ) ANAL ANALY YSIS SIS        ) ))1 )1$ $ 5) 5) CHAR CHART T         ) )1% 1% FUNCTION AND FORMULAE    5) LINK LINKIN ING G         )) ))1 1 " 1' 1' 55) 55) PASSWOR SSWORD D        ) )2! 2! " 22 555) 555) SUM SUM          ) ))2 )23 3 5) 5) SUBT SUBTRA RACT CTIO ION N       ) ))) ))2# 2# ) MUL MULTIPLI IPLICA CAT TION ION       ) )2$ 2$ ABSOLUTE REFERENCE  )2% )2% AICT003-4-1-PITS 3  PR  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL]  CONDITIONAL CONDITIO NAL FORMATTING  2 2 " 31  DATA DATA VALIDAT VALIDATION ION  ))32 ))32 " 3$ 3$  CHART  ) )3% 3% " 3&  MAIL MERGE MERGE   ))3' ))3' " #% CONCLUSIONS # REFERENCES LIST   )#& )#& APPENDICES   #' #' " $1 ABSTRACT T*5. 0>9=6/+/50 5. =+5? +709/ /*6 <95656. 804 46+45< /*6 .46+.*66/ + 6//64"5-6 4604/ 804 AINA AINA BOOK STORE ) T*5. 5. /0 5=6=6/ /*6 +5>+/50 08 M5>40.08/ AICT003-4-1-PITS 4  PR  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] O885>6 E>6 + M5>40.08/ O885>6 W04 W04 5/0 /*6 =+5/6+>6 08 /*6 >0=+?. 064+/50 ) T*6 +5= 08 /*5. <956 5. /0 4056 + =046 6/+56 /9/045+ 804 /*6 64.0 /0 +? /*6 M5>40.08/ O885>6 E>6 5 46+45< /*6 .46+.*66/ , + +? + ? M5>40.08/ O885>6 W04 W04 804 ;45/5< /*6 4604/ /0 /*6 0/*64 6=0?66. ) T*5. 0>9=6/+/50 >0.5./. 08 /*6 ./6. 0 >46+/5< .46+.*66/. 804 E>6 ;*5>* 5>96. /*6 +.6>/. 08 56/0456. , .+6. , 6=0?66. , ++?.5. + >*+4/ ) T*6 +5>+/50 08 W04 W04 , 0 /*6 0/*64 *+ , 80>9.6. 0 /*6 =+./64? 08 /*6 89>/50 08 M+5 M64<6 5 >46+/5< 6//64"5-6 4604/. /0 =9/56 6=0?66. 6=0?66. 7? >46+/5< + 6; +/+7+.6 804 /*6 6/+5. ) T*5. <95656 6+76. /*6 9.64 /0 >46+/6 /*6 .46+.*66/ 5+ E>6 + /*6 4604/ 5+ W04 W04 5 .5=64 +40+>* + .*04/64 /5=6 ) M? >0=+? +=6.  +=6. AINA BOOK STORE ) T*5. >0=+? 5. +.0 >0=+? *+. *+ . =5..50 + 5.50 08 /*654 0; ) T*6 =5..50 + 5.50 08 =? >0=+? 5. /0 *6 ./96/. 5 +? ./++4 + *5<*64 .>*00 /0 79? 79 ? ./+/50+4? + 700- 804 /*654 ./9? + 0 /*6 ;04- ) T*5. >0=+? +.0 *6 /*6= ;*6 ;04-64 ;*0 +46 9.6 /*6 ./+/50+4? 5-6 /6+>*64 , 0885>64 + /*6 0/*64. ) B6.56. /*+/ , /*5. ./96/. ;*0 +46 ./9?5< +/ 9564.5/? +.0 ;5 9.6 /*6 ./+/50+4? /0 0 /*654 ;04- + 79? /*6 700- /0 0 /*654 465.50 04 79? 5/ 804 /*654 6+=5+/50 ) B? 9.5< 5/646/ /*6 +9/*04 >+ <6/ + 0/ 08 5804=+/50 +709/ /*6 ./+/50+4? +. /*6 /?6 08 =+/645+ /*+/ +46 9.6 5. .+86 04 0/ , >0=804/ + .95/+76 804 >*546 04 + +<6 /0 9.6 5/ ) F94/*64=046 , 5.>9..50 ;5/* /*6 0/*64 606 >+ *6 9. /0 5=406 094 -0;6<6 +709/ *0; /0 0 /*6 >+>9+/50 08  4085/ + 0.. 08 .+6. 5 >0=+? ) W*6 >+>9+/50 >+>9+/50 ;6 66 /0 9.6 804=9+. /0 =+-6 5/ 6+.5? + .?./6=+/5>+? ) T*5. ;5 =+-6 /*6 064+/50 08 /*6 AINA BOOK STORE +46 6+.564 + =046 04<+56 5 /*6 89/946 ) INTRODUCTION AICT003-4-1-PITS 5  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] FIGURE 1 : LOGO AINA BOOK STORE AINA BOOK STORE 5. + >0=+? ;*5>* .0 /*466 74+. .9>* +. STABILO , FABER CASTELL + PAPER MATE ) F04 6+>* 74+ 08 =? >0=+? *+. 65<*/ 409>/ ) F04 74+ 08 STABILO /*5. >0=+? .0 5/6= .9>* 9. *5<*5<*/64 , 89.50 7+ 6 , ./+= + , >0446>/50  6 + /*6 0/*64 /*5<. ) T*5. 409>/ 5. 64? .95/+76 804 ./96/ /0 9.6 5 >+.. + /0 0 *0=6;04- ) B6.56. /*+/ , 804 >*546 +.0 .95/+76 76>+9.6 /*5. 409>/ =+-6 840= =+/645+ ;5/* 0"/05> ) F04 74+ 08 FABER CASTELL /*5. >0=+? .0 5/6= .9>* 9. 7+>- =+//  6>5 , +4/ 56 5- , <60=6/4? 70 ,<96 + /*6 0/*64 /*5<. ) T*6 +./ 74+ 5. PAPER MATE /*5. >0=+? .0 5/6= .9>* 9. 4964 , 64+.64 , =6>*+5>+ 6>5 , ./+64 + /*6 0/*64 /*5<.) A /*5. =+-6 840= <00 =+/645+ , .+86/? ;*6 9.6 5/ 76>+9.6 5/ =+-6 840= /*6 =+/645+ 0" /05> , 5/ 5. +.0 >0=804/ + =+-6 /*6= 866 0 7046 ;*56 ./9? ) T*6 ./+/50+4? *+6 .0 + +456/? 08 >004. , /0 +//4+>/ /*6 606 ) T*5. >0=+? *+. 856 ;5/* +. .6>5+ =6+5<) E.6>5+? /*6 0<0 *+ >0=756) A/ /*6 0<0 *+6 + 5=+<6 08 >+4/0 /*+/ *05< + 700- , /*6 +5= 5. /0 +//4+>/ /*6 606 /0 79? 5/ ) T*+/ 6+.? /0 + 606 804 79? /*6 /*5<. /*6? ;+/ ) T*6 940.6 08 /*5. 0>9=6/+/50 5. /0 +? /*6 89>/50. 08 /;0 +5>+/50. 08 M5>40.08/ O885>6  E>6 + W04 5/0 /*6 46+4+/50 08 /*6 .46+.*66/ + 4604/ 46.6>/56? 804 /*6 .=00/*64 064+/50 08 AINA BOOK STORE ) T*6 <95656 5. =046 80>9.6 0 6; 9.64. 08 /*6.6 +5>+/50. 5 /*6 >0=+? .0 /*6 6; 6=0?66 >+ +0/ /0 /*6 ;04-5< 6540=6/ 6+.5? +8/64 /*6? =+./64 /*6 .-5. 469546 /0 6.946 /*6 >0=+? 49. .=00/*? ) AICT003-4-1-PITS 6  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] T*5. 0>9=6/+/50 >064. /*6 +5>+/50 08 M5>40.08/ O885>6 E>6 804 /*6 .46+.*66/ 854./ ) T*5. 5>96. 5/409>5< /*6 89>/50. 08 .0=6 7+.5> 804=9+. .9>* 9. +5/50 , .97/4+>/50. + =9/55>+/50. , /*6 +5>+/50 08 +7.09/6 + =56 468646>5< 5+ /*6 .*04/>9/ 79//0. , /*6 9.+<6 08 >05/50+ 804=+//5< 5 .0=6 >6. , +..;04. + /*6 5=04/+>6 08 +/+ +5+/50 804 >64/+5 +/+ ) I 0464 /0 =+-6 /*6 .46+.*66/ 00- =046 04<+56 + 6+/ , /*6 <664+ ./6. 0 >46+/5< >*+4/. +46 5>0404+/6 5/0 /*5. 0>9=6/+/50 ) A. 804 /*6 M5>40.08/ O885>6 W04 , 5/. +5>+/50 >0>6/4+/6. =046 0 /*6 89>/50. 08 M+5 M64<6 804 /*6 6//64 ./?6 ) F40= /*+/ , /*6 46+64. ;5 76 60.6 /0 /*6 =+5 =64<6 89>/50 .0 /*6 9.64. ;5 76 =046 ++/6 /0 /*6 9.+<6 804 /*6 89>/50 ) T*6 ./6. 5>96 /*6 >46+/50 08 /*6 5./ /0 76 5=6=6/6 5/0 >64/+5 +4/. 08 /*6 6//64 , 964./+5< /*6 89>/50 08 =+/>*5< 856. + /*6 06456; 08 /*6 804=+/ 804 /*6 6//64  5-6 4604/ 804 /*6 AINA BOOK  STORE 6=0?66. ) T*5. 0>9=6/+/50 ;5 +..5./ /*6 AINA BOOK STORE 6=0?66. 5 5/. 064+/50 .0 /*6 >0=+? ;5 49. .=00/*? + =+-6. /*6 > 0=+? =046 6+.564 + 04<+56 804 /*6 76//64 660=6/ 5 /*6 89/946 ) BODY CONTENTS WALKTHOUGH  MAIN PAGE AICT003-4-1-PITS 7  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] FIGURE 2 : MAIN PAGE AINA BOOK STORE FIGURE 2)! .*0;. /*6 06456; 08 /*6 M+5 P+<6 ;5/* *?645-. 5 /*6 .46+.*66/ ) OVERVIEW  C0=+? LOGO  C0=+?. +=6  C0=+? 6/+5. @ .9>* 9. ADDRESS , CONTACT NUMBER , EMAIL   H?645-. HYPERLINKS 1 INVENTORY : T0 56/0456. .*66/ AICT003-4-1-PITS 8  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] 2 SALES : T0 .+6. .*66/ 3 SALARY : T0 6=0?66. .++4? .*66/ # ANALYSIS : T0 ++?.5. .*66/ $ CHART : T0 >*+4/ .*66/   M+5 +<6 5. >0.5./. 08 % 79//0. .9>* +. 56/04? , .+6. , 6=0?66 ,++?.5. + >*+4/. ;5/* *?645- 5/0 /*6 >64/+5 .*66/ /0 =+-6. 5/ 6+.5? /0 .66 +? .*66/ ) I /*6  79//0 *+6 588646/ >0=+?. 5804=+/50 5 /*6 .*66/ ) T*5. .*66/ +.0 >0/+5. 7+>- , 6/ + *0=6 79//0 /0 =+-6. 6+.5? =06. + 7+>- /0 +0/*64 .*66/ ) T*6 +9/*04 +.0 >*00.6 /*6 76+4 7+>-<409 /0 +//4+>/ /*6 606 6.6>5+? -5. /0 79? /*6 ./+/50+4? +/ /*6 700- ./046 ) INVENTORY AICT003-4-1-PITS 9  PRACTICAL IT SKILLS  [ASSIGNMENT INDIVIDUAL] T*6 56/04? .*66/ 5. /0 .*0; + 5804=+/50 08 /*6 .+6. .*66/ ) T*5. .*66/ >0.5./. 08 /*6 P409>/ I , I/6= D6.>45/50 , N9=764 B09<*/ , I5/5+ C0./ , T0/+ C0./ , S65< P45>6 , N9=764 O8 E+>* I/6= S0 , N9=764 I/6= I S/0>- + T0/+ S+6. ) I /*5. .*66/ +.0 >0.5./. 08 6/ , 7+>- +440; + *0=6 79//0 ) I/ +.0 9.6 +? 804=9+. /0 =+-6. 5/ 6+.5? + +9/0=+/5>+? >+>9+/6 ;5/* +? =5./+-6 ) AICT003-4-1-PITS 1 0  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] FORMULAS THAT HAVE AT THE INVENTORY SHEET : 1 TOTAL COST  N9=764 B09<*/  I5/5+ C0./ 2 SELLING PRICE  I5/5+ C0./  1#! 3 NUMBER ITEM IN STOCK  N9=764 B09<*/  N9=764 O8 E+>* I/6= S0 # TOTAL SALES  S65< P45>6  N9=764 O8 E+>* I/6= S0  SALES AICT003-4-1-PITS 1 1  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL]  T*5. .*66/ 5. /65< +709/ /*6 .+6. 08 /*6 >0=+? ) T*6 5/6= .0 +46 9+/6 *646 ) T*5. .*66/ +.0 >0.5./. P409>/ I , I/6= D6.>45/50 , N9=764 B09<*/ , I5/5+ C0./ , T0/+ C0./ , S65< P45>6 , N9=764 O8 E+>* I/6= S0 , N9=764 I/6= I S/0>- + T0/+ S+6. ) T*5. .*66/ +46 .+=6 ;5/* /*6 56/04? .*66/ ) T*6 804=9+. +/ /*6 .+6. .*66/ +46 +.0 .+=6 ) T*5. .*66/ +.0 *+6 /*6 40/6>/ .*66/ 76>+9.6 ;*6 /*6 0/*64 606 ;+/ /0 >*+<6. /*6? *+6 /0 6/64 /*6 +..;04 854./ )  EMPLOYEES SALARY AICT003-4-1-PITS 1 2  PRACTICAL IT SKILLS  [ASSIGNMENT INDIVIDUAL] T*5. 6=0?66 .*66/ >0.5./. /*6 S/+88 I , S/+88 N+=6 , S/+88 S++4? P64 M0/* , B4+ , S0 I/6= , S/+88 C0==5..50 , C0==5..50 V+96 , T0/+ S++4? , S/+88 P64804=+>6 + T0/+ S+6. ) T*5. .*66/ /6 9. +709/ /*654 64804=+>6 + .++4? +/ /*6 >0=+? ) T*5. .*66/ +.0 *+6 .0=6 804=9+. ) I/ 5. 6+.5? + +9/0=+/5>+? /0 >+>9+/6 /*6 6=0?66 >0==5..50 + .++4? ) FORMULAS THAT HAVE AT THE EMPLOYEE SHEET : AICT003-4-1-PITS 1 3  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] 1 STAFFS COMMISSION  I8 /*6 /+4<6/ .+6. 46696 5. 6.. /*+ RM1$!! , /*6 >0==5..50 5. $840= /*6 .65<  45>6 08 /*6 5/6= .0 )  I8 /*6 /+4<6/ .+6. 46696 5. 69+ /0 04 <46+/64 /*+ RM1$!! , /*6 5/6=. .0 +8/64 /*+/ ;5 76 >09/6 ;5/* + >0==5..50 08 1$ 840= /*6 .65< 45>6 ) 2 STAFFS PERFORMANCE :  I8 /*6 /+4<6/ .+6. 46696 5. 69+ /0 04 <46+/64 /*+ RM1$!! , /*6 64804=+>6 5. GOOD )  I8 /*6 /+4<6/ .+6. 46696 5. 6.. /*+ RM1$!! 79/ <46+/64 /*+ RM1!!! , /*6 64804=+>6 5. ABOVE AVERAGE )  I8 /*6 /+4<6/ .+6. 46696 5. 6.. /*+ RM1!!! 79/ <46+/64 /*+ RM$!! , /*6 64804=+>6 5. SATISFACTORY )  I8 /*6 /+4<6/ .+6. 46696 5. 6.. /*+ RM$!! , /*6 64804=+>6 5. BELOW AVERAGE 3 COMMISSION VALUE  S0 I/6=  S/+88 C0==5..50 # TOTAL SALES  S/+88 S++4? P64 M0/*  C0==5..50 V+96 $ TOTAL SALES  S65< P45>6  N9=764 O8 E+>* I/6= S0  ANALYSIS AICT003-4-1-PITS 1 4  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL]  T*6 ++?.5. .*66/ >0.5./. /*6 S+6. R6696 , T0/+ C0./ , A=09/ , T0/+ S++4? + E=0?66 P64804=+>6 )  CHART AICT003-4-1-PITS 1 5  PRACTICAL IT SKILLS  [ASSIGNMENT INDIVIDUAL] T*6 >*+4/ .*66/ .*0;. /*6 >*+4/ 6.5< 7+.6 0 /*6 5804=+/50 +/ /*6 ++?.5. .*66/ ) FUNCTIONS AND FOMULAE AICT003-4-1-PITS 1 6  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] LINKING  L5-5< ;04-.*66/ 5. + 804=9+ /*+/ ?+=5>+? 9. 5 +/+ 840= + >6 5 +0/*64 ;04-.*66/ ) T*6 6./5+/50 ;04-.*66/ >0/+5. /*6 5- 804=9+ + 5/ 46>656 +/+ 840= + >6 5 /*6 .094>6 ;04-.*66/ ) A?/5=6 /*6 >6 +96 5 /*6 .094>6 ;04-.*66/ >*+<6. , /*6 >6 >0/+55< /*6 5- 804=9+ ;5 76 9+/6 +. ;6 +. /*6 6/ /5=6 5/ 5. 066 ) I /*5. .46+.*66/ , /*646 +46 86; 5-5< ;04-.*66/ +56 ) HOW TO CREATE THE LINKING : STEP 1 : .66>/ /+76 /*+/ ?09 ;+/ /0 5-5< ) STEP 2 : 46.. /*+/ .?=70.  , @EUAL ) AICT003-4-1-PITS 1 7  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] STEP 3 : <0 /0 .+6. .*66/ ) STEP # : .66>/ 9=764 5/6= 709<*/ 5 56/04? + 46.. ENTER ) AICT003-4-1-PITS 1 8  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] PASSWORD AICT003-4-1-PITS 1 9  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL]  T*6 59/ 804 /*6 +/+ *+. 766 46./45>/6 7? +..;04. 5 /*6 S+6. +<6 5+ /*6 P40/6>/ S*66/ 89>/50 ) T0 90>- 5/ , .66>/ U40/6>/ S*66/ 840= /*6 R656; R5770 + /?6 5 /*6 +..;04 /0 <+5 89 +>>6.. /0 /*6 S+6. .*66/ )  A. 804 /*6 6=0?66. +>>6.. , /*6? >+ <+5 +>>6.. 804 0? /*6 I/6= S0 +4/ 96 /0 /*6 A0; U.64. /0 E5/ R+<64. 89>/50 ) T*6 4+<6 08 /*6 64=5//6 >6. +46 .6/ /*646 /0 6.946 0 96>6..+4? >*+<6. +46 =+6 /*409<*09/ /*6 .46+.*66/ )  P+..;04 66 /0 S+6. .*66/ 76>+9.6 /0 40/6>/ 5/ ) W*6 /*6 +9/*04 ;+/ /0 >*+<6. 5/ /*6? =9./ /0 -0; 5/ ) I/ 5. 6+.? 804 /*6 6=0?66 /0 >*+<6. /*6 9=764 08 5/6= .0 ) HOW TO CREATE THE PASSWORD : STEP 1 : G0 /0 /00 7+4 + >5>- REVIEW ) STEP 2 : E/64 /*6 +..;04 /*6 +9/*04 66 /0 46=6=764 5/ ) T*6 46.. OK ) AICT003-4-1-PITS 2 0  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] STEP 3 : R66/64 +..;04 /0 40>6..6 ) T*6 OK ) AICT003-4-1-PITS 2 1  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] STEP # : T4? /0 >*+<6 +? 9=764 5 +? >6 + /*646 ;5 +6+4 + 70 /*+/ /*6 >6 5.  40/6>/6 ) AICT003-4-1-PITS 2 2  PRACTICAL IT SKILLS  [ASSIGNMENT INDIVIDUAL] SUM FIGURE  : SUM FORMULAE 1 S66>/ /*6 >6 ;*646 /*6 46.9/ 08 /*6 804=9+ ;5 76 9/) 2 T?6 5 /*6 >6 ;5/* /*6 69+ .5< @ 854./) 3 S66>/ /*6 466+/ >6. 804 /*6 804=9+ ) F04 6+=6, ?09 +46 469546 /0 .56 0; 840= /*6 G22 9/5 G2' +. .*0; 5 FIGURE  , /*6 .66>/ /*6 +96. 7? >5>-5< AUTO SUM 0 /*6 >6. /0 07/+5 /*6 85+ +96) # T*6 >6 804 /*6 46.9/ >+ 76 4+<<6 0; /0 +>*566 /*6 .+=6 804=9+ 58 /*646 5. =9/56 +/+ 0 /*6 .+=6 >09=)  SUBTRACTION AICT003-4-1-PITS 2 3  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] FIGURE & : SUBTRACTION FORMULAE 1) 2 S66>/ /*6 >6 ;*646 /*6 46.9/ 08 /*6 804=9+ ;5 76 9/) T?6 5 /*6 >6 ;5/* /*6 69+ .5< @ 854./) 3 S66>/ /*6 466+/ >6. 804 /*6 804=9+ ) F04 6+=6 , THE NUMBER BOUGH .97/4+>/50 NUMBER OF EACH ITEM SOLD +. .*0; 5 FIGURE & ) T*6 .66>/ /*6 +96.  7? >5>-5< 0 70/* >6. + /?6 E/64 /0 07/+5 /*6 85+ +96) # T*6 >6 804 /*6 46.9/ >+ 76 4+<<6 0; /0 +>*566 /*6 .+=6 804=9+ 58 /*646 5. =9/56 +/+ 0 /*6 .+=6 >09=)  MULTIPLICATION AICT003-4-1-PITS 2 4  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] FIGURE ' : MULTIPLICATION FORMULAE 1) 2 S66>/ /*6 >6 ;*646 /*6 46.9/ 08 /*6 804=9+ ;5 76 9/) T?6 5 /*6 >6 ;5/* /*6 69+ .5< @ 854./) 3 S66>/ /*6 466+/ >6. 804 /*6 804=9+ ) F04 6+=6 ,THE NUMBER BOUGHT =9/556 INITIAL COST +. .*0; 5 FIGURE ' ) T*6 .66>/ /*6 +96. 7? >5>-5< 0 70/* >6. + /?6 E/64 /0 07/+5 /*6 85+ +96) # T*6 >6 804 /*6 46.9/ >+ 76 4+<<6 0; /0 +>*566 /*6 .+=6 804=9+ 58 /*646 5. =9/56 +/+ 0 /*6 .+=6 >09=) ABSOLUTE REFERENCING AICT003-4-1-PITS 2 5  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] 1 S66>/ /*6 >6@. /*+/ 5. 469546 /0 76 0>-6 /*+/ 5/ ;5 0/ +886>/ /*6 +96 08 /*6 46.9/. @T*6 >6. 469546 .*09 0? >0/+5 /*6 >6. >0045+/6. ) 2 P46.. /*6 F# 79//0 0 /*6 -6?70+4 /0 0>- /*6 >6. ) 3 T*6 F# 79//0 >+ 76 46..6 >0/5909.? 804 588646/ /?6. 08 >6 468646>5< :  1./ 46.. : A7.09/6 468646>5<  C0=6/6? 0>-. /*6 >6  2 46.. : M56 468646>5<  L0>-. 0? /*6 40; 08 /*6 >6  34 46.. : M56 468646>5<  L0>-. 0? /*6 >09= 08 /*6 >6  #/* 46.. : R664/ /0 045<5+ ./+/6 CONDITIONAL FORMATTING AICT003-4-1-PITS 2 6  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL]  F04 /*6 C05/50+ F04=+//5< @CF 5. + /00 /*+/ +0;. /0 +? 804=+/. /0 + >6 04 4+<6 08 >6. , + *+6 /*+/ 804=+//5< >*+<6 665< 0 /*6 +96 08 /*6 >6 04 /*6 +96 08 + 804=9+ +46 >46+/6 ) F04 6+=6. , /*6 +9/*04 >+ *+6 + >6 +6+4 *0 ;*6 /*6 +96 08 /*6 >6 +46 6.. /*+ 1$!! + <46+/64 /*+ 1$!! )  A >6 *+6 9 /0 2 804=+/ >05/50. , 6+>* ;5/* 0; 804=+/. ) I8 /*6 +96 08 /*6 >6 , 6.. /*+ + <46+/64 /*+ +46 .+=6 /*6 >004. ;5 76 .+=6 )  T*6 >6 +9/0=+/5> >*+<6 ;*6 /*6 +9/*04 +46 >*+<6 /*6 +96 ) S0 5/ 6+.? /0 =+-6 .946 /*6 ./0>- 08 /*6 >0=+? 6.. /*+ 1$!! /*6 6=0?66 *+6 /0 0464 /*6 5/6=. ) I/ ;5 76 =046 95>-? /0 >*6>- /*6 5./ 08 ./0>-56./ ) HOW TO CREATE A CONDITIONAL FORMATTING : STEP 1 : C5>- HOME + /*6 >5>- /*6 C05/50+ F04=+//5< ) AICT003-4-1-PITS 2 7  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] STEP 2 : I /*6 *0=6 /+76 , >5>- /*6 >05/50+ 804=+//5<) A 40 0; =69 ;5 +6+4) S66>/ *5<*5<*/ , ;6 ;5 >*00.6 *5<*5<*/ >6 804 /*5. 6+=6 )  S66>/ /*6 >6. ?09 ;+/ /0 0 804=+//5< /0 ) AICT003-4-1-PITS 2 8  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] STEP 3 : C5>- /*6 *5<*5<*/ >6 496. /*6 >5>- G46+/64 T*+ ) STEP # : T*6 46.. OK ) AICT003-4-1-PITS 2 9  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] STEP $ : N6/ , 804 /*6 L6.. T*+ 9.6 /*6 .+=6 56 G46+/64 T*+ ) STEP % : T*6 46.. OK ) AICT003-4-1-PITS 3 0  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] STEP  : 466/64 /*6 9=764 ;6 .66>/6) DATA VALIDATION AICT003-4-1-PITS 3 1  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] U.6 +/+ +5+/50 5 /*6 E>6 /0 =+-6 .946 /*+/ 9.64. 6/64 >64/+5 +96. 5/0 + >6 ) W*6 /*6 +96 +46 0/ 6>6/6 /*6 ;+45< , ./0 + 5804=+/50 ;5 76 .*0; ) 1 S66>/ /*6 >6. /*+/ 469546. +/+ ;5/*5 >64/+5 5=5/. , 6+=6 , *+6 .6>585> 4+<64. ) 2 S66>/ 840= /*6 DATA 45770 /*6 =69 DATA VALIDATION 3 F40= SETTINGS >*00.6 /*6 /?6 08 4+<6 08 /*6 +/+ 59/ + .6/ /*6 4+<6 ) # F40= INPUT MESSAGE /?6 /*6 6.>45/50 804 /*+/ .6456. 08 >6. ) $ F40= ERROR ALERT /?6 /*6 6.>45/50 08 /*6 =6..+<6 58 /*6 +/+ 5. /?6 ;40<? ) HOW TO CREATE DATA VALIDATION  : STEP 1 : C5>- /*6 DATA /*6 >5>- D+/+ V+5+/50 ) STEP 2 : G0 SETTING + 800; 5/ ) AICT003-4-1-PITS 3 2  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] STEP 3 : G0 /0 /*6 INPUT MESSAGE /*6 800; 5/ ) STEP # : N6/ , <0 /0 ERROR ALERT + >*00.6 +0/*64 06 ) F04 6+=6. , INFORMATION ) AICT003-4-1-PITS 3 3  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] STEP $ : T*6 46.. OK ) AICT003-4-1-PITS 3 4  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL]  F04 6+=6. , ;*6 ;6 >*00.6 STOP ;*6 /*6 +=09/ 08 /*6 5/6= 709<*/ +46 >*+<6. 6.. /*6 1$!! 5/ +9/0=+>/5>+? ./0 ?09 )  I/ 76>0=6 5-6 /*+/ 76>+9.6 +9/*04 >*+<6. /0 1!!! ) I/ >+0/ 6.. /*+ 1$!! ) AICT003-4-1-PITS 3 5  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] CHART  A >*+4/ /?6 5. + .6>585> .6/ 08 /4+.804=+/50. =+-6 /0 /*6 045<5 >*+4/ ) T*6 6.5< +46 >*+<6. + 0/ >*+<6. /0 /*6 +/+ 7? 5/.68 , 79/ 5/ =+? *+6 + 40809 5=+>/ 5 /*6 ;+? ;6 .66 ) A ;6"-0; .6/ 08 /4+.804=+/50. 5. /*6 >09= >*+4/ ) I/ *+. + 9+5/+/56 .>+6 0=5+ + 045+ ) I/ +.0 >+ .46+ /*6 +/+ 05/. 66? +0< /*6 "+5. + 4+; + 46>/+<6 76/;66 6+>* +/+ 05/ + /*6 "+5. ) HOW TO CREATE THE CHART : STEP 1 : G0 /0 ANALYSIS + >5>- /0 /*6 5>/946 ) STEP 2 : C5>- INSERT /*6 >09= 804 >*+4/. ) STEP 3 : C5>- 45<*/ /*6 CUT ) AICT003-4-1-PITS 3 6  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] STEP # : T*6 <0 /0 CHART /*6 >5>- +./6 )  Y09 >+ >*00.6 ;*+/ 6.5< ?09 ;+/ ) EXAMPLES FOR THE OTHER ANALYSIS AND CHART SHEET AICT003-4-1-PITS 3 7  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] MAIL MERGE  M+5 =64<6 5. + 9596 89>/50 5=6=6/6 5 M5>40.08/ O885>6 W04 ;*5>* 6+76. /*6 65/04 /0 >46+/6 =9/56 0>9=6/. ;5/* .5=5+4 804=+/ 79/ /0 588646/ 46>556/. ) AICT003-4-1-PITS 3 8  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] F04 6+=6. , /*646 5. + 4696./ ;*646 /*6 65/04 5. 469546 /0 .6 /*6 6//64 /0 6=0?66 +709/ 3 606 , 5 ;*5>* /*6 +=6 08 /*6 46>556/. @6=0?66 =9./ 76 588646/ ) T*6 =+5 =64<6 89>/50 =+-6. /*5. -5 08 =5..50 6+.564 7? >46+/5< + 5./ @04  5=04/ 06 840 0/*64 +5>+/50 ;*5>* >0/+5. /*6 VARIABLE DATA 08 588646/ RECIPIENTS + + <664+ 4+8/ .0 /*6 6/+5. 5 /*6 5./ >+ 85/ 5/0 /*6 4+8/ + /*9. , 76>0=6 >0=6/6 6//64. 46+? /0 76 .6/ ) HOW TO CREATE WATERMARK  : STEP 1 STEP 2 AICT003-4-1-PITS 3 9  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] HOW TO CREATE MAIL MERGE : AICT003-4-1-PITS 4 0  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] S/6 1 : C*00.6 6//64. ) STEP 2 : T*6 S/6"7?"S/6 M+5 M64<6 W5+4 ) STEP 3 : AICT003-4-1-PITS 4 1  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] STEP # : STEP $ : C*00.6 TYPE A NEW LIST ) AICT003-4-1-PITS 4 2  PRACTICAL IT SKILLS   [ASSIGNMENT INDIVIDUAL] F40= /*6 6; 5./ , .66>/ C9./0=56 C09=. + /*6 ;50; +. 5 Figure ;5 +6+4  ) R6=06 +? 9;+/6 +.6>/. 7? .66>/5< 5/ + >*00.6 D66/6 ) A +? 6>6..+4?  7? >*00.5< /*6 A 79//0 + /?6 /*6 +=6. 804 /*6 46.6>/56 856. + >*00.6 O- 0>6 5/ 5. 06 ) I>96 /*6.6 +.6>/. 5/0 /*6 5./ +. .*0; 5 : 1) T5/6 2) F54./ N+=6 3) L+./ N+=6 #) A46.. L56 1 $) A46.. L56 2 %) ID ) Z5 C06 &) C5/? ') S/+/6 1!) C09/4? + R6<50 11) C0/+>/ 12) E=+5 A46.. 13) H0=6 P*06 1#) W04- P*06 1$) C0=+? N+=6 1%) F5+ R6=+4-. 1) S/+88 >0==5..50 1&) C0==5..50 V+96 1') S/+88 P64804=+>6 AICT003-4-1-PITS 4 3  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] 2!) T0/+ S+6. 21) B4+ 22) S0 I/6= STEP % : E5/ + +.6>/. ;5/* /*6 6/+5. ?09 *+6 ) T0 65/ =046 /*+ 06 64.0. 6/+5., .66>/ N6; 6/4? 840= /*6 N6; A46.. L5./ ) E+=6. +46 .*0; 5 F5<946 0 *0; /0 65/ /*6 5804=+/50) A8/64 /*6 65/5< , .+6 /*6 5./ +. MAIL MERGE ) STEP  : I.64/ /*6 MAIL MERGE FEILD AICT003-4-1-PITS 4 4  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] STEP & : M+-6 .946 /*6 6//64 00-. .=00/* + >6+4 +8/64 5.64/5< /*6 +/+ 840= /*6 5./ 7? 4656;5< + /*6 6//64. 7? .66>/5< 588646/ 46>556/. 5 S/6  ) T*6 6//64 .*+ 00- 5-6 /*5. +. .*0; 5 Figure . AICT003-4-1-PITS 4 5  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] CONCLUSION AICT003-4-1-PITS 4 6  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] F40= /*5. 0>9=6/+/50, /*6 46+64 >+ 964./+ /*6 9.+<6 08 M5>40.08/ O885>6 E>6 5  46+45< + .46+.*66/ /*+/ +0;. 46./45>/6 +>>6.. /0 /*6 0/*64 6=0?66. ) T*6 .46+.*66/ >46+/6 =+5? >0.5./. 08 /*6 6/+5. +709/ /*6 56 /04? @5>95< /*6 +=6. 08 /*6 5/6=. , /*654  46.6>/56 74+ , >0./. , 45>6. + /*6 +=6 08 /*6 6=0?66 5 >*+4<6 08 .65< /*6 409>/ , /*6 .+6. @5>95< /*6 9=764 08 /*6 5/6=. .0 + /*6 9=764 08 5/6=. 68/ +8/64 /*6 .+6 , /*6 6=0?66. @5>95< /*654 +=6 , ID, .++4?, .+6. 46696 + /*6 /0/+ +=09/ 08 .++4? /*+/ ;5 76 46>656 7+.6 0 /*654 .+6. 46696 + /*6 ++?.5. 0 /*6 46509. /*466 .*66/. /*+/ +56. /*6 9.+<6 08 >*+4/. A.0, /*6 46+64. ;5 *+6 + 7+.5> >0>6/ 0 *0; /0 >46+/6 + .5=6 .46+.*66/ ;5/* 588646/ 89>/50. + 804=9+. ) I/ >+ 5=406 094 -0;6<6 +709/ /*6 M5>40.08/ E>6 ) T*6 46+64. ;5 <+5 -0;6<6 0 /*6 +5>+/50 08 /*6 =+5 =64<6 89>/50 5/0 /*6 0>9=6/. 08 + W04 856 , 5 ;*5>* 5. 5=04/+/ 58 /*646 5. +? 66 /0 <664+/6 =9/56 0>9=6/. ;5/* .5=5+4 >0/6/ 79/ 588646/ 46>556/. ) T*409<*09/ /*6 <95656 , /*6 46+64. ;5 =+./64 /*6 .-5. 08 <664+/5< 6; 5./ 804 /*6 0>9=6/. 5+ =+5 =64<6 , >9./0=55< /*6 46>556/ 5./ + 5.64/ /*6 +/+ 5/0 /*6 0>9=6/ ) I .9>*, /*6 46+64. ;5 <6/ /*6 89+=6/+. 0 >46+/5< + =+5 =64<6"7+.6 0>9=6/. ) B6.56. /*+/ , /*6 46+64. >+ -0; *0; /0 >46+/6 /*6 0>9=6/+/50 7? 9.5< /*6 M5>40.08/ W04 ) REFERENCES  JOSEPH J) FREEDMAN @2!13, Microsoft Word 2013 Plain & Simple) C+58045+: OR65? M65+, I>) P45/) ) 33#"3# AICT003-4-1-PITS 4 7  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL]  JOHN WALKENBACH @2!13, Excel 2013 Bible) I5++05.: J0* W56?  S0., I>), 2!13) P45/) , ) 1'$"23!  FROM ASKING LECTURER AND FRIEND  EXAMPLE ABOUT THE DOCUMENTATION FROM GOOGLE APPENDICES APPENDIX A : F54./ .+=6 08 =+5 =64<6 AICT003-4-1-PITS 4 8  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] APPENDIX B : S6>0 .+=6 08 =+5 =64<6 AICT003-4-1-PITS 4 9  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] APPENDIX C : T*54 .+=6 08 =+5 =64<6 AICT003-4-1-PITS 5 0  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] AICT003-4-1-PITS 5 1  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] AICT003-4-1-PITS 5 2  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] AICT003-4-1-PITS 5 3  PRACTICAL IT SKILLS [ASSIGNMENT INDIVIDUAL] AICT003-4-1-PITS 5 4