Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
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 More
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 More
Introduction When the power button is pressed on a computer, a circuit is closed which causes a test to be performed on the computer’s power supply. If there is a problem with the power supply, usually there will be no power output at all and the computer will not start. If the power supply test is ok, the power supply will send power to the CPU that has powered up, it will start executing instructions, because that is what a CPU was designed to do. In order to do this, it needs software, that is called BIOS. What is ... Read More
Introduction DTP usually refers to the term Desk-Top Publishing, it means the creation of publishing content or documents using your personal computer or in other words your desktop. There is much software available for creating documents in various formats such as .docx (document made by using MS Word), .pdf (Portable Document Format), .txt (Simple text file), etc. Another full form of DTP is Distributed Transaction Processing, which is a database transaction processing that shares multiple network hosts. Desktop Publishing - History The first DTP was developed in 1870 by Xerox PARC, but only started getting into common knowledge by 1978 ... Read More
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 More
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 More
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 More
If you want a transparent background in three.js, you need a pass in the alpha parameter to the WebGLRenderer constructors in the below-given code − var renderer = new THREE.WebGLRenderer( {alpha: true } ); // You can leave the clear color at the defaultvalue. renderer.setClearColor( 0x000000, 0 ); //default However, to set the background color, renderer.setClearColor(0xb0f442 );
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 More
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 More