Computer Science Technology IT Notes PDF

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 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 dialog 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

✅ QUICK FACT COMPUTER : ONE LINER 1. Father of Computer - CHARLES BABBAGE 2. Father of Modern Computer Science - ALAN TURING 3. First Un Programmable Digital Computer - ATANASOFF BERRY COMPUTER (ABC) 4. First Electronic Digital Computer - ENIAC 5. ENIVAC stands for - ELECTRONIC NUMERIC INTEGRATOR AND CALCULATOR 6. World'S Fastest Computer - Sunway TaihuLight, in China. 7. India's Fastest Computer - PARAM SIDDHI AI 8. PARAM SIDDHI AI developed by - Centre for Development of Advanced Computing (CDAC) 💻 GENERATIONS OF COMPUTERS : 1. First Generation - (1940-56) - Vacuum tubes - Batch processing OS 2. Second Generation - (1956-63) - Transistors - Multi bag / Time sharing OS 3. Third Generation - (1964-71) - Integrated Circuits - Timesharing/ Real time OS 4. Fourth Generation - (1971-80) - Microprocessors - Real time/ Multi programming OS 5. Fifth Generation - (1980- present) - Semi conductors - Real time/ Multi programming OS 🕹 GENERATION LANGUAGE : 1st - Machine and Assembly language 2nd - Assembly language and high level languages (FORTRAN , COBOL) 3rd - High level languages (FORTRAN II - IV , COBOL , PASCAL , BASIC, ALGOL68) 4th - High level languages(FORTAN 77 , PASCAL , COBOL) 5th - High level languages(C , C++ ,JAVA , .NET)