Quantum XL supports a feature called 'Smart Select'. This features allows you to select an entire column (or row) and Quantum XL will automatically select just the cells in that column that have data. This allows you to select data more quickly. It is particularly helpful if you have large amounts of data.
Source Data - Simple column of numbers, but the user has selected the entire column F.
Select any statistical tool. In this case, we used a Cpk. Note that Quantum XL has looked at the column and found that the numeric values are in cells F3:F11. This automatically becomes the selection.
Smart Select also works with blank cells and multiple columns. For example, in the data set below the columns E and F were pre-selected by the user.
The user then selected a Cpk. Quantum XL automatically changed the selection to include a single range that contains all the data in columns E and F.
Smart Select is extremely useful if you have large amounts of data. For example, if the data set has 10,000 data points, you are not required to select cells A1:A10001 (which would involve a lot of scrolling to find the end). With Smart Select, all you need to do is pre-select column A and start the analysis.