After explaining how to make report in Microsoft Excel, now I will demonstrate the using of several text function in Microsoft Excel.

Study case 1
Suppose you already input the data like picture below. You want make report and want the report simple to read so you want to merge two field to become one field.

You can do this with text function namely concatenate. The syntax is concatenate(text1,text2,so on)


Look at the sample below, there are three field namely month, year, note. For the sake of report you want combine field year and month. So you have to type =concatenate(E6," ",D6) afterward you can copy to the cell below.

Notice that I add " " (space) between E6 and D6 to make the result like this 2013 January. If I type =concatenate(E6,D6) the result is 2013January (without space).

Concatenate function sample

Study case 2

As a parent you want to measure kids understanding in Grammar. Below is the simple example. There are two area, kids area (Question and kid's answer) and teacher's area (the answer and grade).

After kids fill the answer (a or b or c), then you want to check the answer whether true or false and make percentage. First thing to do is you have to compare kid's answer and the real answer. If kid's answer match with the real answer then the value is true otherwise is false. You can do this with text function namely exact. Just type like this =exact(p5,n5)

Exact function sample

Study case3
Look at the picture above, this only show true and false information. If you want to measure percentage of correct answer, you 
must do some steps. Now, I will tell you about if, sum, and count function because you will use these function for the 
steps. Here are the steps:

1. Make a score. If the answer is true, the score will be 1 otherwise the score will be o.
You can use IF function. The syntax is =IF(logical test, value if true, value if false). So you can type for example below
=IF(Q5=TRUE,1,0) , and then copy to cell below.

It means IF Q5 =true then score is 1, if Q5 = false then score is 0.

2. Sum up the correct answer.
In this step you can use SUM function. The syntax is easy, just type =sum(number area). For example =SUM(S5:S10).

3. Count a number of question.
You can use COUNT function. The syntax is the same as SUM. The difference is COUNT only counting the number whereas SUM is sum 
up the number. For example =COUNT(S5:S10)

4. Calculate the percentage
the formula =  number of correct answer / number of question
for example =U6/V6
Finally, display a value as a percentage.

IF, SUM, COUNT function sample