Now let’s return to the scenario described earlier in the chapter, in the section titled Scenario and Goals. To complete the table with sales and purchase values, you need a set of sample data so that you can create and check the example. A convenient way to do this is to generate a set of random data by using the RANDBETWEEN() function.
Select cell B3 in the Excel sheet that contains the table you created previously.
Enter the following function: =RANDBETWEEN(1000,500000). The values 1000 and 500000 indicate the minimum and maximum values and are divided by the comma (see Figure 1-10).
Press the Enter key. A random number from 1,000 through 500,000 appears in the cell (see Figure 1-11).
Select the cell and double-click the fill handle. The Purchase column is automatically filled through December (see Figure 1-12).
