How to Generate Random Spreadsheet Data in Microsoft Excel

How to Generate Random Spreadsheet Data in Microsoft Excel [ Full Tutorial ]

Description:

In this tutorial, we will discuss How to generate random data in Microsoft Excel. When we apply or perform different operations and tools of Microsoft Excel program, a big dummy or sample data is required to execute these operations. Two function use for generates random values in Microsoft Excel. How to generate random spreadsheet data in Microsoft Excel.

How to Generate Random Spreadsheet Data in Microsoft Excel

Author Writer: Arshad Sultan [ Expert ]
Author Uploaded:  Arshad Sultan

Download Official Link: https://products.office.com/en-us/microsoft-excel-2007 ]

Tutorial About:

1> How To Use RAND() Function [ EasyWay ]

2> How To Use RANDBETWEEN() Function [ EasyWay ]

3> How To Use Function [ Latest To Old Version ]

Version: 2007 To 2013

  1. RAND() Function.
  2. RANDBETWEEN() Function

How to Generate Random Spreadsheet Data in Microsoft Excel

Let’s start working, how to generate random spreadsheet data in Microsoft Excel.

Function No. 01 : RAND() Function.

RANd Function returns an evenly distributed random real number greater than or equal to 0 and less than 1. A new random real number is returned every time the worksheet is calculated.

Syntax:

=rand()    A random number between 0 and 1 (varies) .

Example 01:

Type rand() function in the cell where you want to enter random data.

=rand() (Enter)

ScreenShot:

How to Generate Random Spreadsheet Data in Microsoft Excel

 

 

 

 

 

 

 

 

 

 

 

Example 02:

=rand()*100 (Enter)

How to Generate Random Spreadsheet Data in Microsoft Excel

How to Generate Random Spreadsheet Data in Microsoft Excel In Easy Way

Note:  If you want to increase/decrease decimal in value then you can use number tools in home ribbon.

How to Generate Random Spreadsheet Data in Microsoft Excel

Contact:

Any Kind Of Help Or Needs So Contact Me:
Facebook Group: [ https://www.facebook.com/Tutorials-Ocean-185506455425271/ ]

TAGS:

rand function, random a function, how to use rand function on excel, how to use rand function on latest excel, how i can use rand and randbetween function, in detail how to use rand function in excel, how to use rand function in easy and simple way

 

, , , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *