microsoft office
Synopsis
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
| Shortcut | Description |
|---|
Ctrl + A | Select all |
Ctrl + B | Bold |
Ctrl + C | Copy |
Ctrl + D | Delete |
Ctrl + E | Center |
Ctrl + F | Find |
Ctrl + G | Go to |
Ctrl + H | Replace |
Ctrl + I | Italic |
Ctrl + J | Justify |
Ctrl + K | Insert hyperlink |
Ctrl + L | Left align |
Ctrl + M | Indent |
Ctrl + N | New |
Ctrl + O | Open |
Ctrl + P | Print |
Ctrl + Q | Increase indent |
Ctrl + R | Right align |
Ctrl + S | Save |
Ctrl + T | Decrease indent |
Ctrl + U | Underline |
Ctrl + V | Paste |
Ctrl + W | Close |
Ctrl + X | Cut |
Ctrl + Y | Redo |
Ctrl + Z | Undo |
Microsoft Excel Shortcuts
| Shortcut | Description |
|---|
Ctrl + Shift + Enter | Insert a line break in a cell |
Ctrl + Shift + F3 | Insert a function |
Ctrl + Shift + F4 | Insert a function argument |
Ctrl + Shift + F9 | Insert a worksheet name |
Ctrl + Shift + F10 | Insert a cell reference |
Ctrl + Shift + F11 | Insert a defined name |
Ctrl + Shift + F12 | Insert a constant |
Ctrl + Shift + F5 | Insert a range name |
Ctrl + Shift + F6 | Insert a cell address |
Ctrl + Shift + F7 | Insert a workbook name |
Ctrl + Shift + F8 | Insert a column reference |
Ctrl + Shift + F1 | Insert a row reference |
Ctrl + N | Create a new workbook |
Ctrl + O | Open an existing workbook |
Ctrl + S | Save a workbook/spreadsheet |
Ctrl + W | Close the current workbook |
Ctrl + F4 | Close Excel |
Ctrl + PageDown | Move to the next sheet |
Ctrl + PageUp | Move to the previous sheet |
Alt + A | Go to the Data tab |
| Formula | Description |
|---|
=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
| Shortcut | Description |
|---|
Ctrl + 1 | Bullets |
Ctrl + 2 | Numbering |
Ctrl + 3 | Multilevel list |
Ctrl + 4 | Decrease indent |
Ctrl + 5 | Increase indent |
Ctrl + 6 | Decrease indent |
Ctrl + 7 | Increase indent |
Ctrl + 8 | Decrease indent |
Ctrl + 9 | Increase indent |
Ctrl + 0 | Normal view |