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
What is the full form of BRB ?
Introduction BRB is a widely used internet slang that stands for "Be Right Back". It is commonly used in online conversations and messaging to indicate a temporary absence. The phrase suggests that the person is stepping away from the conversation or activity for a short period of time and will return shortly. The term "BRB" is believed to have originated in the early days of online chat rooms, when users needed a quick way to communicate that they were stepping away from the computer for a moment. What is the Full Form of BRB? BRB stands for "Be Right ...
Read MoreWhat is the full form of BRICS ?
Introduction BRICS is an acronym for its member nations that include Brazil, Russia, India, China and South Africa. This acronym was coined by Jim O’Neill, an economist from Goldman Sachs, as ‘BRICs’, who believed that by the end of 2050, these fast growing economies will lead the global economy. In 2010, South Africa was also added to this acronym after which it became BRICS. In this article we will briefly discuss BRICS. Overview of BRICS Under the initiative of Russian President Vladimir Putin, the first BRICS Ministerial Meeting took place in New York on September 20, 2006, in conjunction ...
Read MoreDVD: Digital Video Disc, Digital Versatile Disc
Introduction When computer and storage technology was under development, there was a great demand for high-capacity portable storage devices which can easily help in porting high intensive content such as Operating Systems, HD Quality videos or movies, and large software programmes. It was mainly developed and invented by four companies Philips, Sony, Toshiba, and Panasonic in 1995. DVDs provide higher capacity storage than CDs (Compact Disk) and can be played in multiple media players such as DVD players. What is DVD ? DVD stands for Digital Video Disk or Digital Versatile Disk, ...
Read MoreWhat are the new functions introduced in Excel 2021?
Introduction In today's data-driven world, the ability to swiftly search and retrieve specific information is vital. This is particularly true when dealing with large datasets spread across multiple sheets or worksheets within a file. Manually manipulating the matrix through each sheet can be time-consuming and prone to errors. In this article, we will gain deep insights into the new functions that are introduced in Excel 2021. The main advantages of Excel 2021 are better teamwork, improved expert performance, better productivity, more interactive ribbon with a new tab, more flexibility, and new Dynamic Array Formulas to get accurate results. ...
Read MoreHow to use the XLOOKUP function in Excel365?
The better alternative to VLOOKUP is XLOOKUP which is exclusive to Excel 365. It assists users in looking at the value in one column and extracting the value from different columns that are based on a certain condition. It is one of the most efficient techniques for dealing with error values and flexibility in nature. This amazing feature is enhanced to manage data and deal with errors. The XLOOKUP's major advantages are its improved efficiency, accuracy, and straightforward formula. XLOOKUP Function in EXCEL365 Step 1 Open the worksheet comprising the two tables separately and write the following data as given below − Step 2 The main ...
Read MoreHow to quickly use VALUETOTEXT function in Excel 365?
Introduction When working with extensive spreadsheets that comprises numerous columns and rows, finding specific information can become challenging without proper visibility cues. Manipulating large voluminous of unstructured data is very time-consuming for the users. A wide variety of fourteen new Excel functions are introduced in Excel 365 to ease the user's work. To overcome this problem, users may utilize the new inbuilt functions like Filter, Unique, Lambda, Xlookup, etc. In this article, we will unravel the hidden concept of the VALUETOTEXT function. This function is not available in the older version of the Excel tool. VALUETOTEXT Function It extracts the text ...
Read MoreHow to use TEXTBEFORE, TEXTSPLIT, and TEXTAFTER functions in Excel?
When you import the data from another resource, a lot of mistakes are encountered in the dataset which makes it very challenging for the users to manipulate the text therein. In this article, users will learn the concept of TEXTBEFORE, TEXTSPLIT, and TEXTAFTER functions which are exclusive only to Office 365. The TEXTBEFORE function retrieves the text before the delimiter whereas the TEXTSPLIT function partitions the text with the help of the row and column’s delimiter. The last TEXTAFTER function fetches the text after the delimiter. All these functions are user-friendly and simple to use. TEXTBEFORE Function in Excel Step 1 Open the new ...
Read MorePDA: Personal Digital Assistant
Introduction PDA which stands for Personal Digital Assistant is a handheld device that is usually used for business use or personal use. It is used to keep schedules, information such as address books and calendars. They are also used for storing information and computing. Almost all the PDAs that existed used to have a physical keyboard which was small in size. Some of them used to have a small sensitive pad that could be used to detect handwriting to make easy notes. Basic Features of PDAs Displays The displays were very similar to the laptop screens at the time. ...
Read MorePNG: Portable Network Graphics
Introduction An effective file format for lossless, portable, and well-compressed bitmap storage is Portable Network Graphics (PNG). It may be read and exchanged between computers with ease and requires little storage capacity. The GIF format can be replaced with the Portable Network Graphics format, which can also be used in place of the TIFF format for many common applications. The Portable Network Graphics format is fully streamable and has a progressive display option, making it ideal for online viewing, such as on the Web. All formats and functionality may not be supported by all web browsers. If you want ...
Read MoreRO: Reverse Osmosis
Introduction Water is absorbed by plant roots from the soil and by human kidneys from the blood as examples of osmosis. Osmosis occurs without the need for energy in a natural way, but it requires energy to reverse the process. A semi-permeable membrane is impermeable to the majority of dissolved salts, organics, microorganisms, and other contaminants. What is Reverse Osmosis? Water is demineralized or deionized via the reverse osmosis technique, often known as RO, which involves forcing the water under pressure through a semi-permeable Reverse osmosis Membrane. You must first comprehend the naturally occurring process of osmosis in order to ...
Read More