Excel Study Cards
Click any card to reveal the answer
Click any card to reveal the answer
Adds up all numbers in a range of cells
Calculates the arithmetic mean of a range of numbers
Counts the number of cells containing numbers
Counts the number of non-empty cells in a range
Returns the largest value in a range of cells
Returns the smallest value in a range of cells
Performs a logical test and returns different values based on result
Searches for a value in the first column and returns a value from another column
Searches for a value in the first row and returns a value from another row
Returns the value of a cell at a specific row and column intersection
Returns the position of a value within a range
Joins multiple text strings into one string
Extracts a specified number of characters from the left of a text string
Extracts a specified number of characters from the right of a text string
Extracts characters from the middle of a text string
Returns the number of characters in a text string
Converts text to uppercase letters
Converts text to lowercase letters
Capitalizes the first letter of each word
Removes extra spaces from text except single spaces between words
Rounds a number to a specified number of decimal places
Rounds a number up to a specified number of decimal places
Rounds a number down to a specified number of decimal places
Returns the current date
Returns the current date and time
Creates a date from year month and day values
Extracts the year from a date
Extracts the month from a date
Extracts the day from a date
Counts cells that meet a specific criteria
Remember: Use all available resources to study. Flearn alone cannot guarantee success in any exams—make sure to supplement your learning!