Dynamic Host Configuration Protocol

Introduction The Dynamic Host Configuration Protocol is also known as DHCP, It is a network management protocol used on Internet Protocol(IP), wherein Dynamically assigning an IP address to other network parameters so the device can easily communicate with other IP networks.  A DHCP server enables the device to request IP […]

IPL 2020 Points Table PDF – Winners List

Dream 11 – IPL 13 2020 Points Table IPL13 is proving to be tougher than any other season. New teams are coming up at the top of the points table. It’s only the starting. Let’s see who finishes in the top 4 positions. Pos Team Pld Won Lost Tied N/R […]

Database Management System

What is DBMS? DBMS stands for Database Management System which is a software used to manage databases. For Example, MySQL, Oracle, etc. are some of the popular commercial DBMS today, it primarily functions as an interface between users and the database at the same time managing the data in order […]

Excel Sheet Protection Check

Detect Sheet Protection Whenever working with a worksheet ever wondered why some menu buttons are not working or ribbon icons are greyed out and no functionality doesn’t work, this happened to me and because of a silly mistake. I can’t say how many times this has happened to me while […]

Queues Interface in Java

Queue Interface: The Queue Interface in Java Collections provide functionality as a Queue in the real-life, it extends the collections interface. It represents real-world queues where people queue in waiting line in front of the Supermarket where new people add up at the end of the line (queue) and the […]

LET( ) Function in Excel

What is a LET function in Excel? The LET function in excel is used to assign the name of the calculations of the result. This allows storing of intermediate results of some calculations, values, name of some functions defined inside a formula. These name only apply within the scope of […]

LinkedList in Java

Similar to Arrays in java Linked List is also a Linear data structure. In Linked List unlike arrays elements are not stored in a contiguous locations and they are linked to each other using references(pointers in memory), in Linked List each element has a reference pointing it to the next […]

Excel TEXTJOIN Function

The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges. Syntax: TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) For example = TEXTJOIN(” […]