USING MICROSOFT EXCEL
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: -They are grouped into three categories: Data Bars are horizontal bars added to each cell, much like a bar graph. Color Scales change the color of each cell based on its value. Each color scale uses a two-or three-color gradient.