USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Total
|
|
|
Average
|
|
|
Conditional sum
|
|
|
Conditional count
|
Detailed explanation-1: -You use the SUMIF function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5. You can use the following formula: =SUMIF(B2:B25, ">5")
Detailed explanation-2: -The SUMIF function, also known as Excel conditional sum, is used to add up cell values based on a certain condition.
Detailed explanation-3: -The SUMIF function is a premade function in Excel, which calculates the sum of values in a range based on a true or false condition. The condition is referred to as criteria, which can check things like: If a number is greater than another number > If a number is smaller than another number <
Detailed explanation-4: -The SUMIF formula returns the sum of cells based on one criterion (a result that matches one condition). Whereas, the SUMIFS function returns the sum of cells that meet multiple criteria. The criteria mentioned in both functions can be dates, numbers, and text.