Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
TFT: Thin Film Transistor
Introduction A Thin Film Transistor is a type of field-effect transistor that is usually used in a liquid crystal display(LCD). TFTs are arranged in a matrix which is why they are referred to as “active matrix”TFT. This type of display is where TFT is featured for each individual crystal. They perform as switches which enable the pixels to change their state rapidly which makes them turn on and off relatively quickly. They have uses ranging from digital radiography detectors to displays that are used in daily use. These transistors are the driving force behind flat panel displays such as desktop ...
Read MoreUPS: Uninterruptible Power Supply
What is an uninterruptible power supply? An uninterruptible power supply (UPS) is a component that enables a computer to continue operating for at least a brief period of time when incoming power is disrupted. Utility electricity maintains and replenishes energy storage as long as it is in use. The longer electricity can be maintained, with some practical restrictions that will be covered later, the more energy can be stored. The technology makes it possible for different UPS systems to perform their functions differently. How does an uninterrupted power supply UPS work? When your primary power source fails or ...
Read MoreVGA: Video Graphics Array
Introduction For the PS/2 range of PCs, IBM launched VGA in 1987. The first graphics card with the ability to display up to 16 colors at 640 x 480 screen resolution was the original VGA chipset. VGA could display up to 256 colors even at a reduced resolution of 320 x 200 pixels, which made it simpler to represent lowercase letters. Other manufacturers quickly followed with graphics cards that could display thousands to millions of colors, but they were all supersets of VGA. Since VGA is supported by all PCs, all of these graphic cards had the same foundation. ...
Read MoreVIRUS: Vital Information Resources Under Seize
Introduction In the modern world, most people use computers & internet facilities. Computers made our life easy, but along with these facilities, we are at threat of losing data due to attacks of computer viruses. These viruses became stronger day by day. To protect computer systems from virus attacks we need to take precautions like installing & running antivirus software, we should carefully use computers & internet facilities. A computer virus is a malicious software that interrupts the functioning of the computer system. This may cause corruption, data theft, and also the crashing of a computer. What is VIRUS? ...
Read MoreHow to use the Filter Function for a complete match and Partial Match of Text string in Excel?
The filter function is a newly introduced function in Excel 2021 and Excel 365. In this article, we will understand the fundamental concept of the Filter function which is efficient in finding the filtered string presented in the dataset that relies on the specific criteria and extracts only those searched strings. This interesting function is compatible with other functions like Search, Match, ISNUMBER, and so on. The process of manually scanning a text string from a huge dataset is time-consuming and inefficient for the user. In addition to saving users time, the filter tool allows users to find an accurate ...
Read MoreHow to use BYCOL and BYROW functions in Excel?
Introduction The Excel 365 tool offers several easy-to-use functions that allow you to rapidly evaluate the datasets. In this article, we unravel the concept of BYCOL and BYROWS functions in Excel 365. Few operations are not executed properly while using a dynamic array. Sometimes, users may find it challenging to manipulate the functions of each cell in a matrix. To overcome this problem, BYCOL and BYROWS are effectively used with lambda functions and once users can customize the formula, the result will be displayed either in one row or one column. Illustration of BYCOL function in Excel Step 1 Open the new worksheet ...
Read MoreDSLR: Digital Single Lens Reflex
Introduction DSLR is the abbreviation for digital single lens reflex, it is a type of camera that uses a reflex mirror and single lens to capture the light onto the sensors. DSLR started becoming popular and eventually replaced the film-based SLRs in the 2000s. DLSRs had many advantages over film-based cameras such as larger storage as you weren’t limited to a fixed film size and could store thousands of pictures in the digital format. Learn more about DSLRs in the following article. DSLR: Full Form and Meaning The full form of the word DSLR is Digital Single Lens Reflex. ...
Read MoreCAD: Computer Aided Design
Introduction The process of creating, altering, analyzing, or optimizing a design with the help of computers (or workstations) and also using computers to assist with engineering and design for a wide range of projects across numerous industries is known as computer- aided design (CAD). Computer-aided geometric design (CAD) is another procedure that is comparable to CAGD. CAD's goals are to boost productivity and enhance design quality and amount of detail. It also aims to optimize and streamline the designer's process and improve documentation. Types of computer-aided design 2D CAD The first CAD software was created in the early 1970s ...
Read MoreBLOB: Binary Large Object
Introduction The abbreviation for "Binary Large Object" is BLOB. BLOBs were invented by Jim Starkey and were originally just large amorphous chunks of data that may be many gigabytes in size. In the modern world, a whole lot of data being available online for everyone to use requires proper containment and encryption, that’s where BLOBs come in handy. Different types of data are stored in BLOBs, QR codes are one of the most common BLOB types. BLOBs The term Binary Large Object (BLOB) refers to how database management systems handle and store long strings of data. It stores multimedia objects/data ...
Read MoreASR: Automated Speech Recognition
Introduction The ability of a program to convert spoken language into written language is called speech recognition, also known as automatic speech recognition (ASR), computer speech recognition, or speech-to-text. Think Siri, Okay Google, or other vocal dictation software. It's a familiar technology that many of us use on a daily basis. Additionally, it is developing chances to help particular communities of people, like those navigating daily life or their education while having disabilities. Modern iterations of the ASR transcription technology now include NLP (Natural Language Processing) (NLP). These record actual talks between individuals and analyze them using artificial intelligence. ...
Read More