Quiz Settings
Question to Study
Filter this view of the to include only the questions you want to include in your next quiz. Filter by question group or use the checkbox to hand pick specific questions.
Questions to Study
Groups
Checkbox
Search
Question
Answer
Groups
Checkbox
What
operator
matches this description:Greater than
>
Logical
What
operator
matches this description:Less than
<
Logical
What
operator
matches this description:Great than or equal
>=
Logical
What
operator
matches this description:Less than or equal
<=
Logical
What
operator
matches this description:Equal
=
Logical
What
operator
matches this description:Is not equal to
!=
Logical
What
operator
matches this description:Add
+
Numeric
What
operator
matches this description:Subtract
-
Numeric
What
operator
matches this description:Multiply
*
Numeric
What
operator
matches this description:Divide
/
Numeric
What
operator
matches this description:Concatenate text values
&
Text
What
function
matches this description:Join the array of items into a string with a separator.
ARRAYJOIN()
Text
What
function
matches this description:Joins together the text arguments into a single text value.
To concatenate static text, surround it with double quotation marks. To concatenate double quotation marks, you need to use a backslash (\) as an escape character.
CONCATENATE()
Text
What
function
matches this description:Replaces certain characters with encoded equivalents for use in constructing URLs or URIs. Does not encode the following characters: - _ . ~
ENCODE_URL_COMPONENT()
Text
What
function
matches this description:Finds an occurrence of one string inside another.
FIND()
Text
What
function
matches this description:Extract howMany characters from the beginning of the string.
LEFT()
Text
What
function
matches this description:Returns the length of a string.
LEN()
Text
What
function
matches this description:Makes a string lowercase.
LOWER()
Text
What
function
matches this description:Extract a substring of count characters starting at whereToStart.
MID()
Text
What
function
matches this description:Replaces the number of characters beginning with the start character with the replacement text.
REPLACE()
Text
What
function
matches this description:Repeats string by the specified number of times.
REPT()
Text
What
function
matches this description:Extract howMany characters from the end of the string.
RIGHT()
Text
What
function
matches this description:Searches for an occurrence of one string inside another.
SEARCH()
Text
What
function
matches this description:Replaces occurrences of old_text with new_text.
SUBSTITUTE()
Text
What
function
matches this description:Returns the argument if it is text and blank otherwise.
T()
Text
What
function
matches this description:Removes whitespace at the beginning and end of string.
TRIM()
Text
What
function
matches this description:Makes string uppercase.
UPPER()
Text
What
function
matches this description:Returns true if all the arguments are true, returns false otherwise.
AND()
Logical
What
function
matches this description:Returns a blank value.
BLANK()
Logical
What
function
matches this description:Returns the error value.
ERROR()
Logical
What
function
matches this description:Logical value false. False is represented numerically by a 0.
FALSE()
Logical
What
function
matches this description:Returns value1 if the logical expression is true, otherwise it returns value2.
IF()
Logical
What
function
matches this description:Returns true if the expression causes an error.
ISERROR()
Logical
What
function
matches this description:Reverses the logical value of its argument.
NOT()
Logical
What
function
matches this description:Returns true if any one of the arguments is true.
OR()
Logical
What
function
matches this description:Converts values into new values. For each original value, it matches the other value to use. Mapping
SWITCH()
Logical
What
function
matches this description:Logical value true. The value of true is represented numerically by a 1.
TRUE()
Logical
What
function
matches this description:Returns true if an odd number of arguments are true.
XOR()
Logical
What
function
matches this description:Returns the absolute value.
ABS()
Numeric
What
function
matches this description:Returns the average of the numbers.
AVERAGE()
Numeric
What
function
matches this description:Always rounds up to next place value determined by user. Defaults precision to 1
CEILING()
Numeric
What
function
matches this description:Count the number of numeric items.
COUNT()
Numeric
What
function
matches this description:Count the number of non-empty values. This function counts both numeric and text values.
COUNTA()
Numeric
What
function
matches this description:Count the number of all elements including text and blanks.
COUNTALL()
Numeric
What
function
matches this description:Returns the smallest even integer that is greater than or equal to the specified value.
EVEN()
Numeric
What
function
matches this description:Computes Euler's number (e) to the specified power.
EXP()
Numeric
What
function
matches this description:Always rounds number down to place value indicated by user. Defaults precision to 1.
FLOOR()
Numeric
What
function
matches this description:Returns the greatest integer that is less than or equal to the specified value.
INT()
Numeric
What
function
matches this description:Computes the logarithm of the value in provided base. The base defaults to 10 if not specified.
LOG()
Numeric
What
function
matches this description:Returns the largest of the given numbers.
MAX()
Numeric
What
function
matches this description:Returns the smallest of the given numbers.
MIN()
Numeric
What
function
matches this description:Returns the remainder after dividing the first argument by the second.
MOD()
Numeric
What
function
matches this description:Rounds positive value up the the nearest odd number and negative value down to the nearest odd number.
ODD()
Numeric
What
function
matches this description:Computes the specified base to the specified power.
POWER()
Numeric
What
function
matches this description:Rounds the value to the number of decimal places given by "precision.".
ROUND()
Numeric
What
function
matches this description:Rounds the value to the number of decimal places given by "precision," down. MUST add precision
ROUNDDOWN()
Numeric
What
function
matches this description:Rounds the value to the number of decimal places given by "precision," always rounding up, MUST add precision
ROUNDUP()
Numeric
What
function
matches this description:Returns the square root of a nonnegative number.
SQRT()
Numeric
What
function
matches this description:Sum together the numbers. Equivalent to number1 + number2 + ...
SUM()
Numeric
What
function
matches this description:Converts the text string to a number. If string has non numeric characters, result may not be as expected.
VALUE()
Numeric
What
function
matches this description:Returns the date and time a given record was created.
CREATED_TIME()
Date/Time
What
function
matches this description:Adds specified "count" units to a datetime. Specify units (months, days, years etc.)
DATEADD()
Date/Time
What
function
matches this description:Formats a datetime into a string (YYYY-MM-DD).
DATESTR()
Date/Time
What
function
matches this description:Returns the difference between datetimes in specified units.
DATETIME_DIFF()
Date/Time
What
function
matches this description:Formats a datetime into a specified string.
DATETIME_FORMAT()
Date/Time
What
function
matches this description:Turns text string into date object.
DATETIME_PARSE()
Date/Time
What
function
matches this description:Returns the day of the month of a datetime in the form of a number between 1-31.
DAY()
Date/Time
What
function
matches this description:Returns the hour of a datetime as a number between 0 (12:00am) and 23 (11:00pm).
HOUR()
Date/Time
What
function
matches this description:Determines if [date1] is later than [date2]. Returns 1 if yes, 0 if no.
IS_AFTER()
Date/Time
What
function
matches this description:Determines if [date1] is earlier than [date2]. Returns 1 if yes, 0 if no.
IS_BEFORE()
Date/Time
What
function
matches this description:Compares two dates up to a unit and determines whether they are identical. Returns 1 if yes, 0 if no.
IS_SAME()
Date/Time
What
function
matches this description:Returns date and time of most recent modification to a non computed field in the record
LAST_MODIFIED_TIME()
Date/Time
What
function
matches this description:Returns the minute of a datetime as an integer between 0 and 59.
MINUTE()
Date/Time
What
function
matches this description:Returns the month of a datetime as a number between 1 (January) and 12 (December).
MONTH()
Date/Time
What
function
matches this description:Returns the current date AND time. NOT updated regularly
NOW()
Date/Time
What
function
matches this description:Returns the second of a datetime as an integer between 0 and 59.
SECOND()
Date/Time
What
function
matches this description:Sets a specific locale for a datetime. Must be used in conjunction with DATETIME_FORMAT.
SET_LOCALE()
Date/Time
What
function
matches this description:Sets a specific timezone for a datetime. Must be used in conjunction with DATETIME_FORMAT.
SET_TIMEZONE()
Date/Time
What
function
matches this description:Formats a datetime into a time-only string (HH:mm:ss).
TIMESTR()
Date/Time
What
function
matches this description:Calculates the length of time between given date and now
FROMNOW()
Date/Time
What
function
matches this description:Calculates the length of time between given date and now
TONOW()
Date/Time
What
function
matches this description:Returns the current date with the time of 12:00am GMT. Not updated regularly.
TODAY()
Date/Time
What
function
matches this description:Returns the day of the week as an integer between 0 and 6.
WEEKDAY()
Date/Time
What
function
matches this description:Returns the week number in a year.
WEEKNUM()
Date/Time
What
function
matches this description:Returns a date that is numDays working days after startDate.
WORKDAY()
Date/Time
What
function
matches this description:Counts the number of working days between startDate and endDate.
WORKDAY_DIFF()
Date/Time
What
function
matches this description:Returns the four-digit year of a datetime.
YEAR()
Date/Time
What
function
matches this description:Removes empty strings and null values from the array. Keeps "false" and strings that contain one or more blank characters.
ARRAYCOMPACT()
Array
What
function
matches this description:Flattens the array by removing any array nesting. All items become elements of a single array.
ARRAYFLATTEN()
Array
What
function
matches this description:Join the array of items into a string with a separator.
ARRAYJOIN()
Text
What
function
matches this description:Returns only unique items in the array.
ARRAYUNIQUE()
Array
What
function
matches this description:Returns the date and time a given record was created.
CREATED_TIME()
Date/Time
What
function
matches this description:Returns the ID of the current record.
RECORD_ID()
Record
What
function
matches this description:Returns whether the input text matches a regular expression.
REGEX_MATCH()
RegEx
Text
What
function
matches this description:Returns the first substring that matches a regular expression.
REGEX_EXTRACT()
RegEx
Text
What
function
matches this description:Substitutes all matching substrings with a replacement string value.
REGEX_REPLACE()
RegEx
Text
There are no rows in this table
This quiz is free, but creating it takes time and money.
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.