Question 15
Question 15 of 16

Question image for Q15
Topics Tested

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