operand is one of the following: constant is a number or a quoted character string (or other special notation) that indicates a fixed value. Constants are also called literals. Constants are described ...
Every few months, someone discovers the Google Sheets QUERY function and has the same reaction: why did nobody tell me about this? Here is what it does and why it changes how you work with data.