microsoft office


Microsoft Office is a family of client software, server software, and services developed by Microsoft. It was first announced by Bill Gates on August 1, 1988, at COMDEX in Las Vegas. It has various applications, including Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, Microsoft Outlook, Microsoft OneNote, Microsoft Publisher, Microsoft Teams, Microsoft OneDrive, and Microsoft SharePoint.

Microsoft Word Shortcuts

Ctrl + ASelect all
Ctrl + BBold
Ctrl + CCopy
Ctrl + DDelete
Ctrl + ECenter
Ctrl + FFind
Ctrl + GGo to
Ctrl + HReplace
Ctrl + IItalic
Ctrl + JJustify
Ctrl + KInsert hyperlink
Ctrl + LLeft align
Ctrl + MIndent
Ctrl + NNew
Ctrl + OOpen
Ctrl + PPrint
Ctrl + QIncrease indent
Ctrl + RRight align
Ctrl + SSave
Ctrl + TDecrease indent
Ctrl + UUnderline
Ctrl + VPaste
Ctrl + WClose
Ctrl + XCut
Ctrl + YRedo
Ctrl + ZUndo

Microsoft Excel Shortcuts

Ctrl + Shift + EnterInsert a line break in a cell
Ctrl + Shift + F3Insert a function
Ctrl + Shift + F4Insert a function argument
Ctrl + Shift + F9Insert a worksheet name
Ctrl + Shift + F10Insert a cell reference
Ctrl + Shift + F11Insert a defined name
Ctrl + Shift + F12Insert a constant
Ctrl + Shift + F5Insert a range name
Ctrl + Shift + F6Insert a cell address
Ctrl + Shift + F7Insert a workbook name
Ctrl + Shift + F8Insert a column reference
Ctrl + Shift + F1Insert a row reference
Ctrl + NCreate a new workbook
Ctrl + OOpen an existing workbook
Ctrl + SSave a workbook/spreadsheet
Ctrl + WClose the current workbook
Ctrl + F4Close Excel
Ctrl + PageDownMove to the next sheet
Ctrl + PageUpMove to the previous sheet
Alt + AGo to the Data tab

Formula in Excel

=SUM(A1:A10)Sum of cells A1 to A10
=AVERAGE(A1:A10)Average of cells A1 to A10
=COUNT(A1:A10)Count of cells A1 to A10
=MAX(A1:A10)Maximum of cells A1 to A10
=MIN(A1:A10)Minimum of cells A1 to A10
=IF(A1>A2,"A1 is greater than A2","A1 is less than A2")If A1 is greater than A2, then return “A1 is greater than A2”, else return “A1 is less than A2”
=IF(A1>A2,"A1 is greater than A2")If A1 is greater than A2, then return “A1 is greater than A2”

Microsoft PowerPoint Shortcuts

Ctrl + 1Bullets
Ctrl + 2Numbering
Ctrl + 3Multilevel list
Ctrl + 4Decrease indent
Ctrl + 5Increase indent
Ctrl + 6Decrease indent
Ctrl + 7Increase indent
Ctrl + 8Decrease indent
Ctrl + 9Increase indent
Ctrl + 0Normal view