Microsoft Excel Flashcards
Function that allows the numerical data in any number columns or rows by selecting them or typing them.
SUM() Function
=SUM(sum_range)
SUM() Function
Function used to summate the values of cells in a range that meet the criteria that have been specified.
SUMIF() Function
=SUMIF(range,criteria,sum_range)
SUMIF() Function
Cells that contain values and from which values will be checked against the criteria.
Range
Value which will define which cells will be summed up.
Criteria
Range of cells to be summed up.
Sum_range
Function that allows the user to get the average of all the numbers in the chosen cells.
AVERAGE() Function
=AVERAGE(range to be averaged) Example: =AVERAGE(B5:B9)
AVERAGE() Function
Function used to count the number chosen cells that have a number value in them.
COUNT() Function
=COUNT(range to be counted) Example: =COUNT(B5:B9)
COUNT() Function
Function allows users to achieve a particular value if the condition has been satisfied or TRUE, or if the condition has not been satisfied by FALSE.
IF() Function
=IF(condition,resultifTRUE,resultifFALSE) Example: =IF(B5>74.99,”PASSED”,”FAILED”)
IF() Function
Function that will test all the conditions set and will return a “TRUE” value if ALL the conditions are met and “FALSE” even if only one condition is not.
AND() Function
=AND(condition to be met) Example: =AND(B5=”PASSED”,C5=”PASSED”,D5=”PASSED”)
AND() Function