DHL COURIER COMPANY INTERVIEW QUESTIONS

Key Takeaways

delivered here only one delivered this one and remaining are all blank sorry red in color okay whenever the number is with delivered then it should be highlight Green in that mean for for delivered okay so first of all what I'll do I'll just copy this because I want the size of the table for that reason I'm copying I want size of the here paste it I delete because I want size from where it start and where it ends I doesn't know for that reason I have selected that and pasted and deleted the data see first of all what I'll do columns the formula in D16 so what I'll do dollar D16 colon D16 here I'm locking only the column but not the row keep it in mind D is the column and 16 is the row so I'm calling only I'm locking only the D part but not the number part keep it in mind control enters so display in which column are there 1 2 3 4 okay 1 2 3 4 now what I do here simple F2 I ask is anything less than or equal to left of here I'm locking the column but not the RO because whenever I copy paste so column should not column should not move only rows should move only rows should move for that reason I'm locking only the column but not the row row is a number column is a letter I mean it's alphabet so I'm locking only the column column part but not the Row part by default it pick up the I did not mention how many characters because by default it will pick up the first character here it will not work I'll tell you why control enter it will show you like that but it will not work so why it will not work I highlight and the left line see it is in text part text number for that reason it is not understand so it is showing all through because in text part text number so what you'll do just convert this T number into a number by using any mathematical operator that is plus Z control enter see whever it falses see here false is it here false is it okay so what I'll do I have to highlight whole thing control C alt HLN just copy the formula did you got it F2 control C Escape alt HLN for conditional format okay so it should be green color right so double click use a formula to determine which cell to format control V control V okay I'll write a formula here it is not pasting the formula I don't know why it's not pasting the formula over [Music] here okay I'll write over there because the formula is not pasting over there all to HLN I'll write again the formula over here I have to be be careful right what right while writing a formula here columns columns d 16 dollar D16 colon D16 is less than or equal to left of this plus one here what I'll do I remove the robot F4 okay I'm locking only the column but not the row OB guys okay right done it should be green color because it is delivered for that it is be green color border not border fill with green any green any green F will be the old and white okay and okay three okay the same formula again I will write it but different format here what I said is less than or equal now what I'll say is greater than that's it control ENT same thing alt HLN now it should be not deliver means it should be three deliver [Music] somewhere some wrong here the deliver path is wrong somewhere I'll come back with that is somewhere wrong here I'll check it once again alt h r [Music] okay I you the plus one here actually plus Z I use the plus one over here now it is like see the same formula again I will use in different format that is alt HL n new rule the same formula but different approach columns dollar D 16 colon D16 D16 is greater than left of okay left of this F4 F4 +0 format that should be red color okay because it is not delivered is not delivered okay want right white with bold okay okay see let us check once again here what is F2 delivered so what I'll do I'll make it two two delivered remaining are all not delivered here again I'll check it only one delivered okay only one delivered remaining not Del or four and Del see I'll type it zero let's see Zero Del let's see what will happen all right okay thank you guys thanks for your support have a nice day please like share and subscribe my channel