Computer Science Technology IT Notes PDF

Important Google Chrome Shortcuts • Add www. and .com to a site name, and open it in the current tab: Type a site name+Ctrl+Enter • Add www. and .com to a site name, and open it in a new window: Type a site name+Ctrl+Shift+Enter • Jump to the address bar: Ctrl+l or Alt+d or F6 • Move cursor to the address bar: Ctrl+F5

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

🖥 COMPUTER GLOSSARY 🚧 ALGORITHM ➭ In computing, an algorithm is a procedure for accomplishing some tasks which given an initial state, will terminate in a defined end-state. 🚧 ALPHANUMERIC ➭ A character set that contains letters, digits and other Special characters such as @, $, +, *, % etc. 🚧 ANALOG COMPUTER ➭ A computer that operates on data which is in the form of continuous variable physical quantities. 🚧 ANIMATION ➭ It is the process of making the illusion of motion and change by means of the rapid display of a sequence of static Image that minimally differ from each other.

🖥 COMPUTER KNOWLEDGE 1) First super computer of the world is CRAY K-1. 2) First digital computer of the world is ENIAC. 3) Most super computers use LINUX (an operating system) 4) First practical digital computer is UNIVAC 5) FORTRAN is the first programming language. 6) PROLOG is the language of fifth generation of computer. 7) PARAM is a super-computer. ▰▱▰▱▰▱▰▱▰▱▰▱▰▱ ➜ Jᴏɪɴ➾ @Computer_Quiz_Notes_PDF ▰▱▰▱▰▱▰▱▰▱▰▱▰▰

🔘 ɪᴍᴘᴏʀᴛᴀɴᴛ ᴀʙʙʀᴇᴠɪᴀᴛɪᴏɴ 🔘 • LAN - Local Area Network • VoIP - Voice over Internet Protocol • GIGO - Garbage In Garbage Out • SVG - Scalable Vector Graphics • DNS - Domain Name System ▰▱▰▱▰▱▰▱▰▱▰▱▰▱ ➜ Jᴏɪɴ➾ @Computer_Quiz_Notes_PDF ▰▱▰▱▰▱▰▱▰▱▰▱▰▰

☑️ MS Excel : important facts ☞ By default file name : Book1 ☞ Minimum and maximum zoom% : 10% and 400% ☞ File Extension : .xlsx ☞ Insert date : Today ( ) ☞ Insert current date and time : Now ( ) ☞ Column and Rows : 16384 and 1048576 ☞ First cell address : A1 ☞ Default page orientation : portrait ☞ Cell comments called : Cell Tip ☞ Font size minimum and maximum : 1 Pt and 409 Pt ▰▱▰▱▰▱▰▱▰▱▰▱▰▱ ➜ Jᴏɪɴ➾ @Computer_Quiz_Notes_PDF ▰▱▰▱▰▱▰▱▰▱▰▱▰▰

✅ 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)