Basic Formulas
This function adds up a range of cells
What is SUM?
This function converts text to all lowercase letters
What is LOWER?
This function returns one value if a condition is true and another if false
What is IF?
T or F: Formulas can reference cells on different worksheets
What is TRUE?
This symbol is used at the beginning of every Excel formula
What is an equal sign?
This function calculates the middle value in a dataset
What is MEDIAN?
This function extracts a specified number of characters from the left side of text
What is LEFT?
This function returns TRUE only if all arguments are true
What is AND?
This function calculates the number of days between two dates
What is DAYS?
This wildcard represents any single character in search functions
What is a question mark?
This function returns the highest value in a range
What is MAX?
This function returns the number of characters in a text string
What is LEN?
This function returns TRUE if any argument is true
What is OR?
This function searches for a value in the top row and returns a value in the same column
What is HLOOKUP?
This wildcard represents any number of characters in search functions
What is an asterisk?
This function counts how many cells contain numbers in a range
What is COUNT?
This function combines text from multiple cells into one cell
What is CONCATENATE (or CONCAT)?
These two symbols together represent 'not equal to'
What is <>?
This function searches for a value in the leftmost column and returns a value in the same row
What is VLOOKUP?
This symbol is used to separate arguments in a formula
What is a comma?
This function calculates the arithmetic mean of a dataset
What is AVERAGE?
This symbol connects two values to produce one continuous text value
What is &?
This function counts cells that meet a single criteria
What is COUNTIF?
This modern function can search both horizontally and vertically, replacing VLOOKUP
What is XLOOKUP?
This symbol locks a cell reference so it won't change when copied
What is a dollar sign?