USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=AVERAGE
|
|
|
=AVERAGEIF
|
|
|
=SUM
|
|
|
=SUMIF
|
Detailed explanation-1: -=SUMIF(range, criteria, [sum range]) The formula uses the following arguments: Range (required argument) – This is the range of cells that we want to apply the criteria against. Criteria (required argument) – This is the criteria which are used to determine which cells need to be added.
Detailed explanation-2: -The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value.
Detailed explanation-3: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")