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
How to quickly calculate the square root of a value in Excel?
In this article, users can quickly calculate the square root of a value in Excel. With the help of SQRT() function, the manual computation of deriving the square root of large numbers may be eliminated and save the user time. Two examples will be illustrated; both the provided examples calculate the square root provided for the specified value. The first example uses the user-defined formula to solve the provided task. The user needs to viably provide the proper address of the cell inside the SQRT() function to generate an accurate result. The second example uses the Kutools. Example 1: ...
Read MoreExplain about Varargs in java?
A method can accept a variable number of parameters thanks to a Java feature called variable arguments, or varargs. This can be helpful for methods that need to be able to manage an unknown or variable number of inputs. We had two ways to handle methods that needed to take a variable number of arguments prior to introduction of varargs in Java 5. One way was to use overloaded methods. The method has to be developed in numerous iterations, each with a different number of arguments. If the process had many arguments, it might become complicated and challenging ...
Read MoreEssential Java Tips and Tricks for Programmers
Java is a powerful and versatile programming language. It is used in various applications. It's known for its reliability, portability, and safety, which makes it a famous desire for developers. Java is likewise exceptionally easy to analyze, which makes it a terrific desire for novices. However, it's critical to remember that simplicity might operate as an obstacle. If you're not mindful, you could be caught by Java's accessibility and neglect to explore the unique opportunities the language offers. Let's have a look at some tips to assist you develop as a Java developer and improve your language proficiency. Tip 1: ...
Read MoreEscape sequences in Java
Escape sequences are a unique kind of character that are used to indicate a different way of interpreting a group of characters. An escape sequence in Java is a character that is preceded by a backslash (). An escape sequence is treated by the Java compiler as a single character with unique meaning. Java frequently employs the following escape sequences: \t: Adds a new tab : Adds a new line \r: Adds a carriage return ': Adds a single quote ": Adds a double quote \: Adds a backslash These escape sequences can be used to control the ...
Read MoreHow to round down to 2 decimals a float using Python?
In this article, we will show you how to round off a floating number upto 2 decimals in python. Below are the various methods to accomplish this task: Using round() function Using format() function Using Decimal Module Using ceil() function Using round() function The round() function gives a floating point number with a specified number of decimals which is the rounded version of the specified number. The function will return the nearest integer because the default value for the number of decimals is 0. Syntax round(number, digits) Parameters number(required)- a number that should be rounded digits(optional)- ...
Read MoreHow to add color to a drop-down list in Excel?
Color can be a powerful element in an Excel drop down list, and it's easier to incorporate than you may think. We can add conditional formatting rules to the cell containing the drop-down list. Learn how to provide visual clues by adding a new list and validation control, followed by conditional format rules. For example, I have created a drop-down list of city names; when I select "Hyderabad", I want the cell to be colored Yellow automatically, and when I select "Chicago", I want the cell to be colored Blue, as shown in the screenshot below. First, Create ...
Read MoreHow to Set environment variables using PowerShell?
To set the environmental variable using PowerShell you need to use the assignment operator (=). If the variable already exists then you can use the += operator to append the value, otherwise, a new environment variable will be created.For example, there is no AZURE_RESOURCE_GROUP environment variable that exists in the system. We can create it as below.$env:AZURE_RESOURCE_GROUP = 'MyTestResourceGroup'Now when you check the environment variables in the system, you will get the above variable name.PS C:\Windows\system32> dir env: Name Value ---- ...
Read MoreHow to index and slice a tuple in Python?
A tuple is an ordered and immutable collection of Python objects separated by commas. Like lists, tuples are sequences. Tuples differ from lists in that they can't be modified, whereas lists can, and they use parentheses instead of square brackets. tup=('tutorials', 'point', 2022, True) print(tup) If you execute the above snippet, produces the following output − ('tutorials', 'point', 2022, True) In this article, we will discuss how to index and slice tuples in python. Indexing Tuples In Python, every tuple with elements has a position or index. Each element of the tuple can be accessed or manipulated by ...
Read MoreOdd numbers in N-th row of Pascal’s Triangle
The problem statement includes counting the odd numbers in N−th row of Pascal’s triangle. A pascal’s triangle is a triangular array where each row represents the binomial coefficients in the expansion of binomial expression. The Pascal’s triangle is demonstrated as below: 1 1 ...
Read MoreMoser-de Bruijn Sequence
The problem statement includes printing the first N terms of the Moser−de Bruijn Sequence where N will be given in the user input. The Moser−de Bruijn sequence is a sequence consisting of integers which are nothing but the sum of the different powers of 4 i.e. 1, 4, 16, 64 and so on. The first few numbers of the sequence include 0, 1, 4, 5, 16, 17, 20, 21, 64....... The sequence always starts with zero followed by the sum of different powers of 4 such as $\mathrm{4^{0}}$ i.e $\mathrm{4^{1}\:i.e\:4, }$ then sum of $\mathrm{4^{0}\:and\:4^{1}\:i.e\:5}$ and so on. In this ...
Read More