Scribd
Upload
39 views27 pages

Excel Basic

Excel formulas

Uploaded by

Akhilesh Sharma
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
39 views27 pages

Excel Basic

Excel formulas

Uploaded by

Akhilesh Sharma
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
Total Cases | AhimadA | AhimadB| Ahimadc | ExciseAct _| 1060 | GamblingAct_[ 660 + _ I 1) Draw the following table and do all formatting, alignment etc. as per shown in table 2) Calculate the cases of Ahimad A, B,C if their respective cases are 35%, 40%,25% of total cases. 3) Draw a row at bottom after calculating respective cases of all Ahlmand and calculate the sum of all the cases each Ahlimand is handling. 4) After answering question 2nd and 4" draw another row at bottom calculate the average of all the cases each Ahimad handling without decimal point. 5) Center Align the first and second column. Scanned with CamScanner i} Student Name Hindi Math English Total Marks Result Raj 24 45 33 Neha 34. 48 23, Nitish 2 34 7 Amit 46 35 67 PUNJAB AND HARYANA HIGH COURT SPREADSHEET EXAM 2018 . I= 1. Draw the table in the spreadsheet as given in the question paper. Get the value of Total Marks of all the 3 Hindi, Math & English. Get the result by Appropriate Function Either Pass Or Fail ( Marks Obtained>=105 is passed and <105 is Fail) Marks the cells with Red Color who are fail. Draw a Row of the Maximum of the Total Marks by Formula. Align Column 1 to left and all others to centre. Bold the Font of 1* Column and Row. ey Nowe Scanned with CamScanner “PINUUOY UM LS Jeye euoud soud winwjulW ayy MOUS “seoiid auoyd [Ie JO |2}0} JO MO|eq MOJ Be MeIQ (JSS ‘20Ld) BO |2}OL JO ULUNJOO e MeIGQ "BDU JO %ZL DISH JO utunjoo e meiq “saded uojsenb uo se ajqe} e MeIG rao wo £4 OddO 005 Srv | 2 ainsi | [| ___ooose[ wast 1s) ad pucag DWE Wa B24 [E301 (8L0¢ WYX3 LASHS 139X3) LYNOD HDIH YWNVAHVH ONY S¥fNnd Scanned with CamScanner yoea ul juaupedap ino} | UPUETAD UNE FTAWSAVEED £4ews se “UOJ 0} 10]09 , Pa, PUe 2]qQe} 943 UI ,9N}g IY 1, 10]09 punos3y49eg aAIN “GS ul, 221s JO pue py azis Jaded ayes “by “seak Je 40 JeOY, “a"1 EjnWO Aq saadojdy jeJOL JO MOYyeMeIg “E ssueaA snoy ayQ je Ul yUaWedag Yea yo aBesaAe ejNWOY Aq aBesaAy JOuLUN|OIe MeIq *Z -seded uonsanb uo se ajqe} ayy Meg “T qunoasy asei9ay quawziedag 8102 LUNOD HOI UNYAUYH GNY @vINnd Scanned with CamScanner “MOY PUE ULUN}OD wT JO 3U04 B43 Plog *Z *943UD9 03 519430 [Je PUE 339] OFT ULUN]|OD UTIjy -g *ejnui0g Aq sys [2301 943 40 NXE 24340 Moye MeIg “¢ “[Ie} a4e oym sojo9 pay YIM sy |yI SEW “py (weds! cot> pue passed sj coT= cL aes 09 sot aseyaing | 42035 Sujuado | aaud yun | zyanpold wnpoig ‘syINpolg Scanned with CamScanner ¥ aUPEPUN pUE JUNOWY [e101 Jo |]29 43.03 40}02 punouByIeg aN "9 ,adeospuer, ‘CWON,, 03 uZiew Jaded pue ,SIW aporiuN jeliy,, 0} aweN UO ay} aSueyD “S 0} YORE WSO 42Ua} 0} Suayjo [Je Pue “TAUaLY,, 0} 12D JUNOWY 1230} YS] 0} ULNIOD -.7 'B xT JO JUaWUSIy aBueyD ue ZT 0} azZIs yuo aBUeYD “y yUNOUy [2}0} JO aBe% *a*| uONIUNS ayelsdosddy Aq juNoWy ajes JO aSeyuarJag a}ejNI/eD °E auay uaAld S@ MOJ YSE] aYI UI UNOWY [eJ01 aJeINIJe2 pue adtid X AYO “at ejnw404 Aq yuNOWY JO anjeA ayz 329 °Z Jaded uonsand ay) ul uanld se yaayspeauds ay3 ul aiqed ayy Meda ‘T junoUry 12301. 0007 o00r areas | anoaTras | — sons —[ ho [el eso Scanned with CamScanner Moy pue UWIN|OD ,,T JOJO aUy Pjog*Z 4a]UaD 0} SIBY}O [Ne PUe 3327 03 TULWN|OD UBIYy"9 ejnwu04 Aq sey lefor BY} JO WINWIXe YY BY} JO MOY e MeIG'S [fej a1e ym s0}09 pay yym saa ayy EW "Py ‘4 SI SOT> pue ssed SI GOT=< pauleyqo syseW)) [124 JO ssed sayy3 UONDUNY aeUdosddy Aq ynsay aur3129°E YsHBUZ 7B UIE ‘IPUIH € AU} [Ie JOSHEW [E}OL Jo aNjeA ayI399 7 daded uoysanb ayy ul uaaid se jaayspeads ay} U} 31Ge} ayy MeIg “T ee wnsay SEW [E1OL &z ut ysi13u3 Scanned with CamScanner JEWUON JO %08,, 0} SUIZIEWy aBed 43 325° a BU BES IAN JO WNWIXE JO Mole MeIg “9 (gunossig ysed — dong a]eS JAN) *a"| JUaWAeY JAN JO ULUN|OD e Ae1Q ‘S BDUd BIS JON JO %G‘A"! JUNODSIG YyseD jO ULIN}OS ay} meug “py JUNOISIG BpesL $0559] Bd BES "9 B2Ud BJESION JO UWNIOD 343 MeEIG'E BIAd BES JO YOT “31 JUNOISIG apesl JO UWN|OD JU} ANEIG ‘Z dadeguonsand ay} uy uaA!3 seyaayspeaids Uy ajqey ay} MeIG'T a ee ee ee ppnpoid 00zT epnpoig OOTT zpnpoid pF 0 rr] [wwowneavan | wunessaqse> | onasresien [iunesaspen | vases | pnpova | Scanned with CamScanner nd, BULU BY YW JOOGHIOM BY3 BAeS*Z dV, 8215 282d Pue ,ST,, 0} UIPIM ULUN|OD aBuey> "9 suonoung /sejnuo4 pasinbay ayy Suisn Aq sanjen ays Syeinsjed pue yaays uanid ay} ul payysyysiy se aSesany -g [e301 0} ,AdsO,, 10/09 punos3yeg aAID “Ss 4MOUEN,, 0} UIBIEW a3eg *adeospuey, 0} UOJeUaLO Jaded 32S “p MOUEN [EUY,, BWEN qUO4 pue PT, 2215 JUOY 437 UByy '}! PjOd ‘Bay UBAIT se a/W11 BAIT pue EON MOY JO SI]99 BY ATI" Jadeg uonsand ay} ul uanld se Z “ON UWIN|OD, hue €°OU Moy Woy aiqed Sy MEIG'Z yOOqyJOM |32x3 MaU eEUadO"T Scanned with CamScanner #1521 aYspeadds,, 0} J2aYSHO/M JO BweU ayy adueYD "ZL J2@BYSJOM BY} JO SaUI|PUD aU) apy pue Jays ay} UI Bday UAAIZ se age AY} 0} 49Ps0g IV ANID 9 .2de2spued, OJ UONeWUaO Jaded aBueyd pue 2481y 0} suNjod sayjO [Jy pue 1a}UaD 0} ULUN|OD pUOdaS ‘3337 OF UUINJOD yS4l4 JO 3x9} UBYY "Ss aPVn ACWION,, 0} 8215 g UIBIE YY Jadeg pue mos Buipedy }daoxa ,,0€, 0} }43I3H SMOy BY} aBueYD "py PINWO Aq adi [2301 YY JOLUNWIXeEW JO Mey e MeIQ"E suoipuny ayeudosddy Aq suwinjo yuelq ay} [Je JO SaNjeEA 34} 33H ‘7 Jadeg uoNsand ay} uj UaAId se yaayspeasds UI ajgeL By} mesg "T O00SZTT OOOOSTT PT 002 a anpora| La f fT __{ __} 0004 | wa2nporal [Sd.L+99id [E}OL)| 221d JEIOL BINd YUN JO | Bud Wun eyO1 pues JO%TOSIL | ud eIOL %S OSSI? | j9%BTO@1SD Scanned with CamScanner [.2718 148h, 03 40}09 punos3y2eg 843 aBUeYD "9 abl, 0} 8215 JUOY pue ,.y9e/g [eUy,, 0} Bde} UOJ a/qe? ay) aBUeYD “¢ WJO1d SSO1D PUE dd1g }SO} JO |eYO, *d*| E|NWUOY Aq adLJq AIES JO UUNJOD ay} MeIQ “by BI ISO} BYI JO %ET “a1 EINUUO} Aq WJOId SSOID JO UWNIOD ay Mesa "E sasuadxg uo}janposd pue pasn jewayew wey JO [e;OL ejnuws0} Aq e211 SOD yOUWNIOD ay} mesg "7 Jadeg uoNsany ay} ul UaAlS se 31qe} BY} meIG‘T OLb oez OSL 002 Wold sesuedxy ssoig uononpoid au3o1d 243919 43019 v4o19 pesn [euezeW mey yonpojd Scanned with CamScanner UO} 0} J0j09 ,,paJ,, PUe age} ay} UY ,,AN|q 148M, 10j0D punosBy2eg AID "9 abT, 21S OS Pue py azis4aded ayy yas"s sueaA snoy ay} JO yno UaWLedap UDe~A jo ejnUOY Aq saahojdwy WNWyUIW Jo ULUN|OD Mau e MeIG*p sea yrea ul sjuaWedap ino} By} {JE 40 Jeo! “a't EjnUIOY Aq saadAojdw je}o) jo MOY e MeIQ"E *[Link]} ay} [je Ul JUaWyedag Yea Jo aBesane “a'1 ejnuUO, Aq aBesaay JouwnNjoD e mesg TZ aadeg uoNsand Uo se ajgey ayy mesg “T saeAojdwyz IeVOL S | ? Ss z uH zy oP St SE ales syunosy Z 9 Z s uipy aBereny gt0z [____stoz vtoz €0z [| quewpedeg Scanned with CamScanner adedspuey 0} uoNequaO adeg a2 18S"9 yaayspeasds JO 63 wB MOY YD, "ON uwnjod uy Aas, J0]09 punosdyDeg |I14"S saea ino} ayy jy ul Auedwo> yreq jo adesaay * Bjnwjo4 Aq aBesany jo 4,6 Mol eMeIg “py “9T02 ener, BETO? PEO?’ ETOZ S4eaA snoy ayp |e U) AUedWOD YDea Jo [210] “2"1 BES [PO] JO WB MOY EMeIG “E @95"G’y Auedwios jo jexo1 ‘a"} ajes je1O1 yo 5 Uunjoo e mesg ‘Zz g ‘ON uuunjo5 pue ¢ “ON Moy WO. Jaayspeasds U! a/qGe} ay} YeIS “sadeg UONSANH UO se ajqey Mes “TL aseiaay JEIOL 8EZ COE 9toz Sze c9t stoz vez tLe vtoz 9st SET €t0z Bes [eIOL q Auedwo5 y Auedwo5 qeaA Scanned with CamScanner eynuzs0} Aq sazjJg sajes jo wnuwyuyW e MoYs “9 BIN BJS [eI0 JO MOjaq Mol e MeIg"S JYOsg SSO4D PUB |IIJq 4SOD JO 1230} B "3"! JO BDIJg JES Jo ULUNJOD eAVeIG “E BIg SOD JO %GZ © “a1 WOJg SS01D Jo uunjoo e mesg “Zz sadeg uonsanh uo se ajqey mesg “T [008 | paoatay ee a Add Scanned with CamScanner 2jnwso} Aq dL/g Je} JO WNWIXeW e Mays “9 @2|Jg JE} JO Mojaq Mos eB MeIg “S (GOHEHSIFSY ‘155 ‘aouesnsuy ‘a2}4g Woosmoys-xg) seD & j9 B21Jg [BIOL JO UUN|OI e MeIg “7 Bldg WOOIMOYS-xq UO %Q © aBseyD voResysiBay yo uwinjo2 e mesg “¢ BIg WOOIMOYS-xZ UO %BT @ “2! 1S5 JO uuNjo> e mesg “Z dadeg uoNsanh Uo se ajqey Meg ‘T ooosé Ipny 0006 e51pul 00ST 000005 wins agseyd Bag [2IO, =| UOIZe4ysIZdy is @oueinsu] PI lcs Scanned with CamScanner Total Time: 10 Minutes Total Marks: 10) Important Instructions: 1. All questions are compulsory 2. All questions carry equal marks (2 each), 3. No marks will be given for incomplete answer. seeeeee Q.1 Draw the following table in excel/spreadsheet: 1: 2; [3. Class History Economics 10+1 62 47 BALI 79 | 56 Be i 61 [35 BALM 78 [53 Q2 Q3 Qs Calculate the total number of students in each class, by inserting column no.4 in excel format in the table drawn under question no.1 Calculate the difference in number of History and Economics students in each class, by inserting column no.5 in excel format in the table drawn under question no.2, Redraw table on separate excel shect showing in descending order the number of Economics, Redraw table on separate excel sheet showing average of number of students in each class, Scanned with CamScanner “eoraquy WINUTTUNY put 20g Nog wnwireu sy) n> amBy puw wonoq oy Iv wos 7 Ppy SON 'O +ssoyjd peunoap ¢ dn ysog payoy, jo sandy ain odueuy = ON ‘[ysass:uy + 92g pNog) ‘WoO TOL WMI EON “O "poayooay 29,7 > MOD at} JO %ST @ysasoquy aweynsqey TON 0 [1002-S0-£0 | “‘Sunyeuuoy pue uonenjound ‘sSuyjads ‘sapsoq ‘wp 1UxI YEA I1qvI Supmoyoy amp awwsq = TON "O SwOLLsano "31q01 Bus ayy Ut UCP 3q OF 24D suoysanb yy sgamsup aj9jd inal 40 F2aLI09 Anand sof wan aq jen sysous Oy *sysnu Z fluwo suoysonb yy € c T SNOLLONEISNI Scanned with CamScanner “Ja}|4M JuaWpn! pue saydesTOua}s JO sased ay} paudije JoyU9d “31qey ay} Jo 97319 ayy a4jUaD pue dTiaw “494M JUaWpnI pue JaydesBouays jo sased |e jo DTeISAC *J9JJM yUaWpN! pue saydesdouays uo sased jo Wns “saded uoijsanb u; uaaia se ajqey e mesg | qyedipuey> eueAsey pue gefung yo NOD YBIH Se ajqed S14) aia). 09 | or | waro/jeuwy> l aapne suoissas Sr os yeulwi> | 1ovWw apni suoissas pue Rujseysiapunyy mayan roaneoreen| pUysIG |EUONIPPY 0s oz | Al | DIE 33M quawpny uo saydesBouays sase) adesaay fei0, | sase2joON UO sased JO "ON joady uno) joawen Nulw OT awn je101 Scanned with CamScanner ‘sy 0 yn Juud ey) 248) osj@ pue yauLIO} LONG U} WEL OY) YUM YOOMPOM oy) BABS “G “paunbas se si1e0 Jo inp pus yBIEY IsniPy “8 “YwaysYOM eAoge UI UOAIB se JepIOg BI8GID °L “sonjea asoin 196 0} Je0xe yo uoRoUNy ejeydoudde pesn pus (jeeysI0M BAOGe U! UMOYS: '88) sno} UBA/B 0} eBeseAy PUB |B} JO INoJOD punaubypeg oy) eBUEYD —g “pouBlny 1WSty (1189 pewseouce u) paiejue ep) seunBy pus peuBye do} pue equed y UUUNICD PUB s MOY JO WA}OD °S “peuBye equeD pus peupepun ‘ploq y eyeu pus p} 0} 6718 Uo} oy @BuBYD “y MoU Jo SISO ON OBIOWY “y “JPUy, 01 WEL WUO4 PUB Z), 0} 89 40 ONS UO} BBUEYD “E ueweunseou! UaAiB oy) 0} Bulpsccoe 40 JSULON, 0} uiBueW pue ederspuey 0} LONEIUEUO ‘yy, 0} OzIS Weded Jes “JOKg JO YOoqON Meu Usd *E 90% “SW Bujsn yoysiom exoge oun uBjsep 01 BABY NOK ‘sdeys UeAIB eA BuyMo[IO) Ag Scanned with CamScanner [Name [VourName [TT [ 89} Hen Challengers Bangalore [182] 99 s XI Punjab [76 92 a tart “Microsoft " program and open new worksheet. inter your Name and Roll Number in first two rows of the Worksheet as shown. below. Enter the rest of the content as per instruction below in the same cells. 3. Format the cells such that the Text size is 11, Font is Times New Roman for all the cells. The Title row (4) should be Bold, Italiced and Underlined with Font size 14 Merge and centre the cells in the Title row, so that the Title appears as shown above. The Table Heading’s row (5) should be either Left or Centre or Right aligned as shown above. 4. Create the border only for the cells that have a solid line shown above. 5. Use appropriate Formulae to calculate the following and populate the shaded cells shown above: # Find Lost: Absolute Increase/Decrease from Values of Column B to Column C for each parameter with proper sign. # Win Percentage (upto 2 decimal places) w.r.t. Value of Column B for each Parameter and # Lost Percentage (upto 3 decimal places) w.r.t. Value of Column B for each Parameter. Insert a Header for the page with [file path] on left hand comer and Footer with &[Time]/&[Date] on right hand comer. Take a print of the XLS Worksheet that you have created as per design/data shown above on a single Ad Page and put your signature adjacent to your printed Name with Current Date. Scanned with CamScanner 48300} UJ OU |jOJ pue aweU Pasuy'g| 6T Japeay U! Bw) *Z aep JuauN‘yyed ally UASUI'Z | ST aseasap/aseasou! % pue aseaap/aseaou! anjosge pul SejnUUOy ayeudosdde BulAjdde Ag’9| ZT 2 pause ya] JO ys! ‘asyUa2 ¢ Mos Jo sBuIpeay ayew's OF & paudije asjuao’pauypapun ‘31Je}! ‘pjog’,UeWO Mau Saw}, JUOJ ‘OT A215 JUD} ‘y MOJ 40 SI]a2 BY BBIEW'y ST & PBUEPJBA JUOJ PUE ZT S]{]S9 OU} [jE JO BZIS JUOS SY SREW'E HT = J@dYS BUY Ul LEWOY UBAIT aU} Jad Se OU ||Os pue BWeU INOA adAL'Z ET ZB yooqysom mau e uado'T| ZT 5 iw? [or 6 EINNIAIY 8 [ovate [seety Z3ANSARY LZ [cozee [ezoez T3NN3A3Y 9 asvau30) 3Sv3¥930 ($3¥0uD| (S3HOUD| SURISWWUVd S /ASWAYONI| /3SV3YDNI| —NI)ZTOZ-9TOZ| _—_NI)9TOZ-StOZ 4AN39Y3d| 3LNIOSEV| NI NOILIZTIOD) NI NOMD3TIOD| NOILD3TIOD JNN3AIU- VLVG v = ou [jor inoA ONTIOW! Z~ dweusnoA 3IWYN iT See eer a a any “SMeW OU3Z PapEMe aq IM NOA snip PUE payoafas Ayewuuns aq jan ‘ayeq uaUMpUeH pue asnjeUsis UayUmpueH ‘OWEN “saquuny jou 1991409 ynoym noqud Y2AYHIOM S1X P3S!>A—KG -3LON BSVITA “6 saveid ayeudoidde ye ynoquyd au sno yeu aunsua aseaid "Ino} ‘ayajduo9 yyva aueU aly 24 jp Buneadde osje ase ‘owen, 10 ayqysia axe ‘awn pue ayep umoys eep/uisap Jad se pay “saus0> puet 481s uo (area) 8/foULL)S ue s2us09 puey yal uo [uned ajy] yumm afled au 304 sapeaH © J2qWAN [OW INOA jt 8-2 saquune {joy snOA Aq pamo} +3 doyysaq pauljsse sno uo 3 anes ‘anoge uMoUs se 204s410m atp Buyedasd J2yy "9 rm aseaiz0q/aseo1 “ufis sodoud yw \ype2 40} 3 uuunjo9 01 @ uusnjo9 jo sanjeA woH asea;D9q/a5e0s0U ‘anoge UMOYS. neo 03 aejnusoy ayeydoudde asn"s “sarauesed 1peo 10} g uUuN|o9 Jo an|en ‘19 papeys ay) aye;ndod pue Suymoyoy 249 -anoqe umous auy jos & aney yeu S119 atN 40} AUO J9ps04 aun a1e949"y “anoge umoys se piog pue pau ‘jae aU “ane jap pue 08:0 ‘vt ny 40 U9 40.47 sous se sueadde af uog uae parted iw 104°ZT 51 ANS YOL UN YE YS 599 aUN YEWIOS"E 1d se quaquo9 au Jo 1594 atp 491Ua “MOFeq 2quUNN jou pue aWweN sNOA 49}U3 °Z “ypaysiiom mau uado pue wesBoid ,(20x3 YosOIN,, HEIST EE srsorsy fecsee eg Tene] [ swcieoe losvzs"ae. poo. fexeso'ee, isz0s9'se. we esve1seq| osve:soq] (seedny ui)} —_(seedny wi} Jesvaioul} jeseesou loz] 610-8102) waLaWavd| eGejueoied| oinjosqy| seo, jeloueuts} see4 jeroueUts| —esad B jo SSO ‘ON TOS ‘WEN INO) ewen| Scanned with CamScanner

You might also like