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 by Pradeep Kumar
Page 99 of 104
Generate random numbers by giving certain mean and standard deviation in Excel
There may be times when you need to generate a series of random numbers based on specific mean and standard deviation for some scenarios. Below are some guidelines that will help you. Generate random numbers by given Mean and Standard Deviation To solve this, you need to follow the below step-by-step process. Step 1 To begin with, you need to enter your needed mean and standard deviation into two empty cells, in this case, I have selected A1 and A2 as shown in the below screenshot. Step 2 Afterwards, in cell B3, type this formula =NORMINV(RAND(), $B$1, $B$2) and ...
Read MoreHow to accept or reject all changes in Excel?
When you enable change tracking for a workbook, you will have the ability to choose which changes to accept and which to reject. You can make this decision by selecting the Accept/Reject Changes option from the drop-down menu of the Track Changes command button on the Review tab of the Ribbon. Excel will analyze all of the highlighted changes that have been made to the shared file by you and anybody else who has worked on it, and it will give you the option to either accept or reject specific modifications. Excel will show you a warning dialogue box before ...
Read MoreHow to activate cell for editing with single clicking in Excel?
When we need to make changes to anything in any cell, editing is a typical practice. Therefore, it is really necessary to get some practice using the shortcut key for this particular activity. There are times when we have to change the content of the cell. Because we frequently need to amend the formula or debug the formula, the shortcut is quite useful. Often, we may need to edit the formula. In addition, it is essential to practice shortcut keys in order to reduce the amount of time required for particular tasks when you are a new learner. Because of ...
Read MoreHow to add 1 to a specified cell if the cell contains certain text in Excel
Consider that you have a list of names in which one name is repeated multiple times. Now you need to scan the column for the name which is repeated multiple times and add 1 if another repeated name is entered in the specific cells to show the total number of the repeated name. Below shows an example of how to do this. Add 1 to a specified cell if the cell contains certain text with an array formula The array formula below can help you add 1 to a specified cell if a cell range contains certain text in the ...
Read MoreHow to add a character before each word in a cell in Excel
The purpose of this article is to show you how you can use a formula in Excel in order to add a specified character before each word in a cell. Add a Character before each word in a cell with the Formula The following instructions will help you to add one or a few characters before each word that appears in an Excel cell. Step 1 Open an Excel workbook, select a cell blank cell and enter the below formula mentioned formula into the formula bar and then press Enter key. =”Character”&SUBSTITUTE(cell reference, ’’ “, “character”) Consider you ...
Read MoreHow to add a scrollbar to a chart in Excel
You can use the scrollbar feature to show a chart with lots of data, just by dragging the scrollbar, you will see the data changing continuously while it's being displayed in the chart. If a lot of data needs to be shown, you can add the scrollbar. However, there is a tricky part in Excel when it comes to adding a scrollbar to a chart, so follow these steps step by step to finish this task. Add a Scrollbar in Excel You have the following data range wherein you want to add the scrollbar chart to the Excel worksheet. ...
Read MoreExcel cell conversion tutorial – Convert units, text and number, currencies, time zones, etc
When dealing with data in Excel, there are instances when you may find that you need to do certain data conversions on cells, such as converting units, converting currencies, converting time zones, and so on. Convert Units In most cases, when we need to convert a number from one unit of measure to another, we will utilize the CONVERT function. However, the CONVERT function will not operate properly for some of the unit conversions that you attempt. Step 1 You may use the CONVERT function to convert the inches specified in the range to the corresponding values in feet, centimeters, ...
Read MoreDifference between Sync and Backup
The act of copying data from one area to another, typically from one hard drive to another, is what we normally call as "backing up." This can be done manually or automatically. Synchronization is the process of ensuring that two different sites have the same collection of files by manually or automatically copying or deleting them as required. Syncing is a faster option, but it comes with a risk. Read through this article to find out more about Sync and Backup and how they are different from each other. What is Sync? Synchronization (sync) is the process of ensuring that ...
Read MoreDifference between PowerShell and CMD
The history of "batch file scripting" can be traced all the way back to 1981, when the first version of MS-DOS was made available as an operating system for IBM personal computers. It was essentially a copy of the CP/M operating system that was developed by Digital Research. CP/M was one of the very first computer operating systems. Microsoft built it so that it could run on IBM PCs, operating as both the kernel and the shell, and it also included several functionalities that are seen in other shells. Over the years, Microsoft has released multiple versions of DOS, which ...
Read MoreDifference between IoT and Cloud Computing
One of the most significant distinctions between "cloud computing" and the "Internet of Things" is that cloud computing offers hosted services through the Internet, while the Internet of Things does not. On the other hand, IoT connects smart devices in the area to the network so they can share and analyse data that helps them make decisions. What is IoT? The phrase "Internet of Things, " sometimes known as "IoT, " refers to the collective network of linked objects as well as the technology that permits communication between devices and the cloud, as well as between the devices themselves. As ...
Read More