lin rae 1 2 MIN 3. MAX 4 COUNT 5. COUNTBLANK 6.. AVERAGE 7. PERCENTAGE 8. UPPER 9. LOWER 10. SORT. 11. SUMIF 12. COUNTIF 13. IF CONDITION 14, TAX OPTION 15. CONDITIONAL FORMATTING 16. ADVANCE 17. AUTO FILTER 18. PIVOT CHART se 19. SALARY REPORT #20. GOAL SEEK __ 21, FORMULA AUDDITING =°.22. SCENARIO MANGER 3. PROTECT SHEET | $5.07 gSELLS-aei >> 26. DATEINPUT = 27. SERIES ae : 28. DOUBLE O7 Zz an” oF a om a = _ _ Henn nbnnaet Page j if PISCUSSsSsSSsSsnssss eSbpopprseerPPOoseL ELIA, ug pon 07 Ci i | MS. EXcEL 1 3 4 Highlight © ‘Top/bottom rules~ \ | delete: COUNT COUNTBL ERAG AVERAGE: 7. PERCENTAG 8 PRODUCT : 9. UPPER 10, LOWER: aif (H2>=360, B15. TAX OPTION:- 15. TAX OPTION eer 7] if (b2>=3000, bz» 5%,1f (b2<=3000, b2 Ay) ent? b 6. CONDITIONAL FORMA TTING © Data bars- elick-anyplace click. t click ~anyplace click. Jick -anyplace click. cls rules ~click -anyplace click click anyplace click emin(b2:b6) JAN E 2 30," Conditional formatting- | 17. ADVANCED:- salary. click - clear rule: sum(b2:b6) enter ) enter max(b2:b6) enter = ecount(b2:b6) enter = countblank(b2:b6) ony we(b2:b6) ent . pduct(11,3) enter (a 14, IF CONDITION:- 0, pass” If(b2<30, ‘second If{b2: a 230,"Fail' Third’ Afb ¢ caz<1907 suim(b2:b6) - [=h2/6p9e400 ente7) ' 3) pper(‘ansu") enter (ans=ANsyy Jower(“ANSU") enter (ans=ansyy ort(49) enter(ans=7) (sart=square root) 100") or mannii Beets ea enter sr"yyyenter tyle click- condit salary 33000 (or)<3000[craiteria range) onal 1s-click-Clear rules from selected cells- click. 1000 2000 3000 4000 5000 {| ow— and Fitter-click -advanced-click ~List range-box-click- ‘ BRALAAAE Wr ___ em nnRRRRaneName salary ~select- eriteria ra 18, AUTO FILT R:- DELE' box-elie. ( copy Copy to text box: Click- outside-Click-o., ke getect Name-salary-select-data click sorta Custom fiter-click-equal box-click-is greater 4a number (3000) or click-second box-elick-is jes Home-click-copy-click-outside-any place-ci posnsseF nother ocati”” once ja click mmber iter vpaiary chick per ther ere iy csickany re n iC ey CHICK (2000) ON erick smiths ni savary click nell 3 is Daste-e Data ~click-sort and filter-click-filter-ljey 19. PIVOT CHARTS:- Name ~salary-select-Insert charts-cligiz any place ©" 20. SALARY REPORTS:- 20-SALARY REPORTS ree ‘TA=Traveling analysis=b2*5% DA=Daily analysis=b2*6% HR=House Rent Analysis=b2*7%, Gross=Sum(b2:e2)enter PF=Provisional Fund J M(f2>3000,12"5% if(2<=3000,5%"4%)) LIC=Life insurance corporation=b2*5% enter — >“etsalary=f2-(g2+h2) enter 21. GOAL SE K: Net salary ~click- data-click-data tools-clicic what-if analysis-clic) rood seek ~click: Set cell (12 }-lick-normal to value -2000-click-any change number used by changing cell B2- click-any Change number used-ok prpsseOPosoUoeooooooED QRREERALE y ee a B eT Oe a ee[peorspsoDESDOSOE SEIS y, 4g lI” MS. EXCEL 22. FORMULA_AUDDITING 22, FORME Focsiany at side “Any were-click Formula gig qamon HPT other “ay ae vrage count, mit, MAX otRer-any plyeg fy galas Ie enter ed Any number-eliek- Formulas: lek: formula augiyinge OO p used- recedent-click Salary -number click formulas auditing - click trace pret gent-click- ‘ prece! DELETE Outside-Any number-box-click-formula Auditing cyick-TeM"™ A Salary number-used click gel 23. SCENARIO MANAGER nn aa rrow-click-Some | er alysis-click- Name-price-select-Data-click data-click.ata qools-click-whatif a ee scenario manager-click- and -click-Any were-number-used-oF- an elle other ay eer tsed-ok-ok- Summary- clicks- ok- other any options. pasic used sum, count averager 24. PROTECT SHEET: - see 2. PROTEC! $< _ Review - click ~ Name- salary orany picture or any shapes orany word used . changes - click - protect - sheet - click - password to ‘unprotect SHe° number or any word-ok Reenter password to proceed - box - click - samt umber DELETE - Re 1 e word - ok Review - click - changes ~ click - unprotect sheet - c¥ek - same number or sams iP. pox click - any or same word -used- ok pr 25. CONSOLIDATE :- ‘Shoat 1 click - anjinumbBiesHiSet2,- clici = atigetaiciellcke- normal - click data click _ data tools ~ click - function - box click~sum, min, max, average, other ~ any Place = “Serene - click - sheet 1 ~ click - select - add click - sheet 2 - click - select - add ~ click ok 26. FORMAT CELLS :- Name ~ salary - select ~ home - click ~ cells - lick - Format ~ click - Format cells - click. Alignment - click - any degrees ~ used ~ click -ok-. Fout _ click - any modal style - click - any font styles click - any size - click - color Dox ~ click - any color - click - ok. Border - click - any color - click ~ ok - other any place - click. DELETE = Name - salary select - home - click - cells - elick Format click - Formal cells - click - ‘Alignment. 0 degrees - click - ok. Font - click - color~ Box. click - Automatic - click - ok. Border - click - None ~ lick - ok -Fill ~ click - No color click - ol. ANIT COM IHEP NSE dE EP E EPA POBPLOSOSA SSSR SS SOBASsHE 's: BAAAaAaas a ARRURRELEE ———— SRRRRRREE Aue naa ee SREERERER BAe \ | eee “«PEL ed dT aeaeeaean 5 MS. EXcEL DA’ INP. . : : se youcan write your | onwhich day you will open You can putt he gay, a 08 mn as HOR Ya > wre DY 6/13/199' ‘elect enter, clear 9 Y=b2-b3 enter(ans) 33.Toda} 34 Date value:-=date value("4/28/18") entorfays) 35 Date: =date(+/28/18) enter(ans=4/29/19) day(42398), enter(ans=29) onth(42398), enter(ans=1) (42398), enter(ans=2016) eck day(42398), enter(ans=day used) -Editing - clic! Any number used- Serial- No top- Used- one number - Select- Home” ob stay varie fill- click ‘ories ~Click- step value [”} ~click . Any first number = © Node Click -Any test- Number used- ok. C Sond Pind & El ker cA MQor \ . DOUBLE PASSWORD: / la od - Any password or Any shape or Art word or Any water - other AY used- Name Be 3 fy pasar on aD Aa cig = erorgrecheet — dick ~ password to un proters Shoe! = 03 |ostiek— Any number or Any word -ok ~ Reenter Password to Proceed - BOX click- same number or Same password- ok. File- click- Save as ~ click ~ Document ~ Click- File Name box ~ Click- Name ~ used- Tools = click - General options- click - pass word to open box = click- Any number or Ant word- used- password- to modify box click ~ same number or same word - ok Reenter Password to protect- Box- elick- Same number or same ward - ok - save- click close - window - clicky Delete:- File - click- save as- click- save name- click - open- click- same number- same word used- ok - Review - click - changes - click - unprotect sheet - click- same number or same word- ok 30. OTHER OPTION Column- 16384 Rows- 1048576 i AIT COMPL TER MIMMIISIAS PSSA NSSSSSSSPSSoSSsSs sos soe:ao ei! rr es PELL poor g ES ey g er a g 31. SORT ot g Soe ae ted One eee ied ‘ ‘i EY) -bliclea to Z-usea yey eee ae s (EW) -Click-Z to A-used a-2 2, HEADER & FOOTER:- — a —— ll. to address i aay Insert- click- text- click- header & foo, yo header - click - any footer - click - any form address useq” ick other - aPY place Insert - click- text - click -symbol click. any place - cick insert = click- close - click. a 34. TABLES:- ' Insert: click -select - table - click- ok desis HO i 4 * Table styles- click - any place - elicle 4 > Table styles options - click - any place tick > Tools - click - canvert to range - click ae 47 Delete > Home - click - cells ~ click delete- click. any place - delete sheet: click 35. ILLUSTRATIONS:- Insert - click - illustrations - Picture a Clipart Shapes Smart art - any place -click vVvvvyY 36. TEX >» Insert - click - text - click - cli ine lick - text box- click - any matter - used - other ~ any place - ADT COMPUTER ISI SISSNSsISsESeSsessseseeessesosseeE eeoe ee pt py, ES es a, | a2, re a, | oF oF oF i 37, ARRANGE Ms CEL (969 62 09 03 08 09 0 03 08 03 09g > Any picture or an eo Y shape, oes range - click Ps or cy, _———— 0 fron a Bring forward Tt ~ or other any place - used - click ~ page lay: Send to back ee send back ward & } : } 38. PAGE SET UP:- | | page layout -click- Page set, : printused. a Slick. orientation ~ click ~ » Landscape click (*) ~ Print seq Portrait - click- () - : COMPUTER WessssEsEEEoedsEseesOseoescecsssesese¢ se