Prepare test data

Prepare 1000 rows of test data: generate the serial number of item in proper order, randomly generate the unit price and purchase quantity, and compute the total price. The unit price is between 1 yuan ĘC 100 yuan with two decimal places. The purchase quantity is an integer between 1 and 1000.

Solution:

A B
1 =create(ID,UnitPrice,Quantity)
2 for 1000
=round(int(rand(9900))/100+1,2)
3
=int(rand(1000))+1
4
>A1.insert(0,A2,B2,B3)
5 =A1.derive(round(UnitPrice*Quantity,2):Total)

Ultimately, the result in A5 is shown below: