Share
Explore
Quiz Settings
Question to Study
Questions to Study
Groups
Checkbox
Search
Question
Answer
Groups
Checkbox
1
What
operator
matches this description:Greater than
>
Logical
2
What
operator
matches this description:Less than
<
Logical
3
What
operator
matches this description:Great than or equal
>=
Logical
4
What
operator
matches this description:Less than or equal
<=
Logical
5
What
operator
matches this description:Equal
=
Logical
6
What
operator
matches this description:Is not equal to
!=
Logical
7
What
operator
matches this description:Add
+
Numeric
8
What
operator
matches this description:Subtract
-
Numeric
9
What
operator
matches this description:Multiply
*
Numeric
10
What
operator
matches this description:Divide
/
Numeric
11
What
operator
matches this description:Concatenate text values
&
Text
12
What
function
matches this description:Join the array of items into a string with a separator.
ARRAYJOIN()
Text
13
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
14
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
15
What
function
matches this description:Finds an occurrence of one string inside another.
FIND()
Text
16
What
function
matches this description:Extract howMany characters from the beginning of the string.
LEFT()
Text
17
What
function
matches this description:Returns the length of a string.
LEN()
Text
18
What
function
matches this description:Makes a string lowercase.
LOWER()
Text
19
What
function
matches this description:Extract a substring of count characters starting at whereToStart.
MID()
Text
20
What
function
matches this description:Replaces the number of characters beginning with the start character with the replacement text.
REPLACE()
Text
21
What
function
matches this description:Repeats string by the specified number of times.
REPT()
Text
22
What
function
matches this description:Extract howMany characters from the end of the string.
RIGHT()
Text
23
What
function
matches this description:Searches for an occurrence of one string inside another.
SEARCH()
Text
24
What
function
matches this description:Replaces occurrences of old_text with new_text.
SUBSTITUTE()
Text
25
What
function
matches this description:Returns the argument if it is text and blank otherwise.
T()
Text
26
What
function
matches this description:Removes whitespace at the beginning and end of string.
TRIM()
Text
27
What
function
matches this description:Makes string uppercase.
UPPER()
Text
28
What
function
matches this description:Returns true if all the arguments are true, returns false otherwise.
AND()
Logical
29
What
function
matches this description:Returns a blank value.
BLANK()
Logical
30
What
function
matches this description:Returns the error value.
ERROR()
Logical
31
What
function
matches this description:Logical value false. False is represented numerically by a 0.
FALSE()
Logical
32
What
function
matches this description:Returns value1 if the logical expression is true, otherwise it returns value2.
IF()
Logical
33
What
function
matches this description:Returns true if the expression causes an error.
ISERROR()
Logical
34
What
function
matches this description:Reverses the logical value of its argument.
NOT()
Logical
35
What
function
matches this description:Returns true if any one of the arguments is true.
OR()
Logical
36
What
function
matches this description:Converts values into new values. For each original value, it matches the other value to use. Mapping
SWITCH()
Logical
37
What
function
matches this description:Logical value true. The value of true is represented numerically by a 1.
TRUE()
Logical
38
What
function
matches this description:Returns true if an odd number of arguments are true.
XOR()
Logical
39
What
function
matches this description:Returns the absolute value.
ABS()
Numeric
40
What
function
matches this description:Returns the average of the numbers.
AVERAGE()
Numeric
41
What
function
matches this description:Always rounds up to next place value determined by user. Defaults precision to 1
CEILING()
Numeric
42
What
function
matches this description:Count the number of numeric items.
COUNT()
Numeric
43
What
function
matches this description:Count the number of non-empty values. This function counts both numeric and text values.
COUNTA()
Numeric
44
What
function
matches this description:Count the number of all elements including text and blanks.
COUNTALL()
Numeric
45
What
function
matches this description:Returns the smallest even integer that is greater than or equal to the specified value.
EVEN()
Numeric
46
What
function
matches this description:Computes Euler's number (e) to the specified power.
EXP()
Numeric
47
What
function
matches this description:Always rounds number down to place value indicated by user. Defaults precision to 1.
FLOOR()
Numeric
48
What
function
matches this description:Returns the greatest integer that is less than or equal to the specified value.
INT()
Numeric
49
What
function
matches this description:Computes the logarithm of the value in provided base. The base defaults to 10 if not specified.
LOG()
Numeric
50
What
function
matches this description:Returns the largest of the given numbers.
MAX()
Numeric
51
What
function
matches this description:Returns the smallest of the given numbers.
MIN()
Numeric
52
What
function
matches this description:Returns the remainder after dividing the first argument by the second.
MOD()
Numeric
53
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
54
What
function
matches this description:Computes the specified base to the specified power.
POWER()
Numeric
55
What
function
matches this description:Rounds the value to the number of decimal places given by "precision.".
ROUND()
Numeric
56
What
function
matches this description:Rounds the value to the number of decimal places given by "precision," down. MUST add precision
ROUNDDOWN()
Numeric
57
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
58
What
function
matches this description:Returns the square root of a nonnegative number.
SQRT()
Numeric
59
What
function
matches this description:Sum together the numbers. Equivalent to number1 + number2 + ...
SUM()
Numeric
60
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
61
What
function
matches this description:Returns the date and time a given record was created.
CREATED_TIME()
Date/Time
62
What
function
matches this description:Adds specified "count" units to a datetime. Specify units (months, days, years etc.)
DATEADD()
Date/Time
63
What
function
matches this description:Formats a datetime into a string (YYYY-MM-DD).
DATESTR()
Date/Time
64
What
function
matches this description:Returns the difference between datetimes in specified units.
DATETIME_DIFF()
Date/Time
65
What
function
matches this description:Formats a datetime into a specified string.
DATETIME_FORMAT()
Date/Time
66
What
function
matches this description:Turns text string into date object.
DATETIME_PARSE()
Date/Time
67
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
68
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
69
What
function
matches this description:Determines if [date1] is later than [date2]. Returns 1 if yes, 0 if no.
IS_AFTER()
Date/Time
70
What
function
matches this description:Determines if [date1] is earlier than [date2]. Returns 1 if yes, 0 if no.
IS_BEFORE()
Date/Time
71
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
72
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
73
What
function
matches this description:Returns the minute of a datetime as an integer between 0 and 59.
MINUTE()
Date/Time
74
What
function
matches this description:Returns the month of a datetime as a number between 1 (January) and 12 (December).
MONTH()
Date/Time
75
What
function
matches this description:Returns the current date AND time. NOT updated regularly
NOW()
Date/Time
76
What
function
matches this description:Returns the second of a datetime as an integer between 0 and 59.
SECOND()
Date/Time
77
What
function
matches this description:Sets a specific locale for a datetime. Must be used in conjunction with DATETIME_FORMAT.
SET_LOCALE()
Date/Time
78
What
function
matches this description:Sets a specific timezone for a datetime. Must be used in conjunction with DATETIME_FORMAT.
SET_TIMEZONE()
Date/Time
79
What
function
matches this description:Formats a datetime into a time-only string (HH:mm:ss).
TIMESTR()
Date/Time
80
What
function
matches this description:Calculates the length of time between given date and now
FROMNOW()
Date/Time
81
What
function
matches this description:Calculates the length of time between given date and now
TONOW()
Date/Time
82
What
function
matches this description:Returns the current date with the time of 12:00am GMT. Not updated regularly.
TODAY()
Date/Time
83
What
function
matches this description:Returns the day of the week as an integer between 0 and 6.
WEEKDAY()
Date/Time
84
What
function
matches this description:Returns the week number in a year.
WEEKNUM()
Date/Time
85
What
function
matches this description:Returns a date that is numDays working days after startDate.
WORKDAY()
Date/Time
86
What
function
matches this description:Counts the number of working days between startDate and endDate.
WORKDAY_DIFF()
Date/Time
87
What
function
matches this description:Returns the four-digit year of a datetime.
YEAR()
Date/Time
88
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
89
What
function
matches this description:Flattens the array by removing any array nesting. All items become elements of a single array.
ARRAYFLATTEN()
Array
90
What
function
matches this description:Join the array of items into a string with a separator.
ARRAYJOIN()
Text
91
What
function
matches this description:Returns only unique items in the array.
ARRAYUNIQUE()
Array
92
What
function
matches this description:Returns the date and time a given record was created.
CREATED_TIME()
Date/Time
93
What
function
matches this description:Returns the ID of the current record.
RECORD_ID()
Record
94
What
function
matches this description:Returns whether the input text matches a regular expression.
REGEX_MATCH()
RegEx
Text
95
What
function
matches this description:Returns the first substring that matches a regular expression.
REGEX_EXTRACT()
RegEx
Text
96
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
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.