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

#Excel_functions 1. SUM function: A1 से A3 और B1 से B3 तक की सेल में दी गई वैल्यू का योग करने के लिए फॉर्मूला: =SUM(A1:A3,B1:B3) Or =SUM(A1,A2,A3,B1,B2,B3)

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

▪️100+ Important Questions of History 🔹इतिहास के 100+ महत्वपूर्ण प्रश्न जो पिछले 10 वर्षो में बार बार पूछे गए है 👇👇 https://youtu.be/9fnTlYx_2sQ https://youtu.be/9fnTlYx_2sQ

Aap kya hai?

🚀Important Questions on Chandrayaan 3 | मिशन चंद्रयान 3 के महत्वपूर्ण प्रश्न https://youtu.be/N9OEs8vFj9Y https://youtu.be/N9OEs8vFj9Y ☝️ अभी देखे ☝️

💾 मेमोरी की यूनिट्स 💾 ➖➖➖➖➖➖➖➖➖➖➖➖ 1⃣: 1Bit (b) = Binary digit(0,1) 2⃣: 4 Bit = 1 Nibble 3⃣: 8 Bit = 1 Byte (B) 4⃣: 8 Bit/1 Byte = 1 Octet(o) 5⃣: 1024 Bytes = 1 kilo byte (KB) 6⃣: 1024 KB = 1 Mega byte (MB) 7⃣: 1024 MB = 1 Giga byte (GB) 8⃣: 1024 GB = 1 Terra byte (TB) 9⃣: 1024 TB = 1 Peta byte (PB) 🔟: 1024 PB = 1 Exa byte (EB) 1⃣1⃣: 1024 EB = 1 Zetta byte (ZB) 1⃣2⃣: 1024 ZB = 1 Yotta byte (YB) 1⃣3⃣: 1024 YB = 1 Bronto byte 1⃣4⃣: 1024 Brontobyte = 1 Geop byte Geop byte is the highest memory.

🖥 Computer Abbreviations (A) 🖥 ========================= 🔸 ACE➖Access Control Entry 🔸 ADSL➖Asymmetric Digital Subscriber Line 🔸 AGP➖Accelerated Graphics Port 🔸 AI➖Artificial Intelligence 🔸 ALGOL➖Algorithmic Language 🔸 ALU➖Arithmetic Logic Unit 🔸 ANSI➖American National Standards Institute 🔸 API➖Application Program Interface 🔸 ARPANET➖Advanced Research Projects Agency Network 🔸 ASCII➖American Standard Code For Information Interchange 🔸 ASP➖Active Server Pages 🔸 AUI➖Attachment Unit Interface 🔸 AVI➖Audio Video Interleave

🚀Important Questions on Chandrayaan 3 | मिशन चंद्रयान 3 के महत्वपूर्ण प्रश्न https://youtu.be/N9OEs8vFj9Y https://youtu.be/N9OEs8vFj9Y ☝️ अभी देखे ☝️

🌒🌝Top 30 Questions on Chandrayaan 3 | Important Questions on Chandrayaan 3 | मिशन चंद्रयान 3 के महत्वपूर्ण प्रश्न प्रिय विद्यार्थियों, अगर आप आगामी प्रतियोगी परीक्षा की तैयारी कर रहे है और आपका सपना है सरकारी नौकरी पाने का तो हो जाइये बेफ्रिक क्योंकि मिशन चंद्रयान 3 (Chandrayaan 3) से संबंधित महत्वपूर्ण प्रश्न इस वीडियो लाए गए है तो इस विशेष वीडियो से अंत तक देखे। https://youtu.be/N9OEs8vFj9Y https://youtu.be/N9OEs8vFj9Y ☝️ अभी देखे ☝️

✍️Important Protocol Full Form ═════════════════════════ 💻 APIPA- Automatic private internet protocol addressing 💻 APR- Address resolution protocol 💻 DHCP - Dynamic host configuration protocol 💻 FTP- File transfer protocol 💻 ICMP- Internet control message protocol 💻 IMAP -Internet mail access protocol 💻 IP- Internet protocol 💻 IPCONFIG -Internet protocol configuration 💻 IPP- Internet printing protocol 💻 IPSEC- Internet protocol security 💻 HTTP - Hypertext transfer protocol 💻 HTTPS- Hypertext transfer protocol over secure sockets layer 💻 LDAP- Lightweight directory access protocol 💻 NNTP- Network news transfer protocol 💻 POP3- Post office protocol3 💻 PPP- Point-to-point protocol 💻 PPTP- Point-to-point tunneling protocol 💻 TCP- Transmission control protocol 💻 TCP/IP- Transmission control protocol/internet protocol 💻 TFTP- Trivial file transfer protocol 💻 UDP- User datagram protocol 💻 VOIP- Voice over internet protocol 💻 WAP -Wireless application protocol 💻 RIP- Routing information protocol 💻 SMTP- Simple mail transfer protocol 💻 SNMP -Simple network management protocol