Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
What do you understand by the title `Segregate even and odd numbers` ? Let’s decode. The goal of this problem is to separate the even and odd numbers in the input array while preserving the order of the elements, which means that the even numbers should remain in the same relative order as they were in the input, and the odd numbers should remain in the same relative order as they were in the input. Suppose we have [3, 5, 2, 6, 8, 9, 10, 11] as input, then the output will be [2, 6, 8, 10, 3, 5, ... Read More
What do you understand by the heading `Reflection of a point at 180−degree rotation of another point`? Let’s decode it in this article. Let's assume we have two points (x1, y1) and (x2, y2) in a 2−D plane. Where (x2, y2) is the point of rotation and (x1, y1) is the point to be reflected. Now, suppose x1, y1 is rotated 180 degrees across x2, y2 , and we get x1`, y1`. Now, we can observe that, if we are given 2 points in a 2−d plane with one of the points rotating across the second point it ... Read More
In the article, the user will understand how to remove all asterisk characters from cells in Excel. The users have to analyze the data or random names to remove the asterisk symbol from all cells either by using the formula or by using the Ku-tools tab. This method may be completed utilizing a straightforward way within Microsoft Excel by using the Remove Characters tab to remove the asterisk characters. After eliminating all asterisk characters, increase readability and clarity of understanding the dataset in MS excel. Ambiguity retains in the database due to asterisk characters will also be eliminated. Example 1: ... Read More
In the article, we may go to remove or delete all dashes that are created in the cells that we have inserted the data in Microsoft Excel. The users have to analyze the data to remove or delete only dashes in all social security numbers by using the Formula. The users have to delete the dashes by using the Ku-tools tab also. This method may be completed utilizing a straightforward way within Microsoft Excel by using the Remove by Position tab to remove the dashes. Various inbuilt functions are presented in the MS Excel to resolve the complex computational tasks. ... Read More
In the article, we may go to remove all commas that are created in the cells that we have inserted the data in Microsoft Excel. Excessive use of commas in large dataset create confusion for the users and mistakable calculations to be done if unwanted characters is existed in the excel worksheet. The users must analyze the data to remove or delete only commas in all cells by using the Find and Replace tab. The users have to delete the commas by using the Ku-tools tab also. This method may be completed utilizing a straightforward way within Microsoft Excel by ... Read More
In the article, we may go to remove or delete all characters after only the first and last space in any sentence which we have inserted in the cells in Microsoft Excel. The users must analyze the data to remove or delete the first or last characters from the left side in all cells either by the formulas or by using the Ku-tools tab also. The steps by step explanations are given in both examples to understand the concept clearly. Users must write the user defined formula correctly to obtain the accurate result. Let’s explore the examples one by one ... Read More
In the article, we may go to remove or delete all dashes or slashes or hyphens that are created in the cells that we have inserted the data in a date form in Microsoft Excel. The users must analyze the data to remove or delete dashes or slashes in the date’s row either by using the formula or by using the Format cells dialog box also. This method may be completed utilizing a straightforward way within Microsoft Excel by using the Format Cells to remove the dashes or slashes. In the large dataset, it is very difficult to analyze the ... Read More
In the article, the user will learn how to link a cell to a chart title or the text box which is achievable by selecting any cell that we have to analysis the formula in the formula bar within Microsoft Excel. There are frequent types of structures within the Excel sheet encompassed within the dataset. The users can utilize the many types of tabs in the ribbon dataset which the users want to link or connect the cell to a chart title using formula bar in the chart area. This method may be completed utilizing a straightforward way within Microsoft ... Read More
In this problem, we need to calculate the separation between two magnets that are attached to distinct pivots. We need to calculate the maximum and minimum distance between magnets i.e when the magnets attract and when they repel. The string's length between each magnet and the pivot is specified. Depending on their polarity, the magnets will either repel or attract one another. Calculating the distance between the two magnets when they are attracted and repelling one another is the task. Using the distance formula and taking the polarity of the magnets into account, the issue can be resolved. To calculate ... Read More
What do you understand by the Dodecagonal number? In order to understand the Dodecagonal number, we first need to understand a dodecagon. What is a Dodecagon? A polygon with twelve sides and twelve angles is called a dodecagon. It is a two−dimensional geometric shape that may be created by joining twelve line segments, each of which forms a closed loop when it connects with two other segments. Every side and angle of a normal dodecagon are equal to one another. A dodecagon's interior angles add up to 180(n−2) degrees, where n is the number of sides. As a result, a ... Read More