SUM
Explore the Flashcards:
reviewed 1 of 43 
Adds up all numbers in a specified range of cells. Syntax: =SUM(range).
reviewed 2 of 43 
SUMIF
Adds numbers in a range based on a single criterion. Syntax: =SUMIF(range, criteria, [sum_range]).
reviewed 3 of 43 
SUMIFS
Like Sumif, but allows for multiple criteria. Syntax: =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...).
reviewed 4 of 43 
Criteria in SUMIF/SUMIFS
Specific conditions that determine which cells to add, like a certain text or numerical value.
reviewed 5 of 43 
Sum Range
The cells whose values are to be added in Sumif or Sumifs functions.
reviewed 6 of 43 
Criteria Range
The range of cells where Excel looks for the specified criteria in Sumif or Sumifs functions.
Not Reviewed 7 of 43 
COUNT
Counts cells in a range that contain numbers. Syntax: =COUNT(range).
Not Reviewed 8 of 43 
COUNTA
Counts all non-empty cells (including text and numbers). Syntax: =COUNTA(range).
Not Reviewed 9 of 43 
COUNTIF
Counts cells meeting a single specified condition. Syntax: =COUNTIF(range, criteria).
Not Reviewed 10 of 43 
COUNTIFS
Similar to Countif, but counts cells meeting multiple conditions.
Not Reviewed 11 of 43 
Numerical Criteria in COUNTIF/COUNTIFS
Conditions based on numerical values like greater than or less than a specified number.
Not Reviewed 12 of 43 
Text Criteria in COUNTIF/COUNTIFS
Conditions based on specific text strings in cells for counting.
Not Reviewed 13 of 43 
Multiple Conditions in COUNTIFS
Ability to use multiple ranges and criteria for complex counting tasks.
Not Reviewed 14 of 43
Using Quotation Marks in Criteria
How to specify conditions as text strings within quotation marks in COUNTIF and COUNTIFS functions.
Not Reviewed 15 of 43 
VLOOKUP
Retrieves data from a column in a table based on a matching value. Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Not Reviewed 16 of 43 
Lookup Value in VLOOKUP
The value in Excel VLOOKUP used to find the corresponding data in a table
Not Reviewed 17 of 43 
Table Array in VLOOKUP
The range of cells containing the data to be retrieved by VLOOKUP
Not Reviewed 18 of 43 
Column Index Number in VLOOKUP
The column number in the table array from which to retrieve data
Not Reviewed 19 of 43 
Range Lookup in VLOOKUP
Specifies whether VLOOKUP should find an exact match (FALSE) or an approximate match (TRUE)
Not Reviewed 20 of 43 
HLOOKUP
Similar to VLOOKUP, but retrieves data based on a row instead of a column. Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Not Reviewed 21 of 43 
INDEX
Retrieves a value from a specified position within a range. Syntax: =INDEX(array, row_num, [column_num])
Not Reviewed 22 of 43 
Array in INDEX
The range of cells where the Index function searches for the specified value
Not Reviewed 23 of 43 
Row and Column Numbers in INDEX
Specifies the exact position in the array to retrieve the value from
Not Reviewed 24 of 43 
MATCH
Returns the relative position of an item in a range matching a specified value. Syntax: =MATCH(lookup_value, lookup_array, [match_type])
Not Reviewed 25 of 43 
Lookup Value in MATCH
The value for which Match searches within the array
Not Reviewed 26 of 43 
Lookup Array in MATCH
The range of cells where Match looks for the lookup value
Not Reviewed 27 of 43 
Match Type in MATCH
Determines whether Match finds an exact match (0) or the closest match
Not Reviewed 28 of 43 
AVERAGE
Calculates the arithmetic mean of a range of numbers. Syntax: =AVERAGE(number1, [number2], ...)
Not Reviewed 29 of 43 
AVERAGEIF
Computes the average of numbers in a range based on a specific criterion. Syntax: =AVERAGEIF(range, criteria, [average_range])
Not Reviewed 30 of 43 
MAX
Identifies the highest value in a specified range of numbers. Syntax: =MAX(number1, [number2], ...)
Not Reviewed 31 of 43 
MIN
Determines the lowest value in a given array of numbers. Syntax: =MIN(number1, [number2], ...)
Not Reviewed 32 of 43 
CHOOSE
Selects a value from a list based on a specified position number. Syntax: =CHOOSE(index_num, value1, [value2], ...)
Not Reviewed 33 of 43 
Goal Seek
A "What-if" analysis tool in Excel for finding required input values to achieve a specific goal. Part of the Data tab under What-if Analysis
Not Reviewed 34 of 43 
LEFT
Extracts a specified number of characters from the start of a text string. Syntax: =LEFT(text, num_chars)
Not Reviewed 35 of 43 
RIGHT
Retrieves a specified number of characters from the end of a text string. Syntax: =RIGHT(text, num_chars)
Not Reviewed 36 of 43 
MID
Selects characters from a text string starting at a specified position. Syntax: =MID(text, start_num, num_chars)
Not Reviewed 37 of 43 
UPPER
Converts all characters in a text string to uppercase. Syntax: =UPPER(text)
Not Reviewed 38 of 43 
LOWER
Transforms all characters in a text string to lowercase. Syntax: =LOWER(text)
Not Reviewed 39 of 43 
PROPER
Capitalizes the first letter of each word in a text string. Syntax: =PROPER(text)
Not Reviewed 40 of 43 
CONCATENATE
Joins multiple text strings into one string. Syntax: =CONCATENATE(text1, [text2], ...)
Not Reviewed 41 of 43 
ROUND
Adjusts a number to a specified number of decimal places. Syntax: =ROUND(number, num_digits)
Not Reviewed 42 of 43 
IFERROR
Manages errors by replacing them with a specified value. Syntax: =IFERROR(value, value_if_error)
Not Reviewed 43 of 43 
OR
Evaluates multiple conditions and returns TRUE if any one of them is true. Syntax: =OR(logical1, [logical2], ...)