Saturday, August 30, 2014

DMRC JE electronics question paper


 DMRC JE electronics question paper

I have shared only 20 questions if you need complete DMRC  JE electronics question paper feel free to  contact us.

 1.  The method of working in which current flows for 85% of duration of DOT or DASH and no current flows during  the rest 15% is:
(1)  Morse code                 (2)  Normal Code
(3)  7.5 unit Code               (4)  Cable Code

2.  The modulation  index can be greater than unity in:
(1) AM                                  (2)  FM
(3)  Both AM and FM      (4)  Neither AM nor FM
3.  A Yagi antenna produces a pattern of the following type:
(1)  Figure of Eight            (2)  Broadside
(3) End-fire                           (4)  Omnidirectional
4.  The measurement range o fan ammeter can be increased by using a:
(1)  High resistance in shunt   (2)  Low resistance in shunt
(3)  High resistance in series   (4)  Low resistance in series
5.  A transformer at no load behaves like:
(1)  A resistor  (2)  A capacitor
(3)  An inductor  (4)  An open circuit
6.  The power in the FM signal is:
(1) Always constant
(2)  Varies linearly with amplitude of the modulating signal
(3)  Varies as square of the amplitude of the modulating signal
(4)  None of these
7.  Harmonic distortion in an amplifier is caused due to:
(1)  Feedback  from o/p to input
(2)  Presence of white noise
(3)  Active device non-linearity
(4) Shot noise
8.  Redundancy in communication system
(1)  Reduces efficiency of communication
(2)  Helps to detect error
(3)  Helps to correct error
(4)  All of these
9.  A full-wave bridge rectifier uses ...............:
(1)  One diode                    (2)  Two diodes
(3)  Three diodes               (4)  Four diodes
10.  When a unijunction transistor (UJT) is turned on, it conducts Current between ...............:
(1)  Emitter and base terminal
(2)  Two base terminals
(3)  Collector and base terminals
(4)  Collector and emitter terminals
11.  The current gain alpha(α) of a transistor ...............:
(1)  Is always more than 50
(2)  Is always more than 1
(3)  Is always less than 1
(4)  None of these
12.  Which impurity atom will give P-type semiconductor when added to silicon intrinsic semiconductor?
(1) Phosphorus
(2) Antimony
(3) Boron
(4) Arsenic
13.  Which of the following metals has the highest conductivity:
(1) Aluminum                    (2) Silver
(3) Platinum                        (4) Iron
14.  Which of the following is basically a voltage controlled capacitance?
(1)  Zener diode                (2)  Photo diode
(3) Varactor diode             (4)  LED
15.  In a JFET the width of channel is controlled by:
(1)  Gate current               (2)  Drain current
(3)  Source current           (4)  Gate voltage
16.  When a BJT is operated under saturated condition:
(1)  EB junction  is  forward biased and CB junction is reversed  biased
(2)  EB junction  is  reversed biased and CB junction is forward biased
(3)  Both junction are forward biased
(4)  Both junction are reversed biased
17.  The emitter follower is widely used in electronic instruments because:
(1)  Its input impedance is high and output impedance is low
(2)  Its input impedance is low and output impedance is high
(3)  Its voltage gain is very high
(4)  Both input and output impedances are very high
18.  A TRIAC  is equivalent to:
(1)  One thyristor and one transistor
(2)  One thyristor and one diode
(3)  Two thyristor in parallel
(4)  Two thyristor in series
19.  The binary number 10101 is equal to the decimal number:
(1) 17                                     (2)  45
(3) 21                                    (4)  11
20.  The decimal number 37 isequal to the binary number:
(1) 100101                            (2)  101000
(3) 010110                             (4)  101101 

Kindly let me know if you need other exam JE Question paper.

If you found this helpful share this post with your facebook, twitter or google plus account.

Sunday, August 24, 2014

VLOOKUP Formula in excel with example

How to use VLOOKUP function in excel

VLOOKUP formula allows the merging of two sheets using a common field to match data.
Excel has many important functions which save your precious time when you work on the data you have. VLOOKUP is one of these important formula. With VLOOKUP formula you can merge two sheets with a common column, which means you don’t need to type the data again for the same column value. 
 

Points to remember for VLOOKUP formula

It is a good practice to have both the sheets on the same excel file.
Consider the file in which the master data is present as master sheet and to where the data of other columns are to be copied using VLOOKUP formula is considered to be new datasheet.
The same column in both the files must be in the 1st column otherwise. The VLOOKUP function will not work.

VLOOKUP Formula parameters

There are total four parameters for the VLOOKUP function to configure:
1. lookup_value:  it is generally the address of the 2nd cell of the common column in both the sheet.
2. table array : it is the range of selected data from which you need to do VLOOKUP in the new datasheet.
3. col_index_num: it is the index number of the column which data you want on your new datasheet.
4. range_lookup: in this tab you can either enter true or false. If you enter true it also copy the approximate value. If you enter false it will only show data when there is exact match in the same column otherwise it will show you  #N/A.
We have included two pictures of our sheets master datasheet and new datasheet in figure 1 and 2 respectively. 

VLOOKUP FORMULA EXAMPLE


vlookup function
                                         
                                           

vlookup function


We want the value of label city to be appearing in the second column of the new datasheet. Here we are doing this using VLOOKUP function.
Open the VLOOKUP Dialog box using fx button on the toolbar.
Select the VLOOKUP function on the list.
Now the VLOOKUP dialog box will appear.


How to use vlookup function

                                

There you will have four parameters as discussed above.
Now you need to fill the value in the tabs.
Lookup value: in our case A2
TABLE ARRAY:  In table array we need to select all the data from the master sheet. The address of the data will be shown in the dialog box.
Col_index_num: in this you need to enter the column no of which data you want on your new sheet. In our case it is 2.
Range_ lookup: we have used 0 for false. As we need exact data on the new sheet. 

Now we have learnt vlookup formula with a example. 
Thanks for visiting. 

Sunday, August 17, 2014

there is no disk please insert a disk error

please insert a disk error

How to tackle there is no disk Please insert a disk error here problem popup window.
We sometimes in our system face a problem of popup window which does not close at all. When you close that window it will again reopen in a few seconds, displaying the same problem. It’s a very irritating when working with this problem. Generally people solve this problem by dragging the window to the taskbar pane. But still the problem it not solved, it reduces the system speed too. And the other applications you will open may take time to start.

please insert a disk error
           


 So we must completely get rid of this type of problem. It can be solved by editing the registry. But to use regedit is not a simple task like uninstalling a software . It requires a good command over the knowledge of how to edit registry.
First of all we must know about what is regedit is ? How it works?
Caution
Incorrectly editing the registry can cause to system damage so consult a IT professional before doing anything. You should make backup of the registry before you edit them. 

What is regedit?
All the system configurations including all the software and application settings are stored in a database called the registry. It means it is the registry in which all the settings are saved in our system. 

How to open regedit ?
 You can open registry for editing or viewing the default key stored by a setting by opening registry using run.
1. Click on start button.
2. type regedit in the search box.
3.  A window of registry editor will open. 

What are keys and Values?
The keys are just like folders in a tree.
Values are the number or string in which the setting of a particular application is saved.
So for a change we need to find the right key and we need to edit the respective Value.
Go to the following tree shown




HKEY LOCAL MACHINE
SYSTEM
CURRENT CONTROL SET
CONTROL
WINDOWS
Error mode
Now right click on error mode and change its value from 0 to 2 and change the base to decimal.





how to solve no disk error



 The image of the registry editor window has been show for your convenience. 

This will remove please insert a disk error. If this post solve your problem do comment. 

Thanks for visiting my blog.