🖥 COMPUTER GLOSSARY

🚧 ANTI-VIRUS
➭ It consist of computer programs that attempt to identify threat and eliminate computer viruses and other malicious software (Malware).

🚧 APPLICATION SOFTWARE
➭ It is a subclass of computer software that employs the capabilities of a computer directly to a task that the user wishes to perform.

🚧 ARCHIVE
➭ It provides backup storage.

🚧 ARITHMETIC LOGIC UNIT (ALU)
➭ Is is a part of the execution unit, a core component of all CPUs. ALUs are capable of calculating the results of a wide variety of basic arithmetical and logical computations.

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