Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Sometimes the user is working with multiple worksheets at the same time. While working with a large number of sheets, obtaining current sheet numbers is important to track the current working operations status. To access the worksheet number, for this tutorial, we are using two strategies, the first strategy involves setting the sheet number on the status bar, and the second strategy involves using the VBA code. VBA code is an effective way to write code once, and the same code can be used to process data any number of times, by simply calling the associated module. A list ... Read More
Address of cell in excel generally refers to the location of some cell. Active cell can be defined as the cell that contains some data or can be active due to some user click or any other associated activities. Getting the active cell address can be important to understand the point of processing. It became more important when user is dealing with large spreadsheet. For this tutorial let’s try to evaluate two ways to determine the address of active cell. First process is based on excel user defined formula, and second process is based on the “VBA” code. ... Read More
Random data is a type of data generated randomly. For this article, the focus is to generate random date. Random data can be either created in between a specified range or can be generated abstractly to demonstrate some data to the user. In this article, two examples are used to demonstrate the method by using which user can easily generate random dates between the two specified dates. The first example focuses on the use of formula by using the RANDBETWEEN() method, and the second example focuses on the use of KuTool. To Show you Some Examples Example 1 Step ... Read More
Random data is a type of data generated randomly. For this tutorial the focus is to generate random even and odd numbers. Random data can be used to many purpose such as creating a sample data set, or to evaluate results on the based on the dataset. In this tutorial, the main focus is to generate the odd and even number between the specified data, by using the predefined available excel methods, and custom formulas. This tutorial contain two example first example will allow user to generate random odd number and latter one allows user to generate random even number. ... Read More
Excel is a famous spreadsheet-based tool, used to manipulate and process the available data. For this provided scenario, user need to evaluate the prime number between the two provided numbers. This tutorial includes two examples, first example is based on the user define formula. For this example, user need to define formula header. While for the second example user defines a module by using a VBA code. This VBA code can be called by using a explicit method. Let’s show you Some Examples Example 1 Step 1 Consider the below given sample workbook. This excels sheet contains two number ... Read More
The problem statement says to execute Two sum problem in linear time in JavaScript. It defines and explores the variety of algorithms that can help us find the least common factors present in mutual by the given source data in JavaScript. What is the Two sum problem in JavaScript ? Two Sum Problem in JavScript equals finding a pair of indices present in the array of numbers given as an input that adds up to the target sum which is also provided as an input by the user. Given an array of integers and ... Read More
In the given problem statement we are asked to sort an array of numbers into some sets where the array is the input source provided by the user going from brute force method to optimized solution . What is an array in JavaScript ? If you are familiar with any other programming language like C, C++, or Java, you must have heard the term 'array.' In programming, an array is a collection of similar data elements under one roof. Now, an important question arises: if arrays are generally the same in all languages, then ... Read More
The problem statement says that given a sorted array of numbers as an input source by the user such that we need to remove the duplicates or repeated elements from it making it all new array containing only unique elements inside it. What is a Sorted Array in JavaScript ? A sorted array is a kind of array in javascript that follows a certain order of line in which each element is sorted in alphabetical and numerical order all before using the sort method in javascript itself. The already sorted speed array lets you speed up the ... Read More
The problem statement asks the user that given a binary tree , you need to find the mirror image of the elements of the binary tree such that reverse the corresponding and parallel siblings of the tree branches . In short, invert the whole binary tree given the original binary tree as an input. The output of the problem statement looks like a reverse function of the input binary tree as the summary to implement for. What is a Tree in JavaScript A tree refers to one of the optimized data structures to hold data ... Read More
In the given problem statement we are asked to generate every possible permutation of the array given as input by the in JavaScript going from brute force method to optimized solution . What is an array in JavaScript ? If you are familiar with any other programming language like C, C++, or Java, you must have heard the term 'array.' In programming, an array is a collection of similar data elements under one roof. Now, an important question arises: if arrays are generally the same in all languages, then how does JavaScript make arrays more ... Read More