Partial preview of the text
Download computer science and more and more Summaries Computer science in PDF only on Docsity!
BASIC EXCEL FORMULAS — PART 1 S.No Formula Name Formula Pattern 1 SUM = SUM(A1:A5) 2 SUM = (A1+A2+A3+A4+A5) 3 SUM = (45+2+43+43) 4 PRODUCT = PRODUCT(F1:F2) 5 PRODUCT = (B3B4 B5) 6 SUBTRACT/MINUS | =(E3-E4) 7 DIVIDE = (F3/F4) 9 PERCENTAGE = (G3/G4*100) | 10 MAXIMUM = MAX(H3:M3) y 11 MINIMUM = MIN(H3:M3) ae ShikhiLab by M. Hasan oS —c ow i a NYE Ms word ka shortcut eA MS Word Shortcut Keys (No Column rormat): Ctrl + N-—New Document Ctrl + O- Open Document Ctrl + S —-Save Document Ctrl + P— Print Document Ctrl + C-— Copy Ctrl + X—Cut Ctrl + V - Paste Cinl+Z-Undo —— {=| 3 Ctrl + Y —Redo Ctrl + A-Select All =) Ctrl + F - Find Ctrl + H—- Replace Ctrl + B- Bold (ff 7 Ctrl + | - Italic (@ Ctrl + U—Underline Ctrl + U- Align Left Ctrl + E-Center Align Ctrl + R—- Align Right Ctrl + J — Justify Text Ctrl + K—- Insert Hyperlink Ctrl + M - Increase Indent Ctrl + Shift + M— Decrease Indent Ctrl + T — Hanging Indent Ctrl + Q —Remove Paragraph Formatting Ctrl + Shift + N- Normal Style Ctrl + Enter — Page Break Ctrl + Shift + > —- Increase Font Size Ctrl + Shift + <— Decrease Font Size Ctrl + | -— Increase Font Size by 1 Ctrl + |-— Decrease Font Size by 1 Ctrl + Spacebar — Remove Formatting Ctrl + Shift + D —- Double Underline Ctrl + Shift + W — Underline Words Only Ctrl + Shift + A — All Capital Letters Ctrl + Home — Move to Start of Document Ctrl + End — Move to End of Document Microsoft Word 2025 Shortcut Keys Cheat Sheet New Document CtrleN Cut Ctrl +X Open Document Ctrl+0 Copy Ctrl+C Save Ctrles Paste Ctrlev Save As F2 Undo Curl +2 Print CtrleP Redo Ctrl+¥ Close Document Ctrl W WIM Select All CtrleA Exit Word Alt + F4 x Find Curler Q Navigation and Views WW Replace Ctrl+H Move to Beginning of Line Home GoTo CtrleG Move to Ende tn F Move to Beginning of Document = Ctrl ¢ Home Bold Ctrl+B Move to End of Document Ctrl ¢ End % Nahe Ctrlet Switch Between Documents Ctrl + F6 7) Underline Ctrle+U Split Document Window Alt+ Ctrles el Subscript Ctree Toggle Navigation Pane Curl + F a Superscript Ctrl + Shift + + Full Screen Read Mode Alt + W,F ie] increase Font Size curt + shitty W@ Tables and Lists ME Decrease Font Size Ctrl + Shi Insert Table Alt+N,T 0) Clear Formatting Ctrl + Sp y Move to Next Cell (Table) Tab U Change Case Shift + F3 Move to Previous Cell Shift + Tab Xx B Paragraph Formatting Add Row Below Tab at last column Ww Align Left Ctrlek Select Row Shift + Spacebar Align Center Ctrl+E Select Column Ctrl ¢ Spacebar Ye Align Right Cte R Insert Bullet List Ctrl + Shift +L Justify Ctrles Increase List Level Tab Line Spacing (Single) Ctrl+ 1 4 S Y S Occrease List Level Shift + Tab Line Spacing (Double) Ctrl +2 Une spacing cules Spell Check f7 Increase Indent Ctrl+M Thesaurus Shift + F7 Decrease Indent Ctrl + Shift +h, Show/Hide Comments Pane Alt+R,C,P Copilot Al Assistant Alt + Q (or Ctrl G7 Accept Track Change Ctrl + Shift +E Loop Components Integration Available via Insert Tab Toggle Track Changes Ctrl + Shift + E Dictation Alt +" (backtic * Insert Footnote Alt + Ctrl + F Translator Ah¢T Insert Endnote Alt + Ctrl + D Focus Mode Alte V,U Anat he U ALY CamScanner EXCEL FORMULAS SUM =SUM(10,20,30) SUMIF =SUMIF(A1:A10,F1,C1:C10) COUNT =COUNT(4,"a","b") COUNTA =COUNTA(4,"a","b") ; ' UNTIF{A1:A10,">100") ceca ISNUMBER | =ISNUMBER(1) ISTEXT =ISTEXT("apple") ; =IF(10>20,"TRUE"," FALSE") LOOKUP *LOOKUP(80,{50;60;70;80;90),{"E";"D";"C";"B";"A"}) VLOOKUP =VLOOKUP("A",{"B",2;"0",5;"A",3},2, FALSE) One =HLOOKUP("C™{"A","B","C","0";25,10,40,35),2,F/ ir rae MATCH =MATCH("E",{"2","Q","U","X","¥","E","B"}, CONVERT =CONVERT(132,"Ibm","kg") TOCOL =TOCOL({"A","B","C";"D","E","F";"G","H", "1" TOROW =TOROW({"A","B","C";"D","E","F";"G","H","s CONCAT =CONCAT("A","B","C") aya TEXTJOIN =TEXTJOIN(", ",TRUE,1,2,3) each NOW =NOW() TODAY =TODAY() DAYTODAY =DAY(TODAY()) | MONTHTODAY YEARTODAY =YEAR(TODAY()) WEEKNUM =WEEKNUM("20-Apr-2025") — Oe SEZ Windows Basics: Keyboard Shortcuts "moose sts 2 88 5 = 2 Ctri+A Select Al +8 Highlight the Notification Area Ctri+C Copy Selected Item +O Snow Desktop m+eE Open File Explorer Ctri+F Find Text/ttem +! Open Windows Settings me+L Lock the computer PrtScr PrtSer Take screenshot and Copy it to the clipboard N Ctri+N New Window @) Ctri+O Open a file P Ctri +P Print options +O Open Search +R Run Ctri+S Save File Ctri+V Paste Selectod Item Ctri+X Cut Selected item Ctri+¥ Redo an Action Ctri+Z Ungo an Action ff - 8-8 8 8 8° ALT TAB FI F4 FS ESC ESC DEL Alt + Esc Switch between applications on taskbar Alt + Tab Switch between Open Apps Fl Universal help F2 Rename the Selected Item F3 Search for a File o- Sale in Explorer y, i} Alt +F4 C Exit the Active FS Refresh Ctrl + Shift yy Open Task Mi oJ “6,393 Esc Stop the current @ Shift + Del Delete programs PBrGently ics] CamScanner Computer Shortcuts Keys . ‘SHORT! AMoF File mesy cotions in cutest program ANOE Ect options hn current proga FY Universal help flor ail programs) CirleaA Select at text Cirle X Cul se’ected tom Satie Del Cut se'ected tem Cec Copy selected tem Cidetns Copy selected tom Cirle V Paste Seitelns Paste Home Go to beginning of coment ine Cirle Home Go to beginning of cocument End Go to rd of currert fine Cirle End = Go to ord of cocumart Nit ¢ Home Hehight ton aurert poston to bagenirg of low SNM + End Highlight hom curent positon b endef lee Cirle e Mowe one word to ie le at a tere Cirle -* Mowe ene word Io the nate at a time TCUT KEYS” Ate Tad Seach Ditwoen open anctcatons Ate ‘Serch dackmards betwee ope SN + Tab = Pret Create screen shet for cumert program Cate At + Del Reboot Windows” task manager CirleEse = Béngupstatmeu AteEse — Swich Denwotm applications on taskbar Fz Rename selected con FR Start fied trom desktop Fs Chen the dewe selection whan browsing FS Robesh cortents ANeFa — Close cones open progean Cris Fs Close window in progam Cirle Pass Automatically acjust wicths of al cotumes Key in Wedons Explores AN sErter Open properties wincow of selected kon oF progeas SNM + FIO Simuate rehtcich on selected tem Srits Del Delete programs ties perranentiy Hotding SBR Dering Bootep Boot sate mode er bypass sysiem fles Holding St When putting in an ade CO, wil prevent Durlng Boots CD Player trom playing EY SHORTC WINKEY ¢D Bring desea to the top ef oer windows: WINKEY eM Maimize afl windows WINKEY ¢ Unde the maize done by WINKEY « M ‘SHIFT o Mt and WINKEY «D WINKEY +E © Open Moroso Expirer WINKEY ¢ Tab Cycle Brough open programs on taskbar WINKEY oF Display the Wirdows’ SearcFird feature WINKEY & CIRLeF Ossplay tho soarch fer computers window Wane Ft Display the Mcroso'’ Windows’ help WILEY, Open he rn window seep Oper Ie system prope es window Wink Open silty manazer WINKEY ok Lock the computer (Windows XP" & later) Cita Cite B Cwiec Crt eX Ctien Cre 0 Cite P Cite F Cute! Cute K CuteU Cite Vv Cue Cwtsz CuteG CtteH Ctied Cutek Cwied Cwiek Cute R Cre Cite T Cited Ctl + Shit o F Cote Shit +> Ctte] Cots Shine Cutet Cuts Shite* Chee Cite Cust Cited Ctrl + Del (Cote Backspace Ct + End Ct + Home Ctrl + Space Citet Cie? Cites Cite Anet Cite Ale? CideAne3 a] ShR+ FR ‘SIM « Insert Fe ShR «FT Fiz Cities Sth o FIZ Alte Shite D Ane SING T Cole WW Solect al corteets of tho pago Bold Nehignted selection Copy selected text Oct selected text Opes newtblank document Oper options Opes the print window Opes fied box haticze highighted selecica Insect ik Uneering hgnigned retecton Paste Resco the tast action pertormad Undo last action Fied ard replace options Find ard reptace options Jatt paragy a algrrest ‘Alg” selected text or ine to the let Aig” selected parageach to the loft Align selected text or line to the center ‘Align selected text or ling to the ght legend the paragragh Hanging indent Fort optors Change the font Incroase selected fort +1 Inorpase se'ected fort «1 Decrease selected font -1 Decrease selected font -1 View or hie noa printing characters Mowe one word to the leit Mowe one word to the right Move Ip beginning cl fe tee or paragragh Move lo th end cf the parageagh Delete word to ght of curser Delete wrced to le of cursor Move curse: to end of document Move curso to beginning of docsent Reset highighted tert to detaut font _ Eos the selected cel 5 Go toa spectic cel zd Spel ches: ve'ected text andor Cou tert Fat Create chat Cet e Srtte; Enter the cunent ime Cite; Enter the current cate Ane Sh + FI Inset mow wotestoet Shite FI Open the Excet” fornufa window She FS Bring up search bee Ciel Select ail contests cf worwheet Cri B Bold hoblighted selector Ciriel hatore hghighted sefectcn Curie C CuleV Cirle d Cute K CrieF CuteG Crise CrieU Crie¥ Cries Cre Cute N Cite P CrleS CrieZ Cirle FS Cirle FIC Crrl + FE Cet « Page up 6 Page Goan Ctrl « Tab Aes Ctrte* Cite Samet Chto Suto Cit Shites Cele She Cite Satte* Format nunber hn scentic tomet Crle Shite @ Fonrat rurber hime treat Crhe > Move to next section of” Cirle Space Select entire cotusn Shit ¢ Space Select entre row Cie W Cosa docurert = Send te email Cite c Copy selected text Cie X Cut selected tex! CrleP Opt pret daieg tor Cute K Complete aameonal ty voor CtrieB Ctrlel Cite U CrieR CrieF CtrleN Cots Sritte A Create a now aopoinarent you calexcar Ott « Sait Open te ouder 7 ie Cite Sate! Open te index Cite Sate K Agé a now task Cite Same C Create a new conmact Cite Satie) Create a now journal ent y CamScanner Ctrl Shift F3 Ctrl Alt U Ctrl Shift $ Ctrl Shift % Ctrl Shift * Ctrl Shift ! Ctrl Shift # Ctrl Shift @ Ctrl Shift Cc Ctrl Alt F11 $F CEC LIVGIs Create (Name Manager) Toggle Outline Symbols Apply Currency Format Apply Percentage Format Apply Exponential Format Apply Date Format ApplyTime Format Copy Formatting Open VBA Editor Alt Alt Alt Alt Alt Alt Alt Alt Alt Alt G$ELCTEILIIGIY Insert PivotTable Sort Dialog Box Text to Columns Remove Duplicates Data Validation Filter Freeze Panes Insert Chart Insert Table Insert Picture ICS} CamScanner Copyeent Joan Amo Excel Shortcuts Cheat Sheet Save This Post: Your Go-To Excel Shortcuts Reference 9 + QUICK & EASY Edit celts @ Fix telerences @ Rocalcuate worksheet fa Go to dialogue box 15] Create table [cet FT] Copy | cot | C] Or OG Paste ow Select all 0 Save workbook os New workbook og Underline og Open workbook 0 Print workbook oa Find [cet Undo 12 Fado ig Bold | cet PB] hac Ooo Autosum wa PASTE SPECIAL Format paeTHi vir} Values pantiiviv] Transpose woo Prcrme wovog Formate wOoua Paste speatdabge §=§ CO EO Pastecommentynotes FI GOO Poems FIG Paste function into fornia | shat 3 F3] CELL FORMATTING Remove grdines Open cell dialogue box Applies borders to cells Change cell color Align left Align center Aign right ign top Align maidie Align bottom Add fier Wrap text Ungroup cells Groun cells Donnload this infographic inhigh resolution 4 SSS G THE ESSENTIALS BOVE ww pwrenvasonrecet CIS CID tighightcats 8 GROG — krezepores woe GJOBSG = Moewds | Cot [=f cot TS) GB —seecrerop downs wa BBIOGS = ssetroniccsem Oo WOOD = sextenicrow sot J sac GPO OO - saectentre corm ac GPOGO — reathopace @WoOooe uw @Woeea Ungroup cells OBS = reredipicates Ray GOOD eseatcers 7 mooo Create fiter GOOD crarcenintons OOOO § covcets GOOG wefrenme @wooo0 1 Cat sit] 3] WOIQ = wescommenteets FIO GRO M 3 wresraneshds FART BVO — eetatates workbook Qwa GEVON «= Toes forrmta bar | cot [seen fu] GVO — reves workbook window Cc a | CVOD es Format cots Ca. 4 EVO = Forwtplanten ct eet) EVER etsbor CIEs@ BOD *Kayforsanpe OSs CVD G -SMetsertrenctisreet EIT DB EME fulscren co .0 (&} CamScanner Ctrl Shift Ctrl Shift Ctrl Shift Ctrl Shift Ctrl Shift Ctrl Shift Ctrl Shift —<@ Insert Current Tin —> Add Border —> Apply Filter ray ‘y —> Unhide —> Unhide Colum <= Select Cells Left <=> Select Cells °*ht 
