DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
= KH: S16
|
|
|
= F5:F16
|
|
|
=B5:B16
|
|
|
= S5:F16
|
Detailed explanation-1: -5. In the formula =SUMIFS(C5:C16, F5:F16, "<=60", B5:B16, “>200000"), what does <=60 means? If the value in C5:C16 is greater than or equal to 60, the value in C5:C16 will be included in the total. If the value in F5:F16 is greater than or equal to 60, the value in C5:C16 will be included in the total.
Detailed explanation-2: -The range of cells that you want evaluated by criteria. Cells in each range must be numbers or names, arrays, or references that contain numbers. Blank and text values are ignored. The selected range may contain dates in standard Excel format (examples below).
Detailed explanation-3: -The SUMIFS Function in Excel allows us to enter up to 127 range/criteria pairs for this formula.
Detailed explanation-4: -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 <