DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Conditonal Formula
|
|
|
Argument Formula
|
|
|
Criterion Formula
|
|
|
None of the above
|
Detailed explanation-1: -Click on the cell you want to display the ‘Number of Absences’ in and enter the formula =COUNTIF(range, criteria). You can use the same formula to get the number of presents. For example, in the image, we have used the formula =COUNTIF(B2:Q10, A). And that’s it!
Detailed explanation-2: -If A and B are two events in a sample space S, then the conditional probability of A given B is defined as P(A|B)=P(A∩B)P(B), when P(B)>0.
Detailed explanation-3: -Conditional formatting for empty and non-empty cells Formula for blanks: =$B2="”-format selected cells / rows if a corresponding cell in Column B is blank. Formula for non-blanks: =$B2<>"”-format selected cells / rows if a corresponding cell in Column B is not blank.
Detailed explanation-4: -One of the methods to achieve Conditional formatting based on a custom formula is using the IF statement. The IF function works on the IF/THEN/ELSE condition syntax.