There are a whole contingent of conditions you need to think through, and then pick the type of data that is right for your needs. Likewise, you may want to test for inappropriate values, such as using text as input rather than numbers (or vice versa). For instance, testing with large values, small values, or a combination of large and small values. This is particularly true when you are testing boundaries of your formulas. Random data may not be appropriate for your testing needs, however. The difference is that RAND generates a value between 0 and 1, and RANDBETWEEN generates integer values between any bounds you set. There are tools in Excel, however, that you can use toward this end.įirst, if you need to generate random numeric values, you can use the RAND or RANDBETWEEN worksheet functions. Unfortunately, there is no quick cure-all that will automatically figure out what you need and generate the data for you. How rigorous you are in compiling test data depends, in large part, on the needs of your audience and the nature of your worksheet. The concept of testing a worksheet means that you will need to generate some sort of data to use in testing the worksheet.Įntire books have been written on putting together testing suites for software. This is particularly true of worksheets that contain complex formulas or will be used for critical purposes. When you develop worksheets that will be used by other people, you should test those worksheets to make sure that they work as you expect.
0 kommentar(er)
