Perform searches using a variety of operators including AND, OR, NOT, >, <, =, >=, <=, <>
Use functions including sum, average, maximum, minimum, integer, rounding, counting, LOOKUP, VLOOKUP, HLOOKUP, XLOOKUP, IF
Set appropriate data types to fields including text, numeric (integer, decimal, currency), date/time, Boolean/logical