Computers Articles - Page 44 of 116

How to generate random value from a given list in Excel?

Namita Aggarwal
Updated on 17-Apr-2023 14:09:30

2K+ Views

This article is designed to allow users to understand the process and can generate random data values, from the provided list of data that is based on some predefined or provided data set or collection. Here, data can be of any type, for example, string, int, and any other. For this article will assume that the available data is of string type. The article contains two examples, first example performs the provided task by using the predefined formula. While the second example will perform the same task by using the kutool. Example 1 − To generate random value from a ... Read More

How to Generate Random Positive and Negative Numbers in Excel?

Namita Aggarwal
Updated on 17-Apr-2023 14:07:45

1K+ Views

Random data is a type of data generated randomly. In this article, the users will learn how to generate random positive and negative numbers by using the predefined available Excel methods, and kutool. Random data can be used for any purpose such as creating a sample data set or evaluating results based on the dataset. This article contains four examples in which the first two examples will allow the user to generate random positive and negative numbers by using available formula methods, while the remaining two examples will allow the user to generate positive and negative numbers by using the ... Read More

How to Generate Random Decimal/Integer Numbers in Excel?

Namita Aggarwal
Updated on 17-Apr-2023 14:05:48

591 Views

Random numbers are the random values, used to obtain some results. It can be used to perform simulations and to understand the pattern of different system components. It is useful when the user requires a large data set to evaluate some common feature. Decimal numbers are numbers that contain some fractional part. For example, ,1.2, and 3.5 are decimal numbers. While integer data contain numbers without fractional parts. An example of integer value is 1, 2, 5, and many other, that does not contain a decimal value. Example 1: To generate a random decimal number in Excel by using the ... Read More

How to Generate Lottery Numbers in Excel?

Namita Aggarwal
Updated on 17-Apr-2023 14:03:51

1K+ Views

Generating lottery numbers by using Excel is an easy and time-saving process. The described task can be done by using two different examples. The first practice involves using the VBA code. The user needs to create a module and execute the module to generate the lottery number. The second example is based on the use of kutools. In the kutools example, the user is required to use a random value function to implement the required functionality. Since the lottery number should be an integer data. Therefore, this tutorial is generating the lottery number with an integer type. To generate the ... Read More

10 Best Computer Networking Books To Learn From

Pranavnath
Updated on 14-Apr-2023 17:45:50

3K+ Views

The computer network is a connection of several computers to form several network topologies to establish communication among the computer devices. The computers can send or receive data from each other with the help of the network which is connected through a medium. The computer network has become a crucial element in every organization, because of its various advantages and also because there is no use of the internet or any other technology without communicating devices, and to establish communication or linkage among the devices computer networking is the fundamental thing. Best Computer Networking Books To keep up with ... Read More

Difference Between DMA and PIO

Md. Sajid
Updated on 14-Apr-2023 14:19:33

4K+ Views

DMA (Direct Memory Access) and PIO (Programmed Input/Output) are two techniques of data transport between a peripheral device and a computer system. DMA (Direct Memory Access) is a data transfer method in which a peripheral device can directly access system memory without involving the CPU. PIO is a technique that allows the CPU to handle data transfers between a peripheral device and system memory. Read this article to find out more about DMA and PIO and how they are different from each other. What is DMA? DMA is a data transfer method in which a peripheral device can directly access ... Read More

Difference Between CMOS and BIOS

Md. Sajid
Updated on 14-Apr-2023 14:15:30

6K+ Views

CMOS (Complementary Metal-Oxide Semiconductor) and BIOS (Basic Input/Output System) are two significant computer system components that serve different purposes. CMOS is a form of technology used in the design of a computer's memory chip that saves crucial configuration data, whereas BIOS is the code that runs on a computer's motherboard and is in charge of initialising and testing hardware components during startup. Read this article to find out more about CMOS and BIOS and how they are different from each other. What is CMOS? CMOS is an abbreviation for complementary metal-oxide semiconductor, which is the sort of technology used in ... Read More

Difference Between ACPI and APM

Md. Sajid
Updated on 14-Apr-2023 13:50:49

937 Views

ACPI (Advanced Configuration and Power Interface) and APM (Advanced Power Management) are both power management systems used in computers to control power consumption and maximize energy efficiency. ACPI is designed to handle power management tasks other than basic on/off functions, such as managing system resources, devices, and processor performance. APM is an older and simpler system that provides fundamental power management functions. Read this article to find out more about ACPI and APM and how they are different from each other. What is ACPI? The ACPI (Advanced Configuration and Power Interface) standard was created by Intel, Microsoft, and Toshiba. ... Read More

Types Of Spanning Tree Protocol (STP)

Pranavnath
Updated on 12-Apr-2023 15:51:08

1K+ Views

STP is one type of network in the computer science field. It is 2 network layer protocol that is used to obstruct problems that appear while computers contest to use shared telecommunications paths through a local area network. A similar segment is ascenders for another segment and affords accordingly, network segmentation helps in decreasing the competition for other networks and also decreases the chances of a network coming to the network platform. It’s very easy to use and it’s also effective in providing support for bridges and switches. It helps in providing a link and reducing redundancy and preventing ... Read More

How to highlight values that appear X times in Excel?

Shubhi Rastogi
Updated on 12-Apr-2023 11:03:13

2K+ Views

In the article, the users are going to highlight the numbers that are present many times or X times in Microsoft Excel. There are several features in the excel sheet including conditional formatting, and format cells that the users have to fill any type of color according to their needs. We can use the formula for changing cell values in the new formatting rule dialog box. To highlight values that appear X times in Excel Step 1 Deliberate the excel sheet with the data. First, open the excel sheet and create the data one by one. In this sheet, type ... Read More

Advertisements