Data and Big Data

Data is information in raw or unorganized form (such as alphabets, numbers, or symbols) that refer to, or represent, conditions, ideas, or objects. Data is limitless and present everywhere in the universe. Big Data refers to humongous volumes of data that cannot be processed effectively with the traditional applications that…

Electronic Payment System

An electronic payment system is a way of making transactions or paying for goods and services through an electronic medium, without the use of checks or cash. It’s also called an electronic payment system or online payment system. What Is Secure Electronic Transaction (SET)? Secure electronic transaction (SET) was an…

VLookUP in MS Excel

The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function…

Mail Merge in MS Word

Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more using information stored in a list, database, or spreadsheet. When performing a Mail Merge, you will need a Word document (you can start with an existing one or create a new one) and a recipient…

Filtering Data in MS Excel

Filtering, or temporarily hiding, data in a spreadsheet is simple. This allows you to focus on specific spreadsheet entries. To Filter Data Step 1: Click the Filter command on the Data tab. Drop-down arrows will appear beside each column heading. Step2: Click the drop-down arrow next to the heading you would like to filter.…

Sorting in MS Excel

Sorting lists is a common spreadsheet task that allows you to easily reorder your data. The most common type of sorting is alphabetical ordering, which you can do in ascending or descending order. To Sort in Alphabetical Order Select a cell in the column you want to sort (In this example,…

Operators in MS Excel

Operators in Excel specifies the type of calculation to be performed on a given set of values. Excel has a rich variety of operators to perform calculative actions on a given set of data. Types of Operators in Excel Basically, there are 4 crude types of operators in Excel, mentioned as…

Computer Basics

कंप्यूटर एक एडवांस इलेक्ट्रॉनिक डिवाइस है जो यूजर्स से इनपुट के रूप में रॉ डेटा लेता है और उसे इंस्‍ट्रक्‍शन (निर्देश) के एक सेट (प्रोग्राम) कंट्रोल के तहत प्रोसेस करता है, परिणाम उत्पादित (प्रोडूसस) करता है, और भविष्य में उपयोग के लिए इसे सेव करता है। žइनपुट ›कीबोर्ड जैसे इनपुट…