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: