SOME IMPORTANT FORMULA OF WORD & EXCEL AND USE OF BOTTOM F1 TP F12 & ALSO WIN KEY

Shiben
13 May, 2025
Excel & Word Formula Reference with Windows Keys

Excel & Word Formula Reference with Windows Keys

Excel Formulas

Math Formulas

FormulaDescriptionExample
=SUM(A1:A10)Adds all numbers in range=SUM(A1:A10)
=AVERAGE(A1:A10)Average of numbers=AVERAGE(A1:A10)
=MAX(A1:A10)Maximum value=MAX(A1:A10)
=MIN(A1:A10)Minimum value=MIN(A1:A10)
=ROUND(A1,2)Rounds to 2 decimals=ROUND(3.14159,2) → 3.14
=MOD(A1,3)Remainder after division=MOD(10,3) → 1

Text Formulas

FormulaDescriptionExample
=CONCAT(A1,B1)Combines text=CONCAT("Hello","World")
=LEFT(A1,5)First 5 characters=LEFT("Microsoft",5) → "Micro"
=RIGHT(A1,3)Last 3 characters=RIGHT("Microsoft",3) → "oft"
=MID(A1,2,4)4 chars from position 2=MID("Microsoft",2,4) → "icro"
=LEN(A1)Length of text=LEN("Excel") → 5
=TRIM(A1)Removes extra spaces=TRIM(" Excel ")

Logical Formulas

FormulaDescriptionExample
=IF(A1>10,"Yes","No")Conditional check=IF(A1>10,"Big","Small")
=AND(A1>10,B1<5)Logical AND=AND(TRUE,FALSE) → FALSE
=OR(A1>10,B1<5)Logical OR=OR(TRUE,FALSE) → TRUE
=NOT(A1)Logical NOT=NOT(TRUE) → FALSE
=IFERROR(A1/B1,"Error")Error handling=IFERROR(1/0,"Error") → "Error"

Lookup Formulas

FormulaDescriptionExample
=VLOOKUP(A1,B1:C10,2,FALSE)Vertical lookupLooks up A1 in B column
=HLOOKUP(A1,B1:Z1,2,FALSE)Horizontal lookupLooks up A1 in row 1
=INDEX(A1:C10,2,3)Returns cell at row 2, col 3=INDEX(A1:C10,2,3) → C2
=MATCH(A1,B1:B10,0)Position of A1 in B1:B10=MATCH("Apple",B1:B10,0)
=XLOOKUP(A1,B1:B10,C1:C10)Modern lookup (Excel 365)Replaces VLOOKUP

Date/Time Formulas

FormulaDescriptionExample
=TODAY()Current dateReturns today's date
=NOW()Current date/timeReturns now
=DATE(2023,12,31)Creates date=DATE(2023,12,31)
=DATEDIF(A1,B1,"d")Days between dates=DATEDIF(start,end,"d")
=EOMONTH(A1,0)End of month=EOMONTH("1/15/2023",0)
=WORKDAY(A1,10)Add workdaysSkips weekends

Financial Formulas

FormulaDescriptionExample
=PMT(rate,nper,pv)Loan payment=PMT(5%/12,60,20000)
=FV(rate,nper,pmt)Future value=FV(5%/12,60,-200)
=PV(rate,nper,pmt)Present value=PV(5%/12,60,-200)
=RATE(nper,pmt,pv)Interest rate=RATE(60,-200,10000)
=NPV(rate,values)Net present value=NPV(5%,B1:B10)

Word Field Codes (Formulas)

Basic Field Codes

Field CodeDescriptionUsage
{ DATE }Current dateInsert → Quick Parts → Field → Date
{ TIME }Current timeInsert → Quick Parts → Field → Time
{ PAGE }Page numberInsert → Page Number
{ NUMPAGES }Total pagesOften used in headers/footers
{ TOC }Table of contentsReferences → Table of Contents
{ INDEX }IndexReferences → Insert Index

Calculation Field Codes

Field CodeDescriptionExample
{ =A1+B1 }Adds valuesIn table cells
{ =SUM(ABOVE) }Sums above cellsAt bottom of column
{ =AVERAGE(LEFT) }Average of left cellsIn table row
{ =PRODUCT(B2:D2) }Multiplies cellsFor totals
{ =MAX(ABOVE) }Maximum valueIn column
{ =MIN(ABOVE) }Minimum valueIn column

Document Automation

Field CodeDescriptionUsage
{ IF { MERGEFIELD Gender } = "M" "Mr." "Ms." }Conditional textMail merge
{ REF BookmarkName }Reference to bookmarkInsert → Bookmark
{ STYLEREF "Heading 1" }Current heading textHeaders/footers
{ SEQ Figure }Sequence numberFigure numbering
{ INCLUDETEXT "C:\\file.docx" }Include other documentFor templates

Function Keys in Excel & Word (F1-F12)

Excel Function Keys

KeyFunctionWith ShiftWith Ctrl
F1HelpNew chart sheetInsert new worksheet
F2Edit cellSave AsPrint Preview
F3Paste namePaste functionDefine name
F4Repeat last actionFind nextClose Excel
F5Go ToDisplay Find dialogRestore window size
F6Next panePrevious paneNext workbook window
F7Spell checkMove windowAdd to dictionary
F8Extend selectionResize windowMacro dialog
F9Calculate worksheetsCalculate workbookMinimize workbook
F10Show key tipsMaximize windowShortcut menu
F11New chartNew worksheetVB Editor
F12Save AsSaveOpen

Word Function Keys

KeyFunctionWith ShiftWith Ctrl
F1HelpContext helpTask pane
F2Move textCopy textPrint Preview
F3AutoTextChange caseDefine AutoText
F4Repeat last actionRepeat FindClose window
F5Find and ReplaceGo ToRestore window
F6Next panePrevious paneNext window
F7Spell checkThesaurusResearch pane
F8Extend selectionShrink selectionMacro dialog
F9Update fieldsSwitch field codesInsert field
F10Show key tipsMaximize windowShortcut menu
F11Next fieldPrevious fieldVB Editor
F12Save AsSaveOpen

Windows Key Shortcuts

General Windows Shortcuts

ShortcutFunction
Win + DShow desktop (minimize all windows)
Win + EOpen File Explorer
Win + IOpen Settings
Win + LLock your computer
Win + MMinimize all windows
Win + ROpen Run dialog
Win + SOpen Search
Win + TabOpen Task View
Win + ,Peek at desktop
Win + +Zoom in with Magnifier
Win + -Zoom out with Magnifier
Win + PrtScTake screenshot and save

Window Management Shortcuts

ShortcutFunction
Win + ↑Maximize window
Win + ↓Minimize/Restore window
Win + ←Snap window to left
Win + →Snap window to right
Win + Shift + ←/→Move window to another monitor
Win + HomeMinimize all except active window
Win + Shift + ↑Stretch window to top/bottom of screen
Win + Shift + ↓Restore/minimize vertical size
Win + Ctrl + DCreate new virtual desktop
Win + Ctrl + ←/→Switch between virtual desktops
Win + Ctrl + F4Close current virtual desktop

Application Shortcuts

ShortcutFunction
Win + AOpen Action Center
Win + BFocus on notification area
Win + COpen Cortana (speech recognition)
Win + FOpen Feedback Hub
Win + GOpen Game Bar
Win + HOpen dictation feature
Win + KOpen Connect quick action
Win + OLock device orientation
Win + POpen Project settings
Win + TCycle through taskbar apps
Win + UOpen Ease of Access Center
Win + VOpen Clipboard history
Win + XOpen Quick Link menu
Win + ZShow commands in full-screen mode
Win + Ctrl + Shift + BWake up display if black
Shiben

Shiben

As you came here, so you must go. So don't delay, do the main thing, many real genes will know or understand.

Next Post Previous Post
No Comment
Add Comment
comment url
'); //]]>