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