Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
The calculation of the cumulative or running total is used to watch the summation of numbers which is updated every time when a new number is entered into the sequence in an excel sheet. In this tutorial, you will learn how to calculate the cumulative or running total of a column in an Excel sheet. Calculating the Cumulative Sum of a Column in an Excel Sheet Using the formulas, you can get the cumulative total or running total of a column in a Microsoft excel sheet. Kindly follow the below steps to understand this clearly. Step 1 Open a Microsoft ... Read More
In this tutorial, we will demonstrate how you can calculate the price of a zero coupon bond, the price of an annual coupon bond, and the price of the semi-annual coupon bond in an Excel sheet. Calculating the Price of a Zero Coupon Bond in Excel Consider an example, there is a 10 years bond and the value is 5000, and the rate of interest is 7.5 %. Before the maturity date, the bondholder cannot get any coupon. You can calculate the price of the zero bonds using the formula. Step 1 Open an Excel sheet and enter the data ... Read More
If you want to calculate the average speed and how much time you will spend going from one place and another by bicycle, then you need to know the average speed when you drive a bike. For an instance, consider you have recorded the time and distance at the time of traveling, now with that data, you can calculate the average bicycle speed – the average rate of change in an Excel sheet. Follow the steps given below to calculate the average rate of change in an Excel sheet. Step 1 Open a Microsoft excel sheet and enter the ... Read More
It is quite easy to find the average in a column based on the criteria in another column in an Excel sheet. In this tutorial, we will show how you can do it in just two simple steps. Step 1 Open a Microsoft excel sheet, and enter the data as per your wish below I have considered this data as shown in the below screenshot for your reference. Here the excel contains the date, region and the values for the sales. Step 2 Now you need to select a blank cell in an excel sheet and enter the below ... Read More
The usage of absolute numbers to distinguish between occurrences like "Decline, " "Boost, " and "Payment, " among other things, is rather prevalent among users. When just the difference between the two numbers is required or requested in a spreadsheet, the Excel absolute difference between the two values is provided. The ABS function in Excel will return the absolute value of any difference or number that is provided. To calculate the absolute difference between two values, we may make use of a variety of different formulae, including IF, MAX, and MIN, as well as a VBA Custom Function. In layman's ... Read More
A number's standard deviation gives you an idea of how much it deviates from the average of all the values in the sample. The fact that each of the numbers is identical to the others indicates that there is no variance. As a direct consequence of this, the numbers have just a standard deviation that is equal to zero. The STDEV function has been around for a very long time. The new STEDV.S function, which is included in Microsoft Excel and provides the same exact result, is the one that the software company advises using. We can compute the standard ... Read More
We will use the "abort()" method to cancel the XMLHttpRequest. This will stop the current request from continuing to execute. In the future, we will make sure to properly cancel any requests that are no longer needed to optimize performance. Let us first understand what XML HttpRequest is. XMLHttpRequest is a JavaScript object that allows web developers to make HTTP requests to a server without reloading the entire page. It is often used for creating dynamic and interactive web applications. The API can be used to retrieve data in different formats such as text, XML, and JSON. XMLHttpRequest is supported ... Read More
We can add a fade-out effect using pure JavaScript by manipulating the element's style property. We can start by setting the element's opacity to 1 and then gradually decreasing it over time using the setInterval or setTimeout function. Finally, we can remove the element from the DOM once the opacity reaches 0. Fade-out Effect A fade-out effect is a visual transition where an element gradually becomes less visible over a period of time. This effect is commonly used in web design and animation to create a smooth transition between elements on a page or to hide an element from view. ... Read More
We can add default vertical scaling to a text canvas using Fabric.js by first creating a text object and then setting the "scaleY" property to the desired scaling value. Additionally, we can use the "setCoords()" method to update the object's coordinates to reflect the scaling change. Before diving into the approach let’s just have a quick look what Fabric.js is − What is Fabric.js? Fabric.js is a JavaScript library for creating and manipulating HTML5 canvas elements. It allows developers to create and manipulate canvas elements using an object-oriented API, making it easy to add, edit, and delete shapes, text, images, ... Read More
We can add default horizontal scaling to a canvas-type text by accessing the canvas context and setting the scale property to a specific value. This can be done by calling the context's scale method and passing in the desired value for the horizontal scaling. By doing this, all text drawn on the canvas will have the default horizontal scaling applied to it. HTML Canvas HTML canvas is a 2D drawing surface that can be used to create dynamic and interactive graphics, charts, and animations on web pages. It is an HTML element that allows developers to draw graphics using JavaScript. ... Read More