Entering Test Data Fast

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.

  1. Select cell B3 in the Excel sheet that contains the table you created previously.

  2. 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).

    Working with formulas.

    Figure 1-10. Working with formulas.

  3. Press the Enter key. A random number from 1,000 through 500,000 appears in the cell (see Figure 1-11).

    The RANDBETWEEN function calculates a random value.

    Figure 1-11. The RANDBETWEEN function calculates a random value.

  4. Select the cell and double-click the fill handle. The Purchase column is automatically filled through December (see Figure 1-12).

    Values are added within seconds.

    Figure 1-12. Values are added within seconds.

  5. Edit the table however you want.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.226.251.206