🖥 COMPUTER GLOSSARY

🚧 ARTIFICIAL INTELLIGENCE
➭ Fifth generation computing devices, based on artificial intelligence, are still in development, though there are some applications, such as voice recognition, that are being used today.

🚧 ASCII
➭ ( American Standard Code for Information Interchange) It is a character set and a character encoding based on the Roman alphabet as used in Modern English and other Western European Languages.

🚧 ASSEMBLER
➭ A program that translates mnemonic statement into executive instruction.

🚧 ATTRIBUTE
➭ The characteristics of an entity are called its attributes.

🖥 COMPUTER GLOSSARY

🚧 AUTHENTICATION
➭ Any process by which a system varifies the identity of the user who wants to access it.

🚧 AUXILIARY MEMORY
➭ It is also known as secondary memory that is not directly addressable by the CPU.

🚧 BACKSPACE KEY
➭ This key is used to delete the text. Backspace will delete the text to the left of the cursor.

🚧 BACKUP
➭ A copy of a file or other item of data made in case the original is lost and damaged.

🖥 COMPUTER GLOSSARY

🚧 BANDWIDTH
➭ The maximum amount of data that can travel in a communication path in a given time, measured in bits per second (bps).

🚧 BAR CODE
➭ It is a machine-readable representation of information in a visual format on a surface.

🚧 BATCH FILE
➭ It is a text file that contains a sequence of commands for a computer operating system.

🚧 BINARY CODED DECIMAL (BCD)
➭ A coding system in which a 4 digit binary number represents each decimal digit from 0 to 9.

☑️ 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

Microsoft Word: Text Alignments
Home ➞ Paragraph Group ➞Alignments

1. Left Align (Ctrl+L):
Aligns the text towards left margin.

2. Right Align (Ctrl+R):
Aligns the text towards right margin.

3. Center Align (Ctrl+E):
Brings the text at centre.

4. Justify Align (Ctrl+J):
Aligns the text to both left and right margins.

It also provides the alignment for other objects such as picture, symbol, shapes etc.

• Default Alignment - Left

🇮🇳 स्वतंत्रता दिवस की हार्दिक शुभकामनाएं💐💐

🔘 ɪᴍᴘᴏʀᴛᴀɴᴛ ᴀʙʙʀᴇᴠɪᴀᴛɪᴏɴ 🔘

• LAN - Local Area Network

• VoIP - Voice over Internet Protocol

• GIGO - Garbage In Garbage Out

• SVG - Scalable Vector Graphics

• DNS - Domain Name System

🔘 कंप्यूटर पीढ़ी - स्टोरेज डिवाइस 🔘

• प्रथम पीढ़ी ➞ मैग्नेटिक ड्रम
• First Gen. ➞ Magnetic Drum

• द्वितीय पीढ़ी ➞ मैग्नेटिक टेप/डिस्क
• Second Gen. ➞ Magnetic tape/Disk

• तृतीय पीढ़ी ➞ मैग्नेटिक कोर
• Third Gen. ➞ Magnetic Core

• चतुर्थ पीढ़ी ➞ सेमीकंडक्टर मेमोरी
• Fourth Gen.➞Semi conductor memory

• पंचम पीढ़ी - ऑप्टिकल डिस्क
• Fifth Gen. - Optical Disk

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

#Excel_functions

1. SUM function:

A1 से A3 और B1 से B3 तक की सेल में दी गई वैल्यू का योग करने के लिए फॉर्मूला:

=SUM(A1:A3,B1:B3)

Or

=SUM(A1,A2,A3,B1,B2,B3)

☞ कोल्ड बूट को बूटस्ट्रैपिंग कहा जाता है।
• Cold boot is called bootstrapping.

☞ मैकेलाइट नामक लैपटॉप के ऑपरेटिंग सिस्टम का नाम OZ है।
• The operating system of the MacLite laptop is named OZ.

☞ लिब्रे ऑफिस राइटर में डिफॉल्ट फॉन्ट साइज 12 है।
• The default font size in LibreOffice Writer is 12.

☞ हार्डवेयर एड्रेस को मैक एड्रेस के रूप में जाना जाता है।
• Hardware address is known as MAC address.

☞ वीडियो कॉन्फ्रेंसिंग में VoIP प्रोटोकॉल का प्रयोग किया जाता है।
• VoIP is used in video conferencing.


☞ VoIP - Voice over Internet Protocol

☞ ई-मेल सर्वर से ई-मेल डाउनलोड करने के लिए पुश प्रोटोकॉल (SMTP) का प्रयोग होता है।
• PUSH protocol (SMTP) is used to download e-mails from the e-mail server.

☞ ब्लॉग और ब्लॉगर्स के ऑनलाइन समुदाय को ब्लागोस्फेयर के रूप में जाना जाता है।
• Blogs and the online community of bloggers is known as Blogosphere.

🔘 ɪᴍᴘᴏʀᴛᴀɴᴛ ᴀʙʙʀᴇᴠɪᴀᴛɪᴏɴ 🔘

• MAN - Metropolitan Area Network

• IMAP - Internet Message Access Protocol

• PGA - Professional Graphics Array / Professional Graphics Adaptor

• EPROM - Erasable Programmable Read-Only Memory

• VIRUS - Vital Information Resources Under Seize

🔘 ɪᴍᴘᴏʀᴛᴀɴᴛ ᴀʙʙʀᴇᴠɪᴀᴛɪᴏɴ 🔘

• SSD - Solid State Drive

• LIFO - Last-In-First-Out

• OSI - Open System Interconnection

• MOEMS - Micro Opto Electro Mechanical Systems

• CAD - Computer Aided Design

🔘 ɪᴍᴘᴏʀᴛᴀɴᴛ ᴀʙʙʀᴇᴠɪᴀᴛɪᴏɴ 🔘

• PUMA - Programmable Universal Machine for Assembly

• CAT - Computerised Axial Tomogrophy

• SMS - Short Message Service

• TIFF - Tagged Image File Format

• SMPS - Switched Mode Power Supply

🔘 कम्प्यूटर एवं उनके आविष्कारक 🔘

• एनियक - जे. प्रेस्पर एकर्ट व जॉन मुचली
ENIAC - J. Presper Eckert and John Mauchley

• यूनिवैक - जे. प्रेस्पर एकर्ट व जॉन मुचली
UNIVAC - J. Presper Eckert and John Mauchley

• एडसैक - मॉरिस विल्किस
EDSAC - Maurice Wilkes

• एडवैक - जॉन वॉन न्यूमैन
EDVAC - John Wan Neumann

• पास्कलाइन - ब्लेज पास्कल
Pascaline - Blaise Pascal

• लेबनीज कैलकुलेटर - गॉटफ्रायड विल्हेम लेबनीज़
Leibintz Calculator - Gottfried Wilhelm Leibintz

• जैक्वार्ड्स लूम - जोसेफ मैरी जैक्वार्ड
Jacquard's Loom - Joseph Mary Jacquard