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
Computers Articles
Page 16 of 100
How to group Multiple Option/Radio Buttons in Excel
Grouping will save a lot of time when users need to perform the same task repeatedly. In more, simple word changes made to the single sheet will be reflected in multiple grouped sheets simultaneously. radio/ open buttons are a type of control buttons available in Excel. A group of multiple open/radio buttons can be created by using two form buttons and by using two ActiveX buttons. Both processes are based on almost based on same steps. But the second process will need a few extra steps to perform the same tasks. In short, it can be said that using the ...
Read MoreHow to go to the First or Last Empty Row in Excel?
This article focusses about the evaluation of the first and last empty rows. To accomplish the provided task, it is better to use VBA code. VBA is an acronym for visual basic analysis. It is a Microsoft programming language used for office applications. It contains a coding script. Code can run like other front-end programming languages. Empty rows are those that do not contain any data but are available in the provided table structure. During this strategy user learn how to open the VBA editor, and steps to execute the defined module. Examples to go to Evaluate the First ...
Read MoreHow to go to a Specific Sheet in Excel
Nowadays, many tutorials and guides are available, to guide the user about the shortcut or easy ways to access the same work, in a shorter time. This will help user to save time and increases their processing speed. Similarly, this article will try to teach two methods to access specific sheets within excel. List of example strategies, we are going to use for this article: The first example, allows the user to switch the sheet directly. Second, an example guides the user about the strategy by using which ...
Read MoreHow to Get the Current Sheet Number of a Workbook?
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 MoreHow to generate only random even or odd numbers in Excel?
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 MoreHow to Generate all Prime Numbers between two given Numbers in Excel?
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 MoreDifference Between ANSI Lumens and Lumens
ANSI lumens and lumens are both brightness measurements; however, they differ in how the measurement is standardized and how the measurement is done. Lumens are a measure of overall light output, whereas ANSI lumens are a standardized measure of brightness that takes certain testing conditions into account. Read this article to find out more about ANSI Lumens and Lumens and how they are different from each other. What is ANSI Lumens? ANSI lumens are a standardized brightness measurement used specifically for projectors. The acronym "ANSI" stands for the American National Standards Institute, a non-profit organization that creates standards for ...
Read MoreDifference between Ultra ATA and SATA
Ultra ATA and SATA (Serial ATA) are two separate interfaces used to connect storage devices to a computer system, such as hard disc drives (HDDs) and solid-state drives (SSDs). Both interfaces have previously been widely used on several generations of devices. Read this article to find out more about Ultra ATA and SATA and how they are different from each other. What is Ultra ATA? Ultra ATA (also known as IDE or PATA, or Parallel ATA) is an older interface standard that was commonly used for connecting storage devices to computer systems, such as hard disc drives (HDDs) and optical ...
Read MoreDifference between SATA and SATA II
SATA (Serial ATA) and SATA II (sometimes known as SATA 2.0) are two variants of the Serial ATA interface that are used to connect storage devices to the motherboard of a computer. They are most commonly used to connect hard drives, solid-state drives (SSDs), and optical devices. Read this article to find out more about SATA and SATA II and how they are different from each other. What is SATA? Serial ATA (SATA) is an acronym for Serial ATA, a computer bus interface that is often used to connect storage devices to a computer's motherboard. It is the modern ...
Read MoreDifference between HDMI and Optical Cable
In the domain of audio and video communications, two popular methods for transferring digital signals are HDMI (High-Definition Multimedia Interface) and Optical (also known as TOSLINK or SPDIF). Both are used to transmit audio and video data from one device to another, such as from a media player to a TV or audio receiver. Read this article to find out more about HDMI and Optical and how they are different from each other. What is HDMI? HDMI (High-Definition Multimedia Interface) is a popular digital interface for transmitting high-quality audio and video signals across different electronic devices. It was introduced in ...
Read More