Computer Courses | Computer Tutorial | Computer Classes | Computer Institute | Computer Tricks
751 subscribers
272 photos
126 videos
2 files
336 links
Download Telegram
EXCEL

๐Ÿ–ฅ Complete List of MS Excel Shortcut Key ๐Ÿ–ฅ
==================

Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
Ctrl+K - Insert Hyperlink
Ctrl+N - New Workbook
Ctrl+O - Open
Ctrl+P - Print
Ctrl+R - Fill Right
Ctrl+S - Save
Ctrl+U - Underline
Ctrl+V - Paste
Ctrl W - Close
Ctrl+X - Cut
Ctrl+Y - Repeat
Ctrl+Z - Undo
F1 - Help
F2 - Edit
F3 - Paste Name
F4 - Repeat last action
F4 - While typing a formula, switch between absolute/relative refs
F5 - Goto
F6 - Next Pane
F7 - Spell check
F8 - Extend mode
F9 - Recalculate all workbooks
F10 - Activate Menubar
F11 - New Chart
F12 - Save As
Ctrl+: - Insert Current Time
Ctrl+; - Insert Current Date
Ctrl+" - Copy Value from Cell Above
Ctrl+โ€™ - Copy Formula from Cell Above
Shift - Hold down shift for additional functions in Excelโ€™s menu
Shift+F1 - Whatโ€™s This?
Shift+F2 - Edit cell comment
Shift+F3 - Paste function into formula
Shift+F4 - Find Next
Shift+F5 - Find
Shift+F6 - Previous Pane
Shift+F8 - Add to selection
Shift+F9 - Calculate active worksheet
Shift+F10 - Display shortcut menu
Shift+F11 - New worksheet
Shift+F12 - Save
Ctrl+F3 - Define name
Ctrl+F4 - Close
Ctrl+F5 - XL, Restore window size
Ctrl+F6 - Next workbook window
Shift+Ctrl+F6 - Previous workbook window
Ctrl+F7 - Move window
Ctrl+F8 - Resize window
Ctrl+F9 - Minimize workbook
Ctrl+F10 - Maximize or restore window
Ctrl+F11 - Inset 4.0 Macro sheet
Ctrl+F1 - File Open
Alt+F1 - Insert Chart
Alt+F2 - Save As
Alt+F4 - Exit
Alt+F8 - Macro dialog box
Alt+F11 - Visual Basic Editor
Ctrl+Shift+F3 - Create name by using names of row and column labels
Ctrl+Shift+F6 - Previous Window
Ctrl+Shift+F12 - Print
Alt+Shift+F1 - New worksheet
Alt+Shift+F2 - Save
Alt+= - AutoSum
Ctrl+` - Toggle Value/Formula display
Ctrl+Shift+A - Insert argument names into formula
Alt+Down arrow - Display A Autocomplete list
Alt+โ€™ - Format Style dialog box
Ctrl+Shift+~ - General format
Ctrl+Shift+! - Comma format
Ctrl+Shift+@ - Time format
Ctrl+Shift+# - Date format
Ctrl+Shift+$ - Currency format
Ctrl+Shift+% - Percent format
Ctrl+Shift+^ - Exponential format
Ctrl+Shift+& - Place outline border around selected cells
Ctrl+Shift+_ - Remove outline border
Ctrl+Shift+* - Select current region
Ctrl++ - Insert
Ctrl+- - Delete
Ctrl+1 - Format cells dialogueโ€‹ box
Ctrl+2 - Bold
Ctrl+3 - Italic
Ctrl+4 - Underline
Ctrl+5 - Strikethrough
Ctrl+6 - Show/Hide objects
Ctrl+7 - Show/Hide Standard toolbar
Ctrl+8 - Toggle Outline symbols
Ctrl+9 - Hide rows
Ctrl+0 - Hide columns
Ctrl+Shift+( - Unhide rows
Ctrl+Shift+) - Unhide columns
Alt or F10 - Activate the menu
Ctrl+Tab - In toolbar: next toolbar
Shift+Ctrl+Tab - In toolbar: previous toolbar
Ctrl+Tab - In a workbook: activate next workbook
Shift+Ctrl+Tab - In a workbook: activate previous workbook
Tab - Next tool
Shift+Tab - Previous tool
Enter - Do the command
Shift+Ctrl+F - Font Drop Down List
Shift+Ctrl+F+F - Font tab of Format Cell Dialog box
Shift+Ctrl+P - Point size Drop Down List
๐Ÿ”ตThree main components of a computer are


- RAM,
- Input/output devices
- cpu




๐Ÿ”ต Three mains parts of the processor are


- ALU
-Control unit
-registers

๐Ÿ”ต first punch card developed by

- Herman hollerith(for US census)


๐Ÿ”ตfirst punch card used by


-joseph Maire

๐Ÿ”ตThe wave underline in ms-word document indicates spelling errors.

โœ… Red


๐Ÿ”ตThe wave underline in ms-word document indicates
Grammar errors


โœ…green

๐Ÿ”ตwhat menu is selected to save or save as______



โœ…file menu


๐Ÿ”ตWhat menu is selected to print?



โœ…file menu

๐Ÿ”ตfile extensions are used in order to_____



โœ… identify the file type

๐Ÿ“ŒNote: Microsoft Windows Vista was an windows OS for
PC not Office Suit.
๐Ÿ”ต


๐Ÿ”ทHub- it works at the physical layer

โ™ฆ๏ธSwitch- it works at the data link layer


๐Ÿ”ถRepeater: it operates at the physical layer

๐Ÿ”ทRouter: it works at the network layer.

๐Ÿ”ต father of computer : Charles babbage


๐Ÿ”ตFather of modern computer:Alan Turin


๐Ÿ”ตfather of super computer

:Seymour Cray

๐Ÿ”ต invention


๐Ÿ”ทFirst mechanical calculator -



โœ…Blaise Pascal


๐Ÿ”ทpunch card




โœ…Herman hollerith


๐Ÿ”ตBasic architecture of computer developed by

โœ…Charles babbage


๐Ÿ”ทAnalytical engine


โœ… Charles babbage

๐Ÿ”น1976 Cray 1: first super computer


๐Ÿ”ท1991 Param: India's first super computer

๐Ÿ”ต computer for personal use is called?





โœ…micro computer

๐Ÿ”ต multiprogramming in 3rd generation


๐Ÿ”ทRemote processing and time Sharing 3rd generation

๐Ÿ”ทDiscovery of IC - 3rd generation

๐Ÿ”ตMicroprocessor In 4th generation

๐Ÿ”ตof the following which is the fastest



A)CD-ROM
B)RAM
C)registers
D) cache






โœ…C

๐Ÿ”ต first computer mouse was developed by





โœ… Douglas Engelbart

๐Ÿ”ต commercial purpose language


โœ…COBOL


๐Ÿ”ตcomplex scientific calculation



โœ…FORTRAN(first programming language)


๐Ÿ”ต simple language for beginners





โœ…BASIC

๐Ÿ”ต1 billion byte =GB

๐Ÿ”ต1million byte=MB

๐Ÿ”ต1 thousand byte=KB

๐Ÿ”ท highest folder in any folder based hierarchy






โœ…root directory

๐Ÿ”ท cryptography is derived from the ____word





โœ… Greek

๐Ÿ”ตTypes of software


๐Ÿ”ท system software
๐Ÿ”ท application software



๐Ÿ”นsystem software for operating system


๐Ÿ”น application software for specific tasks

๐Ÿ”ท unauthorised intrusion into a computer or a network




โœ… hacking



๐Ÿ”ต phishing


โœ…Phishing is the fraudulent attempt to obtain sensitive information such as usernames, passwords and credit card details by disguising oneself as a trustworthy entity in an electronic communication.[1][2] Typically carried out by email spoofing[3] or instant messaging,[4] it often directs users to enter personal information at a fake website which matches the look and feel of the legitimate site.[5]





๐Ÿ”ต malware



โœ…Malware (a portmanteau for malicious software) is any software intentionally designed to cause damage to a computer, server, client, or computer network.[1] Malware does the damage after it is implanted or introduced in some way into a target's computer and can take the form of directly executable code, scripts, so-called "active content" (Microsoft Windows), and other forms of data.[2] Some kinds of malware are largely referred to in the media as computer viruses, worms, Trojan horses, ransomware, spyware, adware, and scareware,

๐Ÿ”ตfather of computer science and Artificial intelligence








โœ…Alan Turing

Smallest to largest



๐Ÿ”นBit
๐Ÿ”นByte
๐Ÿ”นCharacter
๐Ÿ”ทFiled
๐Ÿ”ทRecord
๐Ÿ”ทFile
๐Ÿ”ตDatabase

๐Ÿ”ทzoom percentage in MS Excel








โœ…10% (tiny) to 400% (huge)



โœณ๏ธBy default, everything on screen is displayed at 100%

๐Ÿ”ทfirst generation: vacuum tube

๐Ÿ”น second generation: transistor

๐Ÿ”นThird generation: integrated circuit

๐Ÿ”น fourth generation: microprocessor


๐Ÿ”ทfifth generation: artificial intelligence

๐Ÿ”ต Microsoft word


๐Ÿ”ท Ctrl+W


โœ…close the current word document


๐Ÿ”ทCtrl+enter


โœ…page break

๐Ÿ”ทA function inside another function is known as____







โœ…nested function

๐Ÿ”นMROM Abbreviation





โœ…masked ROM




๐Ÿ”นPROM

Is a read only memory that can be modified only once by a user

๐Ÿ”ทweb server error message 500 means?








โœ… internet error/server-configuration problems

๐Ÿ”ตType of port



๐Ÿ”นUsb port
๐Ÿ”นPS/2 port
๐Ÿ”ทParallel port
๐Ÿ”ทSerial port

๐Ÿ”ท process of sending data to a temporary storage area in the computer's memory is know as?











โœ… Spooling

๐Ÿ”ทThe term computer is derived from which language?










โœ…Latin language

๐Ÿ”ทmargin that is added to the binding side of page when printing









โœ… gutter margin

๐Ÿ”ต____refers to an act of obtaining personal or stealing your personal information by simply watching what you type.










โœ… shoulder surfing



๐Ÿ”ต repeatedly harashing another person online is termed as?








โœ… cyberbullying

๐Ÿ”ทFPI full form?









โœ…frames per inch

๐Ÿ”ต
1.Gridline - page layout
2 Ms word page break- crtl + enter
๐Ÿ”ต


๐Ÿ”ทHub- it works at the physical layer

โ™ฆ๏ธSwitch- it works at the data link layer


๐Ÿ”ถRepeater: it operates at the physical layer

๐Ÿ”ทRouter: it works at the network layer.

๐Ÿ”ต father of computer : Charles babbage


๐Ÿ”ตFather of modern computer:Alan Turin


๐Ÿ”ตfather of super computer

:Seymour Cray

๐Ÿ”ต invention


๐Ÿ”ทFirst mechanical calculator -



โœ…Blaise Pascal


๐Ÿ”ทpunch card




โœ…Herman hollerith


๐Ÿ”ตBasic architecture of computer developed by

โœ…Charles babbage


๐Ÿ”ทAnalytical engine


โœ… Charles babbage

๐Ÿ”น1976 Cray 1: first super computer


๐Ÿ”ท1991 Param: India's first super computer

๐Ÿ”ต computer for personal use is called?





โœ…micro computer

๐Ÿ”ต multiprogramming in 3rd generation


๐Ÿ”ทRemote processing and time Sharing 3rd generation

๐Ÿ”ทDiscovery of IC - 3rd generation

๐Ÿ”ตMicroprocessor In 4th generation

๐Ÿ”ตof the following which is the fastest



A)CD-ROM
B)RAM
C)registers
D) cache






โœ…C

๐Ÿ”ต first computer mouse was developed by





โœ… Douglas Engelbart

๐Ÿ”ต commercial purpose language


โœ…COBOL


๐Ÿ”ตcomplex scientific calculation



โœ…FORTRAN(first programming language)


๐Ÿ”ต simple language for beginners





โœ…BASIC

๐Ÿ”ต1 billion byte =GB

๐Ÿ”ต1million byte=MB

๐Ÿ”ต1 thousand byte=KB

๐Ÿ”ท highest folder in any folder based hierarchy






โœ…root directory

๐Ÿ”ท cryptography is derived from the ____word





โœ… Greek

๐Ÿ”ตTypes of software


๐Ÿ”ท system software
๐Ÿ”ท application software



๐Ÿ”นsystem software for operating system


๐Ÿ”น application software for specific tasks

๐Ÿ”ท unauthorised intrusion into a computer or a network




โœ… hacking



๐Ÿ”ต phishing


โœ…Phishing is the fraudulent attempt to obtain sensitive information such as usernames, passwords and credit card details by disguising oneself as a trustworthy entity in an electronic communication.[1][2] Typically carried out by email spoofing[3] or instant messaging,[4] it often directs users to enter personal information at a fake website which matches the look and feel of the legitimate site.[5]





๐Ÿ”ต malware



โœ…Malware (a portmanteau for malicious software) is any software intentionally designed to cause damage to a computer, server, client, or computer network.[1] Malware does the damage after it is implanted or introduced in some way into a target's computer and can take the form of directly executable code, scripts, so-called "active content" (Microsoft Windows), and other forms of data.[2] Some kinds of malware are largely referred to in the media as computer viruses, worms, Trojan horses, ransomware, spyware, adware, and scareware,

๐Ÿ”ตfather of computer science and Artificial intelligence








โœ…Alan Turing

Smallest to largest



๐Ÿ”นBit
๐Ÿ”นByte
๐Ÿ”นCharacter
๐Ÿ”ทFiled
๐Ÿ”ทRecord
๐Ÿ”ทFile
๐Ÿ”ตDatabase

๐Ÿ”ทzoom percentage in MS Excel








โœ…10% (tiny) to 400% (huge)



โœณ๏ธBy default, everything on screen is displayed at 100%

๐Ÿ”ทfirst generation: vacuum tube

๐Ÿ”น second generation: transistor

๐Ÿ”นThird generation: integrated circuit

๐Ÿ”น fourth generation: microprocessor


๐Ÿ”ทfifth generation: artificial intelligence

๐Ÿ”ต Microsoft word


๐Ÿ”ท Ctrl+W


โœ…close the current word document


๐Ÿ”ทCtrl+enter


โœ…page break

๐Ÿ”ทA function inside another function is known as____







โœ…nested function

๐Ÿ”นMROM Abbreviation





โœ…masked ROM




๐Ÿ”นPROM

Is a read only memory that can be modified only once by a user

๐Ÿ”ทweb server error message 500 means?








โœ… internet error/server-configuration problems

๐Ÿ”ตType of port



๐Ÿ”นUsb port
๐Ÿ”นPS/2 port
๐Ÿ”ทParallel port
๐Ÿ”ทSerial port

๐Ÿ”ท process of sending data to a temporary storage area in the computer's memory is know as?











โœ… Spooling

๐Ÿ”ทThe term computer is derived from which language?










โœ…Latin language

๐Ÿ”ทmargin that is added to the binding side of page when printing









โœ… gutter margin

๐Ÿ”ต____refers to an act of obtaining personal or stealing your personal information by simply watching what you type.










โœ… shoulder surfing



๐Ÿ”ต repeatedly harashing another person online is termed as?








โœ… cyberbullying

๐Ÿ”ทFPI full form?









โœ…frames per inch

๐Ÿ”ต
1.Gridline - page layout
2 Ms word page break- crtl + enter
3.Ms personal assistant- cortana
4.Not program lang - unix
5.Not Ms os- windows 9
6.Eniac - 1st generation
7.Task manager- ctrl + alt + del
8.Ms access - dbms
9.A7.b6-....- mac address
10. High lev lang to machine- compiler
11. Not semiconductor memory- floppy disk
12. Excel after z = AA
13. Which is not web browser
14.octal conversion
15. Eeprom erased by- electric charge
16.which ray not used for data Transfer- gamma
17.choose crt email address
18. Hexadecimal-16
19. 1gb=1024mb
20. Walkie talkie - half duplex
21.junk email (unwanted messages) - spamming

__is the process of carrying out commands



A) fetching
B)storing
C) decoding
D) executing








โœ…D
computer generations

First Generation
In the late 1940s and early 1950s (EDSAC, UNIVAC I, etc.) computers used vacuum tubes for their digital logic and liquid mercury memories for storage. See early memory, EDSAC and UNIVAC I.

Second Generation
In the late 1950s, transistors replaced tubes and used magnetic cores for memories (IBM 1401, Honeywell 800). Size was reduced and reliability was significantly improved. See IBM 1401 and Honeywell.

Third Generation
In the mid-1960s, computers used the first integrated circuits (IBM 360, CDC 6400) and the first operating systems and database management systems. Although most processing was still batch oriented using punch cards and magnetic tapes, online systems were being developed. This was the era of mainframes and minicomputers, essentially large centralized computers and small departmental computers. See punch card, System/360 and Control Data.

Fourth Generation
The mid to late-1970s spawned the microprocessor and personal computer, introducing distributed processing and office automation. Word processing, query languages, report writers and spreadsheets put large numbers of people in touch with the computer for the first time. See query language and report writer.

Fifth Generation - The Future
The 21st century ushered in the fifth generation, which increasingly delivers various forms of artificial intelligence (AI). More sophisticated search and natural language recognition are features that users recognize, but software that improves its functionality by learning on its own will change just about everything in the tech world in the future. See AI, machine learning, deep learning, neural network, computer vision, virtual assistant and natural language recognition.
General Windows Shortcuts :
-------------------------
Ctrl + X : Cut the selected item
Ctrl + C : Copy the selected item
Ctrl + V : Paste the selected item
Ctrl + Z : Undo an action
Alt + Tab : Switch between open apps
Alt + F4 : Close the active item, or exit the active app
Alt + F8 : Show your password on the sign-in screen
Alt + Esc : Cycle through items in the order in which they were opened
Alt + underlined letter : Perform the command for that letter
Alt + Enter : Display properties for the selected item
Alt + Spacebar : Open the shortcut menu for the active window
Alt + Left arrow : Go back
Alt + Right arrow : Go forward
Alt + Page Up : Move up one screen
Alt + Page Down : Move down one screen
Ctrl + F4 : Close the active document (in apps that are full-screen and let you have multiple documents open at the same time)
Ctrl + A : Select all items in a document or window
Ctrl + D (or Delete) : Delete the selected item and move it to the Recycle Bin
Ctrl + R (or F5) : Refresh the active window
Ctrl + Y : Redo an action
Ctrl + Right arrow : Move the cursor to the beginning of the next word
Ctrl + Left arrow : Move the cursor to the beginning of the previous word
Ctrl + Down arrow : Move the cursor to the beginning of the next paragraph
Ctrl + Up arrow : Move the cursor to the beginning of the previous paragraph
Ctrl + Alt + Tab : Use the arrow keys to switch between all open apps
Ctrl + Alt + Shift + arrow keys : When a group or tile is in focus on the Start menu, move it in the direction specified
Ctrl + arrow key (to move to an item) + Spacebar : Select multiple individual items in a window or on the desktop
Ctrl + Shift with an arrow key : Select a block of text
Ctrl + Esc : Open Start
Ctrl + Shift + Esc : Open Task Manager
Ctrl + Shift : Switch the keyboard layout when multiple keyboard layouts are available
Ctrl + Spacebar : Turn the Chinese input method editor (IME) on or off
Shift + F10 : Display the shortcut menu for the selected item
Shift with any arrow key : Select more than one item in a window or on the desktop, or select text in a document
Shift + Delete : Delete the selected item without moving it to the Recycle Bin first
Right arrow : Open the next menu to the right, or open a submenu
Left arrow : Open the next menu to the left, or close a submenu
Esc : Stop or leave the current task
Dialog box keyboard shortcuts :
F4 : Display the items in the active list
Ctrl + Tab : Move forward through tabs
Ctrl + Shift + Tab : Move back through tabs
Ctrl + number (number 1โ€“9) : Move to nth tab
Tab : Move forward through options
Shift + Tab : Move back through options
Alt + underlined letter : Perform the command (or select the option) that is used with that letter
Spacebar : Select or clear the check box if the active option is a check box
Backspace : Open a folder one level up if a folder is selected in the Save As or Open dialog box
Arrow keys : Select a button if the active option is a group of option buttons
File Explorer keyboard shortcuts :
Alt + D : Select the address bar
Ctrl + E : Select the search box
Ctrl + F : Select the search box
Ctrl + N : Open a new window
Ctrl + W : Close the active window
Ctrl + mouse scroll wheel : Change the size and appearance of file and folder icons
Ctrl + Shift + E : Display all folders above the selected folder
Ctrl + Shift + N : Create a new folder
Num Lock + asterisk (*) : Display all subfolders under the selected folder
Num Lock + plus (+) : Display the contents of the selected folder
Num Lock + minus (-) : Collapse the selected folder
Alt + P : Display the preview panel
Alt + Enter : Open the Properties dialog box for the selected item
Alt + Right arrow : View the next folder
Alt + Up arrow : View the folder that the folder was in
Alt + Left arrow : View the previous folder
Backspace : View the previous folder
Right arrow : Display the current selection (if it's collapsed), or select the first subfolder
Left arrow : Collapse the current selection (if it's expanded), or select the folder that the folder was in
End : Display the bottom of the active window
Windows logo key Shortcuts :
-------------------------
Windows logo key : Open or close Start
Windows logo key + A : Open Action center
Windows logo key + B : Set focus in the notification area
Windows logo key + C : Open Cortana in listening mode(This shortcut is turned off by default.)
Windows logo key + Shift + C : Open the charms menu
Windows logo key + D : Display and hide the desktop
Windows logo key + Alt + D : Display and hide the date and time on the desktop
Windows logo key + E : Open File Explorer
Windows logo key + F : Open Feedback Hub
Windows logo key + G : Open Game bar when a game is open
Windows logo key + I : Open Settings
Windows logo key + J : Set focus to a Windows tip when one is available.
When a Windows tip appears, bring focus to the Tip. Pressing the keyboard shortcuts again to bring focus to the element on the screen to which the Windows tip is anchored.
Windows logo key + K : Open the Connect quick action
Windows logo key + L : Lock your PC or switch accounts
Windows logo key + M : Minimize all windows
Windows logo key + O : Lock device orientation
Windows logo key + P : Choose a presentation display mode
Windows logo key + R : Open the Run dialog box
Windows logo key + : Open search
Windows logo key + T : Cycle through apps on the taskbar
Windows logo key + U : Open Ease of Access Center
Windows logo key + V : Cycle through notifications
Windows logo key + Shift + V : Cycle through notifications in reverse order
Windows logo key + X : Open the Quick Link menu
Windows logo key + Z : Show the commands available in an app in full-screen mode
Windows logo key + comma (,) : Temporarily peek at the desktop
Windows logo key + Pause : Display the System Properties dialog box
Windows logo key + Ctrl + F : Search for PCs (if you are on a network)
Windows logo key + Shift + M : Restore minimized windows on the desktop
Windows logo key + number : Open the desktop and start the app pinned to the taskbar in the position indicated by the number. If the app is already running, switch to that app.
Windows logo key + Shift + number : Open the desktop and start a new instance of the app pinned to the taskbar in the position indicated by the number
Windows logo key + Ctrl + number : Open the desktop and switch to the last active window of the app pinned to the taskbar in the position indicated by the number
Windows logo key + Alt + number : Open the desktop and open the Jump List for the app pinned to the taskbar in the position indicated by the number
Windows logo key + Ctrl + Shift + number : Open the desktop and open a new instance of the app located at the given position on the taskbar as an administrator
Windows logo key + Tab : Open Task view
Windows logo key + Up arrow : Maximize the window
Windows logo key + Down arrow : Remove current app from screen or minimize the desktop window
Windows logo key + Left arrow : Maximize the app or desktop window to the left side of the screen
Windows logo key + Right arrow : Maximize the app or desktop window to the right side of the screen
Windows logo key + Home : Minimize all except the active desktop window (restores all windows on second stroke)
Windows logo key + Shift + Up arrow : Stretch the desktop window to the top and bottom of the screen
Windows logo key + Shift + Down arrow : Restore/minimize active desktop windows vertically, maintaining width
Windows logo key + Shift + Left arrow or Right arrow : Move an app or window in the desktop from one monitor to another
Windows logo key + Spacebar : Switch input language and keyboard layout
Windows logo key + Ctrl + Spacebar : Change to a previously selected input
Windows logo key + Ctrl + Enter : Open Narrator
Windows logo key + forward slash (/) : Begin IME reconversion
Windows logo key + plus (+) or minus (-) : Zoom in or out using Magnifier
Windows logo key + Esc : Exit Magnifier
MS Word Shortcuts :
-------------------------
Ctrl + A : Select all contents of the page
Ctrl + B : Bold highlighted selection Text
Ctrl + C : Copy selected text
Ctrl + X : Cut selected text
Ctrl + N : Open new/blank document
Ctrl + O : Open options
Ctrl + P : Open the print window
Ctrl + F : Open find box
Ctrl + I : Italicize highlighted selection
Ctrl + K : Insert link
Ctrl + U : Underline highlighted selection
Ctrl + V : Paste
Ctrl + Y : Redo the last action performed
Ctrl + Z : Undo last action
Ctrl + G : Find and replace options
Ctrl + H : Find and replace options
Ctrl + J : Justify paragraph alignment
Ctrl + L : Align selected text or line to the left
Ctrl + Q : Align selected paragraph to the left
Ctrl + E : Align selected text or line to the center
Ctrl + R : Align selected text or line to the right
Ctrl + M : Indent the paragraph
Ctrl + T : Hanging indent
Ctrl + D : Font options
Ctrl + Shift + F : Change the font
Ctrl + Shift + > : Increase selected font +1
Ctrl + ] : Increase selected font +1
Ctrl + Shift + < : Decrease selected font -1
Ctrl + [ : Decrease selected font -1
Ctrl + Shift + * : View or hide non printing characters
Ctrl + โ† : Move one word to the left
Ctrl + โ†’ : Move one word to the right
Ctrl + โ†‘ : Move to beginning of the line or paragraph
Ctrl + โ†“ : Move to the end of the paragraph
Ctrl + Del : Delete word to right of cursor
Ctrl + Backspace : Delete word to left of cursor
Ctrl + End : Move cursor to end of document
Ctrl + Home : Move cursor to beginning of document
Ctrl + Space : Reset highlighted text to default font
Ctrl + 1 : Single-space lines
Ctrl + 2 : Double-space lines
Ctrl + 5 : 1.5-line spacing
Ctrl + Alt + 1 : Change text to heading 1
Ctrl + Alt + 2 : Change text to heading 2
Ctrl + Alt + 3 : Change text to heading 3
F1 : Open help
Shift + F3 : Change case of selected text
Shift + Insert : Paste
F4 : Repeat last action performed (Word 2000+)
F7 : Spell check selected text and/or document
Shift + F7 : Activate the thesaurus
F12 : Save as
Ctrl + S : Save
Shift + F12 : Save
Alt + Shift + D : Insert the current date
Alt + Shift + T : Insert the current time
Ctrl + W : Close document
MS Excel Shortcuts :
-------------------------
Alt + Tab : Switch between open applications
Alt + Shift + Tab : Switch backwards between open applications
Alt + Print Screen : Create screen shot for current program
Print Screen : Create screen shot for Display
Ctrl + Alt + Del : Reboot/Windowsยฎ task manager
Ctrl + Esc : Bring up start menu
Alt + Esc : Switch between applications on taskbar
F2 : Rename selected icon
F3 : Start find from desktop
F4 : Open the drive selection when browsing
F5 : Refresh contents
Alt + F4 : Close current open program
Ctrl + F4 : Close window in program
Ctrl + PlusKey : Automatically adjust widths of all columns in Windows Explorer
Alt + Enter : Open properties window of selected icon or program
Shift + F10 : Simulate right-click
Shift + Del : Delete program/files permanently
Holding Shift During Bootup : Boot safe mode or bypass system files
MS Power Point Shortcuts :
-------------------------
Ctrl + Shift + Tab : Switch between outline and side view
Ctrl + M : Insert a new slide
Ctrl + D : Duplicate the current side
Ctrl + Shift + > : Increase font size
Ctrl + Shift + < : Decrease font size
Ctrl + T : Display the font dialog box
Double-click the object : Open the properties for an object
Alt + Shift + Left arrow : Promote a paragraph in an outline
Alt + Shift + Right arrow : Demote a paragraph in an outline
Alt + Shift + Up arrow : Move selected outline paragraphs up
Alt + Shift + Down arrow : Move selected outline paragraphs down
Alt + Shift + 1 : Display outline heading level 1
Alt + Shift + + : Expand outline text below a heading
Alt + Shift + โ€“ : Collapse outline text below a heading
Alt + Shift +A : Collapse or show all text or headings
Shift + F9 : Show or hide the grid
Alt + F9 : Show or hide the guides
Ctrl + G : Change grid and guide settings
Ctrl + P : Activate the pen tool during a show
E : Erase pen tool drawings during a show
Esc : Turn off the pen tool
Ctrl + H : Change the pen to a pointer
Tab : Hide the pointer or pen
B : Move to the next hyperlink
W : Make the screen go black during a show
S : Make the screen go white during a show
1 + Enter : Stop or restart a show
๐Ÿ›‘ 15th JULY

โ‡๏ธ WORLD YOUTH SKILL DAY
เคตเคฟเคถเฅเคต เคฏเฅ‹เค— เค•เฅŒเคถเคฒ เคฆเคฟเคตเคธ

๐Ÿ’  THEME : Skills for a Resilient Youth

๐Ÿ”น The importance of developing skilled youth is at the core of this year's message for World Youth Skills Day.

๐Ÿ”น The United Nations General Assembly has decided to celebrate the first World Youth Skills Day (WYSD) on 15 July 2015.

โ„ United Nations General Assembly :
๐Ÿ Established :- 1945
๐Ÿ Headquarters: New York, US
๐Ÿ President: Prof. Tijjani Muhammad Bande
Fullstack GoLang React: Design to Reality 2 ( Real World )

25 Hrs

A real world project based course
Agile Scrum Fundamentals+Scrum Master+Scrum Certification

Introduction to Lean | Agile Scrum Fundamentals + Agile and Scrum concepts + Overview of Scrum Agile
Build Automated workflows & connect your apps to each other

Master the fundamentals of browser automation using Zapier.
EDM Production: Finish Your Next Track in Less Than 2 Hours

Learn how to finish more music fast starting from a blank project and finishing with a complete electronic music track.

Join :

Chaudhary Computers and Commercial College
Java Programming for Complete Stranger (9.5 Hrs)

Learn Java Programming with lot of examples. For Java Beginners! Let's learn OOP's

Join :

Chaudhary Computers and Commercial College
Java Programming: Complete Beginner to Advanced

Become a Computer Programmer by Learning Core Java Skills
Accounting, Bookkeeping & Financial Statements: Zero to Pro

3 courses in 1: Bookkeeping, Financial Accounting, Accounting Reports & Financial Statements preparation in 8 hours!

Join :

Chaudhary Computers and Commercial College