# FUNDAMENTALS OF COMPUTER

## USING MICROSOFT EXCEL

### HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A formula in which the result is determined by the presence or absence of a particular condition.
 A Conditonal Formula B Argument Formula C Criterion Formula D None of the above
Explanation:

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.

There is 1 question to complete.