XtremePapers

Which question? Lemme guess question no. 3/4 ?

the formula questions

question 4

can u help?

To generate the random number use the function Randbetween,
The formula goes like =Randbetween(1(because if you check the student id, the number starts from 1),92(because the-the last student number is 92). Now that you've gotten the generated rand. no., You can find the student id, by concatenating the formula,concatenating takes place when u have to combine two dates together, and if ..

required in a specific format, example this question u have to make "THS"& combines the random number with the 0000, after solving this the rest is easy, you have to use V lookup and find the surname and first name, then again by using concatenate method, u have to arrange the full name to First Name: Surname, this question also calls for an if function in the full name question.

I can send you my edited file, since you know the concept of editing backround and formating pctures to the specific alignment. I'm sure when you loook at the the edited document you'd figure it out.

thank u soo muchh