Today i gave my

*. i scored*

**MOS Exam 77-420 : Excel 2013***. overall the exam was easy. i got*

**980/1000***in all objectives except*

**100%***in*

**90%**__'Applying Formulas & Functions'__. I know where i did wrong. But i still can't figure out how to solve that problem because of which i couldn't score a perfect

*1000*. I hope if anyone here could help me.

I know i did

*2 functions*wrong:

**CONCATENATE**&

**RIGHT**. Although it was a scenario based exam but still i remember the 2 questions. Here they are:

[HR][/HR]

Code:

```
[B]1)[/B] [U][B]INSERT THE NAME AND COUNTRY OF THE RUNNER WITH THE FASTEST TIME[/B][/U]
[I]CELL G3[/I]
[LIST]
[*]USE FUNCTION [B]CONCATENATE[/B]
[*]TEXT1: name of gold medalist in 2012 London
[*]TEXT2: " - "
[*]TEXT3: country code of gold medalist in 2012 London
[/LIST]
[B]2)[/B] [U][B]INSERT FAMILY NAME OF RUNNER WITH SLOWEST TIME.[/B][/U]
[I]CELL G4[/I]
[LIST]
[*]USE FUNCTION [B]RIGHT[/B]
[*]TEXT: family name of runner with slowest Olympic time
[*]NUM_CHARS: 5
[/LIST]
```

There were 2 worksheets. I was to use these functions in the second worksheet. The data which were required by the functions were on the first worksheet in a table. The table headers were:

__. The data in the table was sorted in__

**Number, Year, City, Name, Country code, Time***descending*order of

*time*.

**I didn't used any look-up or reference function inside these functions. I directly used the Cell Name**

__Here's What I Did:__*(eg. B4)*for the reference data in the function. When i matched the answer with the Reference images they provided, it was correct, but i think that's not what they asked for...!!

**Also i forgot to mention one thing. My friend also gave this exam and he also got the same document to create in the exam. He also scored**

**Note:**Note:

__980/1000__. He did the same thing wrong which i did. He also got

__90%__in

__'Applying Formulas & Functions'__.

But the thing is he did these 2 questions different from me. By using nested functions. He used

**LOOK-UP**in one question and

**MATCH & INDEX**in the other. His answer also matched the reference images. But still even this was not the correct solution.

I have searched all over and i can't figure out how would this be solved. we both got the same document to create and both got the same score. Both tried different ways to solve these questions. Both got the correct answer as matched with the reference JPEGs. But still both got it Wrong.

Please Help.

PS: On the second worksheet, where i was asked to use these functions. One thing which was available (i don't know whether it was of some use or not), was the time of the fastest and slowest runner which i was asked to find out using max and min function. And for the times of the runner, i got the data from the First Sheet. As i mentioned earlier, every data was available in the table on the first worksheet.

PS: On the second worksheet, where i was asked to use these functions. One thing which was available (i don't know whether it was of some use or not), was the time of the fastest and slowest runner which i was asked to find out using max and min function. And for the times of the runner, i got the data from the First Sheet. As i mentioned earlier, every data was available in the table on the first worksheet.