{ Exp No: ] TITLE: TIME TABLE pe Pim. To acak your closs ime Jove by esting different * Remating styler in excel’ Procedure - Step i- Opn feel om your computes Step 2- Open O new eworktpok by stecting Bile” 5 "New" {"Blont Document: Step3- Label the lest colar with the doys SF the week late! the Ai ww itn time slot anc paiods Skpu- Bil ow the cells with the concsponding subject om Ecivitiness Br cach day and Ame sot: Skps- Adjust the Baretting of cells, such ay tect al'gnments A site, and ell borders for clorty Skepe- OF neeckec! merge cells areal space @& headew or hightght specific days or tires Step q- 449 Colours to Cinsfingach befuxen ot Rent Subject or hightght specific cays of tyres. Steps ed any actehtional details or not, (ike Clarsroom nombes or special Mnetoction Step O- Saye your fimelabe by Selectin ‘Bets Save as and Choos a focation on your comput.— Exp No: TITLE: : | | Date: ] — OvTPo T- — ane ae ——, ‘ G-PULLA REDDY ENGINEERING COLLEGE \ ’ TIME TABLE TR T-BTECH SEMESTER | sports | Yooh EPP ICH? 4 E = z Q © 2 7 RB > ™ DvD 7 nr[Bee No: [7m MpREs SueeT Date: | fam= & cicak a marks eheet fOr jo students osing EXCEL Steps- b Open ME-EXCEL by clicking 07 START Button gp to Program Then selecd Micrsolt offic i Then click of Micwostt office i Lxcel_ It be tonite the HR name. GRulle Redldly Engincervy College B Wile He Sub title name wo TBkech tT Masks sheet ¢ ye Now tat The requirements Aeleie & calculation ©! marks, like SNe, #F No, Subjects, Guard folal ancl © percentage fam 3 4 Og celle oF fllotas- M-t} MM cro] E NE fue AB cell addicese? and He TRIO lono | #TNo-] Eno ci 5s sk Sry fom 1-2 16 form Bu BIZ G& Now enter The marke in Cy- Mita Cet! addressee Mow in the G:Total cell select Nu cell and apply the 2 Bernute Pr adldirg The marks gantdined in Cys My Cell Oddesses in he formule. bar oy Za Si- sum (Cur my) ter press key. @. Select Me Ny cet! are drag es down Re Lrthen students calculations: q, now caleslate the Percentage for frat select a, cell and type I. calculation formule 1 formula bat ay 4+ Ke [ooo ¥ [0% ‘©{ Exp No: TITLE: i [ Date: 1 Sdect the O cell and drag towards down & Rrtrer etuclentc reat fe We Naw the *% appeoss im denimal valud, nowt orda 4 appeas Ne value af rounded yolug select the O% cell trey Font click the mouse buttoy select Prmat celly ten 12 Numbers and me Make decimal places fe Zee then Click OL 13 Now ogain crag fr other cell values to be rurdto! ly low fr keeping the berdas ,Selecl ety fom fi1-OR anef Select all Bordas on Tre home Menu. \6. Now for savirg chick ef OFFICE button and etch 04 Sove ard type Fle name as * Male Sheet” , then click OK. a aG-PULLA REDDY ENGINEERING COLLEGE CPetonomos) I-Tech \T MARES SHEET . +— = — +t oe t | ELE lay cp or Etc Tory, | SNe He TeNo ENG pay CHE MMM | cPps ED we 5 ue f | || PBOKIPOSOH) Te |r | Sy | CC }8O} GF) RC | 43 » | Tale ue a5 la ‘g3axiNoso? | G2 (ee | [ue |G0| ce] 90 | 69 — Fl |e C1 iG? ca] +—______— aa e ph 4 —— 3 a3axiPo503 52/62 63/49 78/58/94 a ee 5855 eo Fri H L g3aKiNo5ok | 72 . 4. —— 43 | 5t) bt 6 oe 5 | a3axthoses 7c niaz. + i 63 5F) G 3010 6s 84 3 Gor Co. irl | TT —o cae © jagaxwposoe 7 65 29/49 La © | 3! Lee eu lot sq 5e5 St! 4 (239K i NoS oA 54 | 65 +h alee] a2| 56167 (csq| 69) 2 3Ax(NOTOS Fo 85 go be | 7 99 |99 | HH ; 4 | ce "| 33 | | 994 )79 | 9 |azar hosed | i jo 23% NASI: | [ammr: ATTENDANCE SHEET ‘| [oa Pim Rep ct Repare attendance greet With solary of emplaye UY MS. excels in, Procecture- Skp (- Open Microsoft Excel 07 gour Computers Skep2- Label ed umes with headers *mploye Name” "Date", *Atendaree *, & "Solosy'. Steps List employee NOMS fe 2 eres ro dum: Stepe- 2 the “Dak! &*Attencleurce* done mark eoch coy os * present” or * Nosent, sepe- tn are “salosy' colony, use the Srmulo lade = Count (= +p Daly Rate Replace * Daily Role” with your ocbol dilly Salasy: Stepe- Sh tne solary ‘color’ use a fomula Nee» sum (p23) © get total salary Rr coch employee Adhust ‘he rarge pared on your clate: sepa fort Me *slany” earn a cuneny Rs rok appeasance - Right click Select “formal cellr* arc noose Te Cwnrenay forme Sep 8- Use condifono! famoltas” to highlight attendance tou Rr instance cel wih ‘maser! oui be coleret diferent. srepa- Check Br adjusting ory fomuleg- Save pur sheet ond eatt ii fer Onl miomee“GRADE SWEET Pime IS create 0 Grace sheet of Stich Using MS Exec! \s Open Excel Launch Excel and create Ore Spiced sheet 2+ Enler Student Petoile- Th column A, enter * Studert Nome” in cell Meter the names of Student’ w cells Ar, AS Ane! H on os Neeclec| Sr Ente Scores Dn column RB, enkr "Store" tr cell Gr Th put the scores achieved by coch student in cel bela> ke Coleulate Grodes- Label next cet! os "Grade", By using The Brute. Pye OPC tol > F0, "0%, PPC Tot 270, #8", FF CBI reo, "C', PF (mt 4o'D! —5 Now Select the lest Colamn andl drog Chenved: all Students results - > cicale wula to fermel celle based! on each grade coreyery using fren All color oF ft cols: oS 5: Sore your fe- Go to Ace button ard click on save a option ond ge the fie on approprcle fle Wene anet Sate he excel Chect 4 keep all entered date formulcr and forrnetinng jatock——"— rc sp No: TITLE: Dates STUDENT GRADE SHEET Name [ENG | M-l [HINDI goc | TEL | OMore {rs fAinshu | 58 | G5 | 81 Gindv | 99 las 59 BeBene | [me spptapsuter Fir To Create a spreadsheet Gr gales ime with Go tn Excel lovalver orgamzing date. with columns fr Tem ate tate, perce, ard Calculating GST Procedure & Glomn Heedings Set up columnar Re details Ike km Name ttm Code, Quantity , Price po Unit, Toral Price , GST Rate, GST Amant and Grand Btol o. Enter thm Petatis- Onput Me Specific details of cach item we cones poreling, wos 3. Coloulating otc! Price- Multiply the Soanthy by Pre pes vorit db ga The “Toto! Price fer each tem. Use a Saute hke = Quanttly « Piite per unit wn Total Paice coum. we GET Calculations. Enter the GST vate applicable to each aiem:. Calculalc @ST amound fr each Mem using 0 Rearule. like = Cotal Price # AST Rate) fio + Ths formule Mlaidata GST amount based on tal price are get rate 5+ Calculate Grand Tolat- Sv up We ttal price column bo ge the subbtel - Then sum op he G7 Frrewnt cobmn to get the foal GST Finally, add Subtotal ane! foto! ast $e get Graved Aol, 6 formatting. formed cells to dispey Carvey Symbols, number Brmats, arc! ensue proper Alignment Br Clasity - By Stucturing your bxce! SPrcad sheet Tic Way, You can eflectiely Create a sales Theme (lt with 8 Caleatatione an Excet. | 7SALES ITEMS IN GST