Actions
A feature that creates rows and columns based on values in the selected cells.
A function that allows the user to make a comparison between two values and then returns a true or false result.
What is IF
A function that performs a vertical lookup to retrieve data from a specific column in a table.
A function that performs a horizontal lookup to retrieve data from a specific row in a table.
What is HLOOKUP
A function that returns the largest value in a range of cells that meet one or more criteria.
What is MAXIF
A setting that allows data to be formatted a certain way if the user-defined conditions are met.
What is Conditional Formatting
A function that returns the opposite of a result.
What is NOT
A function that returns the current date and time.
What is NOW
A function that returns the current date.
What is TODAY
A function that returns the smallest value in a range of cells that meet one or more criteria.
What is MINIFS
A tool that allows a user to establish the format of data that is entered into cells.
What is Data Validation
A function that looks at multiple conditions and returns true if at least one condition is met and false if no conditions are met.
What is OR
A function that counts the number of cells in a range that meets one specified criterion.
What is COUNTIF
A function that returns the average in a range of cells based on one specified criterion.
What is AVERAGEIF
A function that allows the user to check for multiple conditions and returns true if all conditions are met and false if any of the conditions are not met.
What is AND
A table that summarizes data from a larger table by providing the user with alternative ways to group the data.
What is a PivotTable
A function that compares a value with a list of values, and then returns a result that corresponds with the first match.
What is SWITCH
A function that allows the user to check multiple IF conditions.
What is IFS
A function that counts the number of cells in a range that meets one or more criteria.
What is COUNTIFS
A function that returns the average in a range of cells based on multiple specified criteria.
What is AVERAGEIFS
A tool that allows the user to view different parts of a nested formula, in the order the formula is calculated.
What is Evaluate Formula
A function that uses a date to return the closest working day in the future or the past.
What is WORKDAY
A function that returns a number from 1-7 that identifies that day of the week from a date.
What is WEEKDAY
A function used to calculate the payments of a loan.
A function that returns the relative position for the specific item in a range of cells.
What is MATCH