USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Math & Trig
|
|
|
Text
|
|
|
Logical
|
|
|
Lookup & Reference
|
Detailed explanation-1: -The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria.
Detailed explanation-2: -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.
Detailed explanation-3: -The SUMIF function in Excel is used to sum values based on a single condition or criteria. However, if we want to sum values based on multiple criteria where at least one of the conditions are met, we use the SUMIF with OR logic.
Detailed explanation-4: -The SUMIF function is used to conditionally sum values based on a single criteria.
Detailed explanation-5: -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") Play.