iT We = a = o Preniin abe Amato | Se Fama! These early computers used vacuum tubes as circultry and magnetic drums for memory, As @ result they were taking up entire rooms. oe roi thy ee) ey Lee Sheetal he gia ae eee seals sx gam Fete 1956 - 1963: Second Generation - Transistors The replacement of vacuum tubes by transistors saw the '¢ advent of the second generation of computing. They werea bie improvement over the vacuum tube, <4, alge ia San ng ls Bape 6 oe iTS Sas 98 ON tt Jie g o ile eal pp Al ltt gy phy a 1964-1971: Third Generation - Integrated Circults I Transistors were put on silicon chips (called semiconductors). ‘This led to a massive increase in speed and efficiency of these machines. SSH pe Sop dh aaa gy Soi wl Pa A ae, Sees a cal ply 1972 - 2010: Fourth Generation - Microprocessors This revolution can be summed in one word: Intel, The chip-maker developed the Intel 4004 chip in 1971, which positioned all ‘computer components (CPU, memory, input/output controls) onto a single chip. What filed a room in the 1940s now fit in the palm of the hand. PALIT A AE Go OES ct a NOD, gee a VAN ely i al 2 ie ate gt De Bopha 85g Bk A eM ae ye > 2010-: Fifth Generation ~Artificlal Intelligence fay ‘HTIer cei wth artical imetigerce are stl n developmen, bt some of these technologies are beginning to emerge and be used such = asvolce recognition, OL TL WU LULL roePeg tuba ty ty eg yah ig yeh tpt pep h tpt Mgt Mgt RN NN NET a ia} aplasia Ae Lay Sto ze! Age AS ln ca go Al uy AE g Jl GG a ans eae tla space I guys O9 gt Dane gt ee Gl Sl ce 4 = uss Laan & aul La i gueaor 22 aul Types of Computer pail le Spun Ales stasnceid otf pee 1. According to Size lke ole a 2, According to Function Gls > -& 3. According to Purpose lise ais 5 8 a a 5 a ea Computer According to Size les ole A yaet According to size, thereare four types of computers. 1. Microcomputers: Size, speed and cost of the micro computers are lower than the mini, main frame and super computers. Also called PC or Personal Computers, this computer is mostly used in homes and in many educational institutes etc. Mini Computers: Size, speed and cost of the micro computers are lower than the main frame and super computers but higher than the micro computers. Also called Macro computers, this is computer used in financial institutes. ain Frame Computers WW LULU U/L LLL ERUr LULU ruesANNAN henge Da | sae Jato el Size, speed and cost of the micro computers are lower than the Super computers and greater than the micro, mini and main frame computers. Pataca ATES sana sn ha rot ocd ty oe on) pele yo eye poly soo glass fees e - aS a fasts lana illo S pair yal yaty ‘Super Computers: | Size, speed and cost of the super computers are greater than the ‘micro, miniand main frame comauters, ‘fl Aes mdomtge wisi ept jae fran 9 peri S nie gal fy 28 gs yo Jpn Al eadyolf ol tay eS lata yas apa tlt asleep aul > According to Function Thiee types which are; analog, digital and hybrid ‘Analog; computers: Which are continues in nature and they use the ‘analog technique, lc yee SIL S cal yay yc fla oer Zyl) Digital computers: Discrete in nature, always gives the accurate value. errr : elle Hybrid: The combination of analog and digital computers : 2 Ph Fee apetl ole bell 2 Aye drag Sila! According to Purpose ‘There are two types of computers one ls special purpose and other (s general purpose, ‘Special Purpose: Thase computers are used for special type of tasks, ‘General Purpose: Those computers are used forall types of tasks, FULL ULL | |Beretta At Uy Diora B al sey she Graphical User Interface (GUI) Sol gs Gamal SUS Syaly 5 Goel ¢ at al aS 24 peal PENS ale Pasha Sat ol jis) plane pli ot Jlecal Syn Shey Ppa Bigg lit Janta gy 1. Monitor te Monitor is an output device which displays result of our processed data, gl yates BN le a eats gp oll gue al iy) §utS yas le ‘There are ttwo types of Monitor Al pul le Lule A.CRT {Cathode Ray Tube) La 2. LED (Liquid Crystal Display) 2, System Unit ge plus - ‘The rectangular box contains different components interconnected with each other called }) system Unit (also called CPU- Central Processing Unit), race ays de ah alee ts Sb tose Al Jal piles p ate 9 Julatine Bd (ap hae ge elle Al ply pl Passe Ale jee S arly Somippsltieyg ate CPU (Central Processing Unit) > CPUisknown as brain of Computer. A le Lo sx Sgaa of sys > CPUs backbone of Computers! yf, cut> yo yd yily ARLE a Toe yr yo > CPU processes our given Instrctions and performs specific tasks FE eS eye g SF las dale ge gla gS SS? pasty E 3. Keyboard 25. Keyboard is input device, i is used to enter data, select data, or give mary other commands via keyboard. : baited & Jel sle lal glaub Be age Hs yRe yyy ey tna EGE hata Ng MMT Lea Np pM t Ugh NTE ETL a Ve nnn a = 5 3 3 5 5 5 NRILITIULTLIUULIULTIIMInTUMITiuiuLruu ier roePepe TELE Mn Ape GED Me ene Mt TEE a 2 ares Ail |S eet cE Bog Mayday Se ely g 4, Mouse yusile eg Mouse |s input device, it Is used to select, open, and close a different files and programs via mouse. 2 Fo emf Ribas cae Al Jiabao vise 2 cea a aad a gS baie a 5, Speaker Peg Fre Sones tate & geste ng Ail jusdle peal F 8, Microphone od Site 5 Microphone is Input device; it & used to record audio also used for audio calls 5 in different software's of computer. a 4 Fare ap aig Sales JM pes gotta Al ts SaSely ash yee 4 Vogabang dull gly il Fal Sspiltvagee - ————— (Ras gy aon cree GATOS) Sy mee GloKe SaaS oe Se oe ese 3 toe tes sacle 2 BYE) SEG OS soe yet Beer a get sts oe 21 LO | rl gttn JS; 8 Bits en al tons GS tie Bs Gy pores a bet oo z| = = : a 1024 Bytes KB | RioBye Ste 5 1024 KB MB {See Byte) = Fe a 1024 MB GB Giga Byte) 23h AF = 1024 GB TB | (Terra Byte S20 BLL iriure ULTLTinLururun LULU ULL eSbeste e Apes | ye Focal Zl st Cae suse 5 aul There are two types of Software sl pail tyes 1, System Software sly phous Software's that control computer hardware or communicate with computer hardware are called System Sofware, eorethilia S Anlgepree Se pyle lpl hla ale a Fe ae BLA oe a la Example Js MS Windows, Drivers, Partition Magic, etc. 2, Application Software +554 94f11 Software'srunover System Software of Use toaccomplish specific task. a 2@, e Sata gal ga aa lla agg pha ay beta e @ AYE sane gS pty Alt Al ylty ot Ye amen co e é MS Office, Photoshop, Games, MS Paint, etc. Types of Datapaile the There are many types of data yA publ ele Us Examples Jite Sign, Text, Image, Audio, Video, etc, Types of User pile jas Jlanial There are three types of User, Al pak SU jase Jacl Example jlte Novice, Intermediate and Expert. Gai po Jatt 6 ae SES Amat all indy Satin Flt o> Zp ine Alyy yl pla Sadan IS jyily Unux, ote etlageys joey cos egle ul of al ab rae Cpa ye yoy yeahs te Al Jolée 25 Unix, Ubuntu, Suse, Fedora, Macintosh ULL LLTLieireriroruriraLriror.sururorirorir riae Saale 13 ci Parts of Windows La» anes alt jay Desktop bsu2 Ue lait cael plea Al gel ella Silly Hopha JF LOL al Soy alg Ele 2 vslagep yabsoleel pl pele oleaall $ gail ual y gating pa alte Dotan Sal Soy ilo ayoyeg Zomato Vere @ Oo Taskbar LS. Sana leg 9 tle al pel Lah S gate Al gig Se ang yam ald Sad soallaigs al ge jill Ls poate 92 oy29 9 bebe gs olel Ho» LB) 5g Start Men coi ey - Way NS aN Sipe al Ml, Fyre gal legate cual Alay Sapa g beat |Wap its Pf sits aoe FB vecstronieiosive ey Bovis CG rane in Jeon Tray 5 gteasi Mal aT eal Sg alt Gash vey ate gam ge bal Bai col gs) Bay i pe Jy 07 al Notepad pcp ANU legis Sty opal Lue lated MESS y Sle 1, Start > Run Notepad Enter Recycle Bin ys Jetta s, Aly bela gs al Saye ert lM bet pis ole Zyneate NM 2, Start > All Programs > Accessories > Notepad aaber Bote | aS Foo pha lb anki al pay ee |. Backspace 1, 2. Space 3. Enter 4, Delete 5. Tab 6 7. 8 9. Caps Lock |. > Right Arow |. © LeftArow ). | UpArrow 10. {Down Arrow ii. End 12. Home 13. Shift+ > 14. Shift+ © 15, Shift +] 16. Shift + | 17. Shift + End 18. Shift + Home 19.Ctrl+> 20. Ctrl + < 21. Ctrl + Shift+ > 22. Ctrl + Shift + — 23. Page Down 24. Page Up 25, Shift + Page Down o vogT Wie Jal pale Syl py cappllis Jltal las Jy Se ygy eral opt ae Jlaatal DBS S12 Ui cp as Jacl gay STU ye pap sop ant Jlaaial DoS cpap le ey ears AES Sp eye GLE ST eal gy Deere alegysl Sees etblSa of! Area asl Abas eurgas! sg as Jarl YT pg yp sop as Janta g8T pay ggy > ld bee A ol be we Die Nh ene Sosy $4 sedate Dba Sa ate Ste Seb slp Whe w> Sots Meet eM ee ae Spay FB fal Bll 0 al lye pS A oeg Bl fo BSS ple All eS eA beigy hl pol Ml pl le a Stipe hill gaya IS Bil 0 tl A oy Aes eta le Ades fag de Abie dee WU Uecans SR eee ee et Sound Recorder», Wyn gS 2s 3M pat oll load Sy 9 1, Start >Run>Soundrecorder> enter 2. Start > All Programs > Accessories > Sound Recorder Sticky Notes iy £141 hip oll 3 pica peed aga gaSl panty po 1. Start sRun=Stikynot> enter 2, Start + All Programs > Accessories > Sticky totes | Grovafelde Snehveizton i ‘ rc "Change Desktop Background pts jase teas WD Gidget eS ofa gh So late LS ol Fl Sees £ LE a clue ole Personalize p21 2 base slss .> Desktop Background 4.2 gaia yay, ol alll» glist gue 3inunTinuuiinnniniiinnuiinininiinnininininniinnnninnininnunininninnng a hr phe Arete | he Faerie dy! 5 oe opitllolifl pobteosparlin 4 Save ase er atS legal | puts eles 2p yo Changes ele pee? 5 - 2 am a = @ . anya 5 ‘ srl = step ; 2 Step 3 a sep toe ae x : | Greate Folder yet jalp LypSes $5 ald ly gate al ya ye pat a ald Peele cl se lees 1 Gf me tnstr mae DB tt ame a 8 tam te : a Step 2 Sheen gpuluoele sNews gl yuu ies 2 Ss oe —_—_ gly A pill yee le Folder 3 5 ey Bahan g Balak gle Falta LBL Wy Sele elle edb yWyold Lo Fg AS M2 gle ele pPaste ge sle gay ile She le 2 Rename 2 9S S50 der ge B piesa Ala lh coe cong Sauce aglf als Page! Gages ot Bs wp $0160 5150 days Alt ob ype ew be eG a Urnerahha tee 1 oe Sr oy) 399) uty! pals 2007 sauna pul :3 Sais Gad 99 Cl Bsn abe ol gall nll ail 1 aul Mey lated U aya Sin gg pe ga ge gl lal yo atl gy Bata dl yelp Pl Atle gal Sy alg al pl al po SINS eal gy 2 gal tt |. MSWord 2007 david MS Excel 2007 Jat yal gd . MS Power Paint 2007 Sail sg yal ol |. MS Access 2007 iinet . MS InfoPath 2007 gt yal . MS Groove 2007 suf vel pl . MS Publisher 2007 Pals al al . MS Outlook 2007 Shc yal . MS One Note 2007 Sp asaalal ©rroans wn Bypha al 1. Start > Run > WinWord> Enter 2. Start > All Programs > Microsoft Office > Microsoft Office Word 2007 3. Right Click on any blank place-> New -> New Microsoft Office Word Document +e als 84 p> atl 31» document extended tbs cal docx 8 > Jil = 2007 asl al document 48 doc sith = 2 MS Word2007 yy ap! bpcbgsct gy sea rapal ye 2S lal cbr garde pty Stang yg 8 tag tlmean az VS Fae! gh udusele Save yosle sylyuil 1 alii le th eSNE gH ybopalreAllename gy! ysl tee 2 aptag tyne solaggh fla saulatte byine Jib paalaisha $8 Sy 2047 Ct bay el 3 cota |) coeur |) 4, Saye As Ay Bada at tS J ae 5 combi Sa As gS Sle he yell 1 2 galueele cele Srey Mi yb oguls oFllename yi gules 2 pat otal ola dh ty heeled balan cla lh dM apelin Sf Zobel 3 Syloetza22ty PDF, OFFICE 2003, XPS 5 Jt) pal us dylas gl Jb tS HE gf ony Bogen gesph qasluseles 2Print geese salyall A a ig Sih gy leap ble ye OK yg Se nghib age ig ol gael a 2 PEE S LU gS Sten rb Slat yuilittl FPF ea.7 OttholaspyyBl 3 Se aertbecid firerent ot = olel zo sey a _Print, Quick Print, Print Prevlew ol sles Jig Sipser: Quick Print: BiB i yl Sala Print Preview: (pth Ct + F2 ghey) Dad yt Be iy 6. Prepare gyAl ais Juels ga gal S$ EER als yye lh Plea agi f Jibsa ole ail gal ald > 5116 4 Prepare hp cali Sole 2 Encrypt Document, ¢-# Sl 7 Prepare 51 252 ail 1 Pale pee 2PAL alee Ben Vea de Clipboard, Font Groups :3 ===) Home Tab sy Clipboatd, Font, Paragraph, Styles, Editing cals 5 car walesonae x Ribbon a Clipboard > Group Pl peg ygete Sol Alay gale cate 2 gh yl ST EE ee el Commands 6, .> Ae Sof! 4‘ he Ihde AIS $12 yoo Sle Folie 2 Cle seer Sos! Lat ale Slagihe SN sca get youn Sagi Sosll 2 2, Paste AE Sos Jeb ee ye A he pie ty aS SL 5 peels golds Paste dys) SoS utel ie gle 1 seg eS 812 sth SV Sea 2 CH dbedyye gel 2 3. Copy Bde ge fol yb EE Migs de slopes rus a Copy. gor sas! A Mag gle Sage 0 f)60 20t slayy Mange Fase 2 4, Paste Special Belle, tetemrbra pe Fos bo (iB) Poste Specie. gh poole 7 old g PasteSpeclal AS, So SWELLS le 1 Moa nest fla pLSle 2 Picture 4) bepaligileys, f oSlan gol gaul tee 2 key 7 | | | | :‘5. Paste as Hyperlink Bet ge sed (| resteseayoeaine hp Steg ge Sl 2 elue ele 2CopyHyperlink yAsle ple eae | Sl 2 ult @le 2 Pasieas Hyperlink goede yl al jeu oleae 2 sts www.google.com Al Je ge Sl 6. Format Painter Ast oSlin ge gle jl pal Z pe gol ge Format Painter sy, gle atl al ee gle jbl easloe D quilts sales gyal aos jlal zyulueele go) pl gh jlal goSlesy 2 Font Group Al Commands 14 4.9 U yyaSug,* Jlstal ggg oa jluluibias by $1 (Mg atetot Sata [14 [A 4"|[49] (BL Urabe x, a> AW) Ea hee 1. Font BES Lag jl ye ost ‘ME LatestiM Sattar = sgh pty let sgn! ge oS getign atl 2g le uit lhe agrgag FOMbageegetier oS afl 2, Sie BS wl Saf! [w= ye W gaan pS Bo gS oS gage ae altel cule Alt age ge SIRO ape ator SoS A 3. Grow Font AS fas! \w ya hag ls $1.3 alate Salts 5 las > Grow Font sg: pion J asl 1 ‘Hay by SMhitge a atl S| Syea 2OtH ole ye el 2 WW5 Wiwialok | pS Fane pel 4. Shrink Font Shy sat Sass rs} “a tag $12 plat sais 3 dd Shrink Font syste Fa! seg Plas SI diye pth F | See Zehr obywuSh 2 5. Clear Formatting Ag Sy cle Lal gp jLal pg JI 4 ihe Naey alg Ue lal $1.2 peal ants lis 2 Ls > Clear Formatting ¢se.2¥920,51 1 6. Bold Ye pl Sofi B ah ay SUA S15 pulser sales 5 ols Bold ay pe Sys! 1 Lag fl SMa ocho SB fiSa 20h biel 2 7. Halle PE seb Sol he deg Flas S12 pelt SLE 3 lbs oo Ital sy eget of ofl Mag Lily Slovan $ | fea Ct bay el 2 8, Underline Apdo hls Sof! a tee lg oI Sul ld > 9 $13 palit Sale 7 olds > Underline cqisgetis Sosl 1 big pele alehn So tie aya of Uys Ctl ayygee 2 =] 9, Shike Through SesSHees Sos! Cal he hy ella gee of l2 pulse le 2 ols > Strike THOUBH ay ete of af! 1 10. Sub Soript Ay Scork ey SIs y Sl Ba he iy Sao Ten Sl pele ol yo Subseries f af A WW i TULLabe Ae |S Die TT io aL le lS Sle 0k gue ltt 2S pal ok al eeL Z zal gd Les 3 opty 1. Numbering sap 62 Sept Se eal Soon sent eos! = ah Fulgdy sant sea onl ale A Nambetng ff Mies fbn Define New NumberFormat = gga le als pdb lus jules 2 pulusele y SypSuigiige jlendy gol yitl Lee 3 Set Numbering gl 2U syle 5,© py Bul6 rai oyate Soles A acai ght f1 4 ulus Value Bopha gS pyai iS cana Jel yg bl hay Spyd cud solid gleyl gst ea 5 UW yaa pho de ghana gf 5 ale oped ol 59h 2, ‘Multi Level List Dba, Seal thecal | = ae SF hpeupl gree zeus ge llumbering Bulle ye Saf 1 Siala ghantag Tab ayaa Bey oSlosil al Bly oul jal pou Safle 2 lag pf oe eS ny Define New Multilevel List ~ gy ume cle sult dg elu jules, 3 qulneeles 2 3. Increase Indent As ygA sosl = # veg Sela A aargosle 1 Sys etl ina ok taSla Sel 3 yds g,1y Increase Indent 2 Quoi Anything is possible when you have inner peace, CL \ PFT TUTTE AE AACAea Lea eG f 3 => z weiss) a 9 oe ectlaa i cclldaghenc (et sal eel x FESS SF Sul Sey) 5 6 by HT Semel) Sag loa)ocr Keyboard Scanner Mouse < J Input Devices oy Trackball Bar Code Reader : Joystick j | QF MICR fouch Panel Touchpad10. Align Text Center ‘Nhl 41. Align Text Right 12. Justify, . 13. Line Spacing 44. Shading Hee ele ! oS Baan Bee wh ale d ofl ‘gle se Salelseresg oslo 1 aay tigigg AS gual sale 2 olds Align TextCenter 2 Makes Fates S12 SUE Fy Se Ctr oleae yel 3 Boe eh al Saf! phys vetoes gehald fle 1 lata gt ails ale S15 push ale 7 gla» Align Text Right 2 Haiagaat al eal $12 gtlaR S24 20th okay al 3 Pla gS rhe oll a6 sahye wie sah alg Syl oS Sle 1 hy Sle 2 ld So loots 2b elustify 2 ag gf Hy s Jb SI 5 yole) Sea Ctr eae uel 3 Seba gs poll aah wed wheal Boer ule 1 ple els ole gail opedtgn yy glo thine 9 597 pealuate Sale 7 gli eLine Spacing 2 bag ig ging Ba gt NES celia 3 yln gf Sleagatd 2.02 gla 2g iy LO yea 1 Jy ca eh any gel 3 spl toa ga er anlb a yile 15 AEST, lt eas hp hie Falla AS Sty alte a aloe A Address; Qazi Muhala Opposite Al-Aziz Grammar School KN Shah || 03313688187 || Nelesnelye Senator rir3. Replace Ayla yf & igh aol gael Bees pts FHS S8 Ctl gysh lee els oils > Replace AUS gly ogeelu ze Replace With ,al shtie 51 p> ulus) $1 ygeat Find What 2 hing aide $1.9 pauls Sle 70, > Replace All = 3. SelectAll BHF lage cgi aay etise SU lyzed Sha SA Soa 2 Ct gy lb quale Slo 5 olds >Select All 1 4. SelectText with Similar Formatting © byty=_S11))y jl fu ae Select Text With Similar 43, 4,215 5 floyasole gaily ar wallbyse lly slulogate 1 Madey edie SM ygeet ily ill flan? pale Sales 7 Formatting 5, Select Object Adve SI SSb py pais tl h igh PE SLES pest opting sty yA 4 ot yd gel Sle 2 Select Object A Fephey Sele Zolugl Insert > Tab ee ed * Herero (hill ACD Bh ay SS op aba Clg aecmamaree ees ten A osctme ST EE. pee ara = ire ‘note are eae _ lata 98 pS Jali yabs reel al yesh ror oleh Eps» opal nse Pages > Group lCommands 3 4 99 pl syey Stl ede gas a A. CoverPage ApS jbo seslys2yrseg ol esl pot, gain do ype pols a he somite Sle 7 yl > Cover Page 1 Address; Qazi Muhala Opposite Al-Agiz Grammar School KN Shah || 03313688187 || khaleequefayaz@gmail.com FE crruatrputrunrrinrruunnrurc ain nariaahsee doa es) stag alle J jal gal pee be ashe spate la allan jul ilo ne yy 2 gpa gy dete ble oe capers tdaling 3 2, Blank Page aiyHl pists u hye aati gf ld pa I ape lala gly py ph gb 3 pelts les g(t ye Blank Page 1 3, Page Break Atl pyle gis S de Mle gsly me A oe shieg gt AU phe bale gly pape alte Sales 5 gl > Page Break 1 seg PAM de gy my phe J ytle S Enter 20,2 0tI yey gel 2 DT ay Address; Qazi Muhala Opposite Al-Aziz Grammar School KN Shah || 03313688187 | Khaleequefayan@gmallcom i LULABrg ee Tia dao Saal 4, DrawTable Apt Lyle oe 5. Table Eraser Agale des oles aot 2 ey sh pi rBao cata aba bad tle pl edad Se nl ab! ge ad sl yoo grad pula ele Bae ng shes i dete lal ge tl eral gle ie ya she gee dead gal gatay gal yb ne 2 Bags Layout Tab :7 sl Boag & let pS ey eh {aca pee * | ty 8G it sss a em . Table > Group Al Lt Commands 3 ga oo gpetl lus Slat db SS Oah 6 iol ane et 1, Select Adaie Fob det es a. SelectColl = Adee S ee Db. SelectRow = Ibis LS Ue Ls c. SelectColumn Agvye f plo eho d. SelectTable Abe fF ke 2. View Gridlines Dass las wes es pL ss Ls he ete Soll lLALat at Sb bel ooh 2 yl Sls 2 No Border ¢==!= Border 2 gy gal yb ask f gilt pails yeele 3 View Gridlines 3 3. Properties AGS pS beSoseds ye dat Address; Qazi Muhala Opposite Al-Aziz Grammar School KN Shah || 03313688187 || khal ra com iu 1 itBolte te | eel | te Fl ale Se p LLG Llu eho hod ran gt ts gll pe 28 lS pal SIS 9 ppb sya SsbA oye 2 Design >Tab 5 A Sle aw aehy $ Lead pao | you agga g io Sell lg lo lel ad olgten apa bad oda Bog ha ab Lilo *| : g Table Style Options > Group Al Commands 6 4 oe gual Lanse Jlantaal he oda S sla ibid 5 S at 5 1. Header Row AS ay By Shs ele 5 2. First Column DGS ob ip Ss, f pleases 3. Total Row ARS 6 ys Sy 5 sl obs 4. Last Column Abs ot J legs eb g 5. Banded Rows oS Mg er Bin Ed ge des 5 6. BandedColumns assy ple A aes, plese Ls 5 Table Styles > Group Al Commands 3 ip oA scyyedl ts SLeataal ode) fall altde S Ja s 1. Table Styles Age bw jules g 2. Shading ABS ybeds 3. Border AGS pt Lad rab f ded : he 3 g Draw Borders > Group 5 PlCommands § 42g 3a) lee ual aye das Sb yebe = 1. Line Style Dg 2 dus jl psd oho 3 2. Line Weight Dye publ Sod oho 3. Pen Color PbS dt Sy ye bye det ‘Address: Qazi Muhala Opposite Al-Aziz Grammar School KN Shah || 03313688187 || o khaleequefayaz@gmail.com SLIMLINE AUT ruTunururuirunirunin LULU ahat tester She Pe Pal a gatos ti ltl DF @——— eerertigns 5 [eres mcoiaing.. (Goto == rudolph —— AlCommands § 425 AoA Weel e Sle bel igh 1. Delete Abe SS Lobys ji ple 2. InsertAbove See Hite "| at ‘Bi invert Below 3. Insert Below eas ts pit ENS linenien ete | Mhore Gib insertrignt 4, Insert Left By ple gy al olf Gui cncomees 5. Insert Right AH pl apt ale a Merge > Group al Commands 3 4 gyal ne Jlaniial pile S$ Ad 59 olf ly B , ef oS Syl glee 1 MereGate BAO ac 3 2. Split Celis Bp S ge ison ces a 23} spit Tobie 3. Split Table Ayby Shs aia Cell Size > Group 51 ‘Address: Qazi Muhala Opposite Al-Agiz Grammar School KN Shah || 03313688187 || ie lescucayeni ena.comy Pl UUabr Hr Vay Sree 2, | Picture Styles > Group LU gaBen 5 Ae ear ill alte Ligh bd a byslige grasa Al pps bl yes Bop ye dar, les 8 pyr 1.Ploture Style gS jlasluiltse Spy 2,PletureShape Sey 4l@2 5 pa B.Pichire Border SoS eb US pyar 4,Picture Effects Sy Suit, cig initbe 5 py Arrange - Group lp Se alagey peg 2d) Pode lie S pps 1. Position DET coke Alida GF gy ad ta f pe? 2.Bringto Front gil shila peat Seat) Jed ase 3.Sendto Back — A bBobly we ppat F bead aya 4.Text Wrapping = Sys nagiee $1 ub ul > lg nya? 5.Allgn Deyblaz eae net 6. Group BEES ed panes Sy hs 7.Rotate Me Snot Size > Group ae 1, Crop eS ine 2.ShapeHelght Saf tos! appar Sos AbSss B.Shape Width a fy > ya Somerrdiezyselalalt 2 3 Buu uuu UT jazi Muhala Opposite Al-Aziz Grammar School KN Shah || 03313688187 [| khaleequefayaz@gmailcom UALALILTL er- preg U soe Sami Al Commands 5 429 ogee! ait Jlantaal SS oder S gid ge ded . Table Row Height MHS ESS Hele We Ls . Table Column Width MESS Sy eleeks | fjoe +4 Auto Fit BS dee S See rofl . Distribute Rows PUBS yy 4 le gam San 8 gL . Distribute Columns A Bln yyg ola gree San Sf gle Fee alCommands 11 424 oil Sit lloyd) 5 oSlgcat oe + Align Top Left ES ti lf te Safle 2. Align Top Genter oye eg ef osla des 3. Align Top Right BEE ht eS Sly dd wl sl al Direction sibge ms Alignment . Align Middle Left aS gud gl en Safle det . Align Middle Center Abe eefosladke oe . Align Middle Right DGS yh gl ey Sosla be a tee: for . Allgn Bottom Let AoE hbo Saslades Lom 4, 5. 6. 7. 8. 9. . Allgn Bottom Center DRS oes So Slabs oa . Align Bottom Right — Mbp ul ola cu S 9 S14 bast 10, Text Direction MES LS poSla Lt 11.Cell Margins M4 Se8 Hohe eosle beds Data > Group 4 Ash AU sheng Salen orb oe gets S aSlald agaSur Al Commands 1. Sort PopSet zy lal tal 2S lle ge Ls 2. RepeatHeaderRoW ode a S Moe el Al z a 5 Sy reepent Header Rows idles 2S mente 3. ComerttoText bila galas as Sg Buuniruuuunr i ‘Address: Qazi Muhala Opposite Al-Aziz Grammar School RN Shah || 03313688187 || khaleequofayaz@gmailcom RTTie VS See! 3. Shapes Pibye dat gyda Jab he ol Let slasse ge yistligy ol ole led aie ol gad few 1 Pla gSayomlue sale Add Tent gjeele ple gle yey Uy pha Sey Slqledyl 2 Wayihe fl ch glige Format yal Tab a3 8 © Jets gla iy yf dl oy Format > Tab « : Text > Group : 1. DrawBox deb us ybesl 5 2. Text Direction Ab det Spb ye Sl 3. Create Link BBS Sd gh Jos yp wes Jes 4. Break Link Ag psf Text Box Styles > Group 1, Shape Fill AGS Ss ghu eles a 2. Shape Outline Dy les ply tie ales a 3. Change Shape abS Ly jules = Shatlow Effects > Group 5 1. Shadow Effects BgS Shit ble Jesh pp a 2, Nudge Right Does rll = 3. Nudge Left Deere = 4, Nudge Bottom Bose el ose 3 5, Nudge Top Abe ree bosts 5 55 2 Address; Qazi Muhala Opposite Al-Agiz Grammar School KN Shah || 03313688187 || 5 khaleequefayaz@gmail.com 5 ESLrUrLrUrUrurcrcror¥rurorcrucremararururasugusur a rerun runUrUrLrUrePLTLTUEBelden US Sone Ze te oledatal go ole 7 EditData yp Bale plioleeoldedssbeiseje 3 Bopha edie Milk oll Sugar Rice a ‘Terese ar dats range, Gag lovseright comer of ranqe, Links Group :8 ===! Links > Group Al Commands 3 4 o& Wah Adal Shon So Slab grayt ot 1. Hyperlink opal lus Jel Sadia Sy Sl Luge ighyb sig S lal ped Sy Slyed gy Sle BK Sd 2Ctl cle gygute lg eo eales 2 Hyperlink aye 2 BIS FES 2 yt le gall Wye Cas Se lays gh Tales 4 yl gud gl = ply! Les 3 gig Its gual lS Fok yg Quote: Aroom without books is like a body without a soul. wy ‘Address: Qazi Muhala Opposite AF-Aziz Grammar School RN Shah || 03313688187 || Fis leouctaver oma com i | ' } q ANILopen Ply Safle hoe gS Ll lq yao aling inte ge he gail layed eta t oe AlCommands 3 ya oyaSu Sly alle ng 1, Header BSI Sl g a> ate ede 2. Footer ISIS pao ont eke 3. Page Number ApS yay phe Text > Group Teh opetl Las dled aby Bg tigi le by jh eS y Slab aad & al Commands 1. TextBox Ab petylgosl 2, Quick Parts byte dalt, WL ger 3. Word Art 9b % Jess ila alia 9 SI 4. Drop Cap AeA aby Slonaa oe 5, Signature Line AS bins 6. Date &Time Aye Ll ciyg fu jbig Ja 7, Object BS MES I aol Sep oy Symbols Group:11 je! Symbols > Group l2 Commands 49,8 ca U ysaSung © alt gulls Glide» JU as meg S 1. Equation Db Lal olglan 4 Sots 2, Symbol Fb Sal yy sls, Job Page Layout Tab, Themes Group, Page Setup :12 »=Tab . We le Peon SSG SP mine: armen Storie amet: Se a sane maa - aulnooese nil — al sak 5 4 pal gah gg yphibe Uhitee ye da lal ged oe Themes Group ‘Address; Qazi Muhala Opposite Al-Aziz Grammar School KN Shah || 03313688187 || khaleequefayaz@gmail.com Ae 3 Bunn LULLa) tpg rete tether t yt tt BAe Vay So ) Ugh gS foe, jl ae Fg ST gal ys eas Page Setup > Group Al Commands 7 p65,8 4 W gpg oben e da gl as ects 1, Matin AaSiseal A em giolie ede 2. Orientation bles Sf ila gly Soe eke 3. Ske Aah bets ole ede 4, Columns Aotlayyy gle YS he 5. Breaks MEIF SF eh eS oth S he 6. Line Numbers FES ps old oe gill 7, Hyphenation esta peal! pues bd a allt, nal $1 Page Background Group : 13 ==! Page Background > Group Bagh Shapes peal beg Sy Shea Sob asl ess as ecas oe AlCommands 340554 1. Watermark og8T ue lial HT $1 yl ye a ST ye goby jie gle ol gal Le quale eles Watermark 1 omilaide Sole 7 Custom Watermark 5 sie“ Watermark 555.2 Wye SI St gh oe pine geal ve Text Watermark 2. Page Color oad late Jlantl ASS, IF her 3. Pager Borders opal lane Jatt DES yb Bers be Paragraph > Group Bets eh esbaee te A east aed posal aod eoas® sogatl Bait Janta! osetiy op obey Sj Se ALS ot BS gy uel lig 2 Suu WWW ‘Address: Qazi Muhala Opposite Al-Aziz Grammar School KN Shah {| 03313686187 || khaleequefayaz@gmail.com Tr nreis ie ee Bool - Microsoft Excel Continue Numbers 1.1 ts Sb yas 1 pie fob sil 2 Psy + yal ole poly Sty lSsey Sue eben 3 ggg IES, yp glo pelanh Matag Ig Bs gps oles yagtle go Sale 5 se olay 4 Bi giSes pb a8es8y I gall U apsSur ab joe galas glul 62 ‘Address: Qazi Muhala Opposite Al-Aziz Grammar School KN Shah || 03313688187 || Kinleseyer Bea com JULIA. 1 Jur IClipboard Group :2 lta ye Paste geose8TU satea ayy ceil pl oll pee al peo LP gry S aaa Beret ee Saget | yh Spee aya : ae! aS ahiksh 1. Paste gel ant lead ES Fate SI Lat ale 2. Formulas gl ae Jlatul AS 9p jU Lo le 3. Paste Values pA 2 go JB 69 BS ) SN gle gall Ja ol g gui Sam 4, No Borders rel tees glut sgl Alls le slo dose 5. Transpose atl Sg lle oa 4 Ua S105 gS Lets jlo g $1 ele 6. Paste Link Ags ei be ple 7. Paste Special = 45) 8 Sly fall old 8, Paste as Hyperlink sys, is le 9. As Picture eS gelb ye pyat f ofl igh REGES Het sf gee 1 Epa S Sly Sale roll pale of) 5 oy Sloop 4 jlal weg gaee yes 2 Alignment > Group (= wiv | Eeaer a: Atignment at PTLGl Commands 29S, 2 Uy pS abs jl ays; SoS aus eoat oe 1. Allgn Top ARS Site 2. Align Middle Se see 3. Allgn Bottom dys Shas 4. Orientation Bb Sots lls pul S ofl 5. Leftto Right Text Direction 3,451 ul ela lS Lgpl ofS yal 6. Wrap Text AE gana ple oF pala gal pl yl ple S151 7. Merge g 8 A Address; Qazi Muhala Opposite Al-Aziz Grammar School KN Shah || 03313688187 || Kdhaleequefayaz@gmail.com 1A Lsa, Merge& Center StS rea Saf! tes ob SSyal phe b. Merge Across ApS ld 25, OL 6. Metge Cells oie S ob Sd ol he d. Unmerge Cells Sg ,e $i SAS Jule he sete gS ol ll gale bile Sole 1 Aaday gal g slat gl LB. paige f Command pai gle gatao 15 ta 2 Number > Group General = (s-% +a) rae Ui yg han gS dhs jl Hheda le BS SIL afl Ad 1, Number Format dS bots jlail pp IS Sa 2. Accounting Number Format SSI 4 eyeF gil) et S te jl 2 Re! 3. Percent Style Baba jal gla green f Sl 4, Comma Style Ab SH gaya ge lls hl 5. Increase Decimal gig Jad, SI 6. Decrease Decimal Meets phd 4 Sl he see Foiled te dees jail ea SLB ealt oe 1 SPLAT afl a ceoele sil alte Las Safle slate 2 Quote: Don’t just read, act upon them too. g ee ‘Address; Qazi Muhala Opposite A-Aziz Grammar School KN Shah {| 03313688187 || khaleequefayaz@gmall.com en BuStyle Group :3 ss) Styles > Group voll Labs Commands Altay oo ougeal Lut Jlantaal S55 fail tlaine S ould plan yo Sil ailine cal dale Commands £554 calle 1, Highlight Cells Rules a, Greater Than... OF She od SNS ye Hb Late mel Sy ot | sync] = Sug des jlalye Ge yl agupesy . b. Less Than... SSAA ge od SIG ge Bs Lattge el Bly gd gig gisele gglayapcat (EE oem | Semen. c, Between... Ag ge A VSS ge or ettge pala Sal zg ot gig tae jal ge gibt pieaey eG See eae va d, Equal To.... uote he ANS ge BE attge elt Sag gt ja ni Sh secon | omnme e. Text that Contains... gig Sly MLB ge oh NSA Shay ola SAL 1 lage cle dodge cnalted JMBAl gor stig gt bet lal 92 8 ol f. ADate Occurring... debe jal ye 26 ol 2 aise Sly Var nn ch Sloat eal bdr oll aly od sky g. Duplicate Values... gAleg aed iM ge bh dg Wf Bal Saedy olF og ee A ole 2b ete hh, More Rules... BaD bos jal 5b ob ‘Address; Quai Muhala Opposite Al-Aziz Grammar School KN Shah || 03313688187 || Kdhaleequefayaz@gmail.com Wi JUL Beha de ! Sein 22! ULL eRe eeeHaband too inl 10. Cell Style be jal oS ot Letige he sete Ahal PS EL lg, goby 1 4¢2215,2 Conditional Formatting 2 cetyl 9 le shaulltis fans 3 tig dee jhe ge Jb 3 jal s peels GOK gpgragile LSS, gail 4 Cells Group, Editing Group :4_ ==.) Cells > Group rs lvest = e ABE Sole yat S vatligyy Lb UE MEL gail ygety cate tucedl oi. yl LeeCommands zy>Insert, Delete, Format 4.2 gal Lie Jlastel [E]Foimat~ yj seme nn A Insert ae = rae St a. Insert Cells... Bb jSa ald g Sead gb oy e 4L Reviticiohit. b, Insert Sheet Rows Ab SZ bl, So bE g ene c, InsertSheet Columns bali, Gud ple ogi 7 Column width... ‘utoFit Column width d, Insert Sheet ARS be, Med 2 faut etn. he z visay Hide & Unhide » Ses Bl Al 2S ld MEL UL gb ele gate 1 Organic Smeets gta, lb 3 pales ale ats an 2 ates ola tbat gail pgs 2 3 ename sheet Move er Cony shee. tate allt go a Tab Color , 2. Delete 5 Protection a, Delete Cells... BYE 95 ole Cad ge g ieee b, Delete Sheet Rows Hayfepib ola Sad a 3} |S Format Celie, c, Delete Sheet Columns ASS gb 44 le g d. Delete Sheet DHE BSS Sad g he ep ls il Al ps pl jt lb ale gate 67 Address: Qazi Muhala Opposite Al-Aziz Grammar School KN Shah || 03313688187 || khaleequefayaz@gmall.com ESUrU/UFUFLLrreruuurururriarrsurur LF runskrarurururLrururLrveLrTS ab cite Fee | phe Feet ee ULL | 10 20 =Aze2 ms | [oe [os |e Multiplication Formula ..352,8 4,202 A | 8 [ti 0 20 30 30 =A2*B2*C2"D2 20 30 30 =PRODUCT( A3,83,C3,D 203030 “SRRODUCTIASDA) ee pA Mea Mpg peep pega sale la|sls S55 Division Formula 952,46 j>3,© uy Als ¢ e e i 2m sayee ES Average Formula 35+, 5> sles plo a a er 2\10 20 30 «30 =SUMA2,82,¢2,02)/4 30 ED ES) =AVERAGE|A2, 83,03,04) 4{10 20 30 30 "=AVERAGE( ARDS) Find Maximum Number, »ylas 21 559 55 le a 30 30 SMAN(A3.83,C3,03) 30-30 =MAX{AS:D4) 5 5 LAL Find Minimum Number 4, pylas sue 530 4 gas LLL ‘Address; Qazi Muhala Opposite Al-Aziz Grammar School KN Shah | 03313688187 |] ec Kchaleequefayaz@gmail.com, ITUane asian 30 30 _=MIN(A3,83,C3,03) 30 SMIN{A&:D4) Count Numbers gf 5 i! af Sily 238 p> —_ a] 1 Name Frame Fee 2 lati ahmed | 3 |saeed shalid [4 lamehed MRafique 500 “5 khaleeg Fayat 500 6 Total =SUM(C2C3) Paidfees =COUNTIC2:C5} Oi. | » —<_ic 2 Name Frame Fee 2 |au Ahmed 3 Saeed Khalid 4 Jamshed MRafique 500 |S [khateeq Fayat 500 Le Total =SUM(C2:05) 7 | PaidFees =COUNT|C2:C5} [3 [a9 Unpalé Fees =COUNTBLANK(C2:C5} fn Concatenate Apis $a $1 pAb S850 yl 2 ‘Address: Quai Muhala Opposite Al-Aziz Grammar School KN Shah || 03313688187 || Hales erei@enal com LALLA ni