Table Tab

The Table tab on the User Preferences window includes the following options:

OptionFunction

Warn if table data includes zero or NaN values

Displays a warning if there is null or no data values for a date.

Remove data in table if row has a zero or NaN values

Removes null or no data, if it exists.

Show summary stats

Selected by default. Includes summary statistics, such as the sum, averages, percentages, and the standard deviation.

Skip weekendsExcludes weekend data (data for a Saturday or a Sunday).

This feature can only be selected when using the following Execution Units in the Worksheet Options pane: Days, Hours, Minutes, Seconds and Milliseconds.

Sort by: Date AscendingSorts the table data by the oldest date first.
Sort by: Date DescendingSorts the table data by the most recent date first.