In this article we will learn how to compare two number having nearby values to each other with a specified tolerance value. However using the basic formula as =A1=B1 we can directly compare the values for the exact match but sometimes we need to compare the value upto a tolerance values. For this, follow the below mentioned formula and steps. Comparing Two Numbers having a Specified Tolerance Value Step 1 − We have taken the following sample data for comparison. Step 2 − Enter the formula in C2 cell as mentioned below. This formula will return True for those values ... Read More

Conditional format icons are used for better data visualization in excel. It gives an instant data analysis to the viewer. For example, Icon sets can be used in the following scenarios; comparison of greater than, less than and equals to data item, comparison of highest temperature and lowest temperature, comparison between price inflation etc. In this article we will learn how to put icons instead of number while comparing adjacent cells of a rows or columns in an excel file by using the following methods − Compare adjacent column cells with Conditional Formatting icon set in Excel Compare adjacent ... Read More

SIP (Session Initiation Protocol) and XMPP (Extensible Messaging and Presence Protocol) are both communication protocols used to establish and manage real- time communication sessions between two or more endpoints, such as computers or mobile devices. SIP is mainly used for establishing and managing multimedia sessions over the internet, such as voice and video conversations. XMPP (Extensible Messaging and Presence Protocol) is a real-time communication protocol used for instant messaging (IM) and the exchange of presence information. Read this article to find out more about SIP and XMPP and how they are different from each other. What is SIP? SIP is ... Read More

Pentium and Xeon are Intel Corporation CPUs that are commonly used in personal computers and servers, respectively. While both CPUs are made by the same company, they are built for different purposes and have significant features. Pentium processors are designed for simple computer activities, whereas Xeon processors are designed for more demanding and specialised workloads. Read this article to find out more about Pentium and Xeon and how they are different from each other. What is Pentium? Pentium is a CPU family invented and manufactured by Intel Corporation. It is a brand name for a type of CPU found in ... Read More

MTP and MSC are two alternative data transfer technologies that are used to transfer data between a computer and a digital device, such as a mobile phone or an MP3 player. MTP stands for Media Transfer Protocol, and MSC stands for Mass Storage Class. Both techniques offer advantages and disadvantages, and which mode to choose will be depends on the user's individual needs. Read this article to find out more about MTP and MSC and how they are different from each other. What is MTP? MTP has the advantage of providing a more standard method of exchanging media files. This ... Read More

Computers perform operations based on the comments received. The set of commands or rules is sent and processed by the network protocol. In the network, there are different types of computers connected which may possess different hardware and software components. So, it is necessary to make the computer of different types communicate with each other using common rules set by the network protocols. So, we need to deal with the elements of network protocols to have data communication between the nodes of the network. Network Protocol Network Protocol provides a set of rules to be followed for data transmission in ... Read More

In a computer system, monitor is the most significant output device that conveys the information from computer system to the output world. When it comes to the types of computer monitors, then several types of display technologies are used, such as CRT (Cathode Ray Tube), LCD (Liquid Crystal Display), LED (Light Emitting Diode), Plasma Display, etc. In this article, we will discuss the important differences between CRT monitors and LED monitors. But before discussing the differences, let us first discuss the CRT and LED monitors individually. What is CRT Monitor? CRT stands for Cathode Ray Tube. CRT is one ... Read More

A computer system performs operations as per the instruction provided to it. These computer instructions are written in different formats based on the number of addresses that they contain. In this article, we will discuss the two types of computer instructions namely, 3-address instruction and 2-address instruction, and the important differences between them. The fundamental difference between 3-address instruction and 2-address instruction is that the 3-address instruction requires three operands, while the 2-address instruction requires two operands to execute. Before discussing the differences, let us first know a bit about 3-address and 2-address instructions individually. So, let gets started with ... Read More

A computer system performs operations based on the instruction provided to it. These computer instructions are written in different formats based on the number of addresses that they contain. In this article, we will discuss the two types of computer instructions namely, 3-address instruction and 1-address instruction, and the important differences between them. The fundamental difference between 3-address instruction and 1-address instruction is that the 3-address instruction requires three operands, while the 1-address instruction requires only a single operand. Before discussing the differences, let us first know a bit about 3-address and 1-address instructions individually. So, let gets started with ... Read More

A computer system performs tasks based on the instruction provided to it. These computer instructions are written in different formats based on the number of addresses that they contain. In this article, we will discuss the two types of computer instructions namely, 3-address instruction and 0-address instruction, and the important differences between them. The most fundamental difference between 0-address instruction and 3-address instruction is that the 0-address instruction does not require any operand to perform operations, whereas the 3-address instruction takes three operands to perform operations. Before discussing the differences between 0-address instruction and 3-address instruction, let us first discuss ... Read More