We are currently struggling to cover the operational costs of Xtremepapers, as a result we might have to shut this website down. Please donate if we have helped you and help make a difference in other students' lives!
Click here to Donate Now (View Announcement)
What was difficult in it? Whixh question?i found it pretty difficult. it reminded me of october/nvember 2015 which was awful to begin with
i hope the thresholds are low but depends on how others performed now
in one step where we had to extract only the numbers from the given codeWhat was difficult in it? Whixh question?
It wasnt nmbrs... We had to extract letters in put them in dfrnt order.. For tht u have to concatenate the MID function...in one step where we had to extract only the numbers from the given code
and another where we needed to calculate the crew required
I know that step was easyIt wasnt nmbrs... We had to extract letters in put them in dfrnt order.. For tht u have to concatenate the MID function...
N for crew u have to put up nested if function with time
To extract the alphabets....how did you attempt these two steps though?
No.. Im talking abt 4 only...I know that step was easy
but im talking abt task 4
you are talking abt task 3 and task 8
there were 3 tasks whose screen shots we had to take : task 3 which is the one you mentioned and was 9 marks , task 4 which is the one where we had to extract the numbers only and put them in a coloumn named Code was 16 marks , task 5 was simply just naming ranges and that was like 8 marksTo extract the alphabets....
The example was given ABCD00000 n we have to extract the alphabets n chng thm to CDBA
So use the formula
MID(A2,3,1) & MID(A2,4,1) & MID(A2,2,1) & MID(A2,1,1).. Here to concatenate u could also use CONCATENATE n thn insert MID formula in it
wht was xctly task 3....? i dnt remember it...cn u plz tell ..there were 3 tasks whose screen shots we had to take : task 3 which is the one you mentioned and was 9 marks , task 4 which is the one where we had to extract the numbers only and put them in a coloumn named Code was 16 marks , task 5 was simply just naming ranges and that was like 8 marks
Dark Destination what was task 3?
like i said beforeDark Destination what was task 3?
well great.........I used the following formula for step 4:
= VALUE(IF(RIGHT(A3,1)="X", MID(A3,5,LEN(A3)-5), RIGHT(A3, LEN(A3)-4)))
And for step 8, to calculate crew:
= 5 + ROUNDUP(F3/500,0) + IF(TIME(HOUR(E3),MINUTE(E3),SECOND(E3)<TIME(20,0,0), 2, 0)
For almost 10 years, the site XtremePapers has been trying very hard to serve its users.
However, we are now struggling to cover its operational costs due to unforeseen circumstances. If we helped you in any way, kindly contribute and be the part of this effort. No act of kindness, no matter how small, is ever wasted.
Click here to Donate Now