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 […]
Dream11 IPL 2020 – Points Table – Team Positions
April 24, 2024
DIPL2020 Points Table – Season 13 – Dubai Let’s see how the points table stands now. Pos Team Pld Won Lost Tied N/R Net RR Pts Q Mumbai Indians MI 14 9 5 0 0 1.107 18 Q Delhi Capitals DC 14 8 6 0 0 -0.109 16 Q Sunrisers […]
IPL 2020 Points Table PDF – Winners List
April 24, 2024
IPL 2021 Points table Note: Click on this link to get latest points table for IPL 2021. 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 […]
Database Management System
April 24, 2024
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
April 24, 2024
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
April 24, 2024
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
April 24, 2024
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
April 24, 2024
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
April 24, 2024
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(” […]
Intersect method (Excel)
April 24, 2024
The Intersect method is used to Returns a Range object that represents the rectangular intersection of two or more ranges. If one or more ranges from a different worksheet are specified, an error is returned. Syntax: expression.Intersect (Arg1, Arg2, Arg3, Arg4, Arg5, Arg6, Arg7, Arg8, Arg9, Arg10, Arg11, Arg12, Arg13, Arg14, Arg15, Arg16, Arg17, Arg18, Arg19, Arg20, Arg21, Arg22, Arg23, Arg24, Arg25, Arg26, Arg27, Arg28, Arg29, Arg30) expression represents a variable that represents an Application object in excel. Parameters: Name Required/Optional Data […]
