Spreadsheet which refers to programs like Microsoft Excel and
Google Sheets used for organizing and analyzing data.
AVERAGEIF: A spreadsheet function that returns the average of all
cell values from a given range that meets a specified condition.
MAXIFS: A spreadsheet function that returns the maximum value from
a given range that meets a specified condition.
MINIFS: A spreadsheet function that returns the minimum value from
a given range that meets a specified condition.
COUNTIF: A spreadsheet function that returns the number of cells
that match a specified value.
LEN: A spreadsheet function that tells you the length of the text string
by counting the number of characters it contains.
FIND: A spreadsheet function that locates specific characters and
substrings in a string.
VALUE: A spreadsheet function that converts a text string that
represents a number to a numerical value.
MATCH: A spreadsheet function used to locate the position of a
specific lookup value.
LEFT: A spreadsheet function that gives you a set number of
characters from the left side of a text string.
RIGHT: A spreadsheet function that gives you several characters from
the right side of a text string.
MID: A spreadsheet function that gives you a segment from the middle
of a text string.
TRIM: A spreadsheet function that removes leading, trailing, and
repeated spaces in data.
VLOOKUP: A spreadsheet function that searches for a certain value in
a column to return a corresponding piece of information
SPLIT: A spreadsheet function that divides text around a specified
character and each fragment into a new separate cell.
TRUE: A true statement is in ascending order.
FALSE: A false statement is in descending order.
COUNTA: A spreadsheet function that counts the total number of
values within a specified range.
CASE: A spreadsheet function that goes through one or more
Google Sheets used for organizing and analyzing data.
AVERAGEIF: A spreadsheet function that returns the average of all
cell values from a given range that meets a specified condition.
MAXIFS: A spreadsheet function that returns the maximum value from
a given range that meets a specified condition.
MINIFS: A spreadsheet function that returns the minimum value from
a given range that meets a specified condition.
COUNTIF: A spreadsheet function that returns the number of cells
that match a specified value.
LEN: A spreadsheet function that tells you the length of the text string
by counting the number of characters it contains.
FIND: A spreadsheet function that locates specific characters and
substrings in a string.
VALUE: A spreadsheet function that converts a text string that
represents a number to a numerical value.
MATCH: A spreadsheet function used to locate the position of a
specific lookup value.
LEFT: A spreadsheet function that gives you a set number of
characters from the left side of a text string.
RIGHT: A spreadsheet function that gives you several characters from
the right side of a text string.
MID: A spreadsheet function that gives you a segment from the middle
of a text string.
TRIM: A spreadsheet function that removes leading, trailing, and
repeated spaces in data.
VLOOKUP: A spreadsheet function that searches for a certain value in
a column to return a corresponding piece of information
SPLIT: A spreadsheet function that divides text around a specified
character and each fragment into a new separate cell.
TRUE: A true statement is in ascending order.
FALSE: A false statement is in descending order.
COUNTA: A spreadsheet function that counts the total number of
values within a specified range.
CASE: A spreadsheet function that goes through one or more
