Front
Excel Formula: SUM
Back
=SUM(range)
Adds all numbers in a range of cells. Example: =SUM(A1:A10)
Public Deck
Excel Mastery - 40 Essential Skills
Master Microsoft Excel with 40 flashcards covering formulas, pivot tables, charts, and time-saving keyboard shortcuts.
AnyFlashcards40 cards
Preview
Front
Excel Formula: AVERAGE
Back
=AVERAGE(range)
Returns the arithmetic mean of the arguments. Example: =AVERAGE(B1:B20)
Front
Excel Formula: COUNT
Back
=COUNT(range)
Counts the number of cells that contain numbers only. Example: =COUNT(C1:C50)
Front
Excel Formula: IF
Back
=IF(logical_test, value_if_true, value_if_false)
Checks if a condition is met and returns one value if True and another if False.
Front
Excel Formula: VLOOKUP
Back
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Searches for a value in the first column of a table and returns a value in the same row from a specified column.
Front
Excel Formula: HLOOKUP
Back
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Searches for a value in the top row of a table and returns a value in the same column from a specified row.
Front
Excel Formula: INDEX
Back
=INDEX(array, row_num, [column_num])
Returns a value or reference of the cell at the intersection of a particular row and column in a range.
Front
Excel Formula: MATCH
Back
=MATCH(lookup_value, lookup_array, [match_type])
Searches for a specified item in a range of cells and returns the relative position of that item.
Front
Excel Formula: INDEX/MATCH (Combined)
Back
=INDEX(return_range, MATCH(lookup_value, lookup_range, 0))
A flexible alternative to VLOOKUP that can look left and is not affected by inserted columns.
Front
Excel Formula: SUMIF
Back
=SUMIF(range, criteria, [sum_range])
Adds the cells specified by a given criteria. Example: =SUMIF(A1:A10, ">100", B1:B10)
+ 30 more cards
Related Flashcard Decks
Ready to study?
Sign up for free to copy this deck and start learning with spaced repetition.
Get started for free