HOW TO APPLY WBSEDCL Office Executive

HOW TO APPLY

Eligible candidates have to apply through online registration system of WBSEDCL i.e. ww.wbsedcl.in at Career @ WBSEDCL. No other means / mode of application shall be accepted. Online submission of the applications will be allowed on the website between 26.04.2017 to 16.05.2017 (11:59 PM).

While applying on-line, candidates should have the following particulars readily available:

1. Candidates must have a valid E-mail ID. The Company may send information for downloading Admit Card- Provisional for Written Test / Computer Proficiency Test (CPT) / Interview through the registered E-mail ID only. Under no circumstances he / she should share / mention Application No. to / or any other person.

2. Fee should be deposited in any branch of United Bank of India through a Triplicate CHALLAN. After filling up his / her Personal bio-data and professional qualification, etc., the candidate will download / print the CHALLAN from the Fee CHALLAN TAB of online Application Form and will take a printout of the same in A4 size paper and deposit it in any branch of United Bank of India along with application fees. Bank will charge an additional amount as Bank‟s Service Charge. SC / ST /PH/ candidates are exempted from paying application fee.

3. After depositing fees, bank will provide Transaction ID and SOL ID which are required to be written at the proper place in the Application Form by the candidates. One copy of CHALLAN will be retained by the bank and two copies of CHALLAN will be handed over to the candidate by the bank. The candidate will retain Applicant‟s Copy of CHALLAN. It is advisable that, before leaving bank counter, the candidates should check / ensure that the SOL ID and Transaction ID‟s are clearly written on the paid challan.

4. Money Order / Postal Order or any other mode of payment is not acceptable.

5. The paid fees CHALLAN (wherever applicable), valid E-mail ID, Mobile No, photograph and scanned signature are mandatory data without which online registration will be treated as incomplete/invalid.

STEPS FOR APPLYING

Step 1:

Visit website www.wbsedcl.in. Go to Career (Tab).

Step 2:

Click on “Recruitment for the Post of Office Executive under WBSEDCL - Notification No.: MPP/2017/04” to view the full Advertisement Details.

Step 3:

Read the details very carefully before applying. “Online Application” links are placed next to Advertisement Details.

Step 4:

Click on “Apply Online” to fill up the Application Form online. The candidate would be directed to a page where he/she can click on “Apply Online” (for first time registration or new registration) and they would be taken to Step-6 directly. Already registered candidates need to click on “Sign in” and they would be taken to Step 5.

Step 5:

Candidate need to enter Registration Number sent to their valid Email-id & Mobile No. and their Date of Birth in specified format to “Sign in” always. This process would be required always to submit the application form finally, updating the Bank Challan data (for UR/OBC candidates), uploading the photograph / signature /downloading/ printing the Admit Card for written test, Computer Proficiency Test (CPT) and downloading/printing the Call letter for Interview, if  shortlisted.

Step 6:

The candidate must fill up the application form, and attach the photograph and scanned signature as per the guidelines and information sought. The candidate should check the same and proceed accordingly to avoid committing mistakes.

1. The candidates need to select on the “First Screen” tab and click on “Proceed” to move next screen.

2. Candidates should note that Registration Number generated on submission. Next UR/OBC candidates should again login in using the Registration Number and Date of Birth and then click on “Download Bank Challan”. The Bank Challan, thus generated and downloaded will be in triplicate namely: Bank Branch copy, Candidate’s copy and WBSEDCL’s copy. This Challan will have to be printed in A4 size paper and then deposited at United Bank of India. Please note that there is no active Bank Challan for SC/ST/PH candidates. SC/ST/PH candidates can proceed to fill up next screen of online application form.

3. After downloading the Challan “Log Out” from this screen and “Login” again to fill up SOL ID and Transaction Number given by the Bank.

Step 7: UR/OBC candidates after making the payment (using downloaded Bank Challan) in any branch of United Bank of India, shall “Sign in” again using their Registration Number and Date of Birth and update Bank Challan data (SOL Id, Transaction Id and Transaction Date).

Step 8: On the next screen, upload photo (mandatory) and signature (mandatory) in either jpg/jpeg format as per the guidelines given on screen. The appropriate sizes of scanned documents to be uploaded are mentioned below:-

a) Photograph –50KB [Max] & 165 x 125 Pixel
 b) Signature - 20KB [Max] & 80 X 125 Pixels

Step 9: The candidate has to provide her / his consent for the Correctness of the information entered by selecting the “Declaration” text. Once the candidate checks his/her information and click on “Continue” the candidate gets the acknowledgment message mentioning the “Registration Number” and any other important info. Note to the candidates: The candidate should ensure that the information provided is correct and true. For any incorrect information or misrepresentation or suppression of the material fact, the candidature may be cancelled at any stage of the recruitment process and Company reserves the right to take action against such candidate as deemed fit.


Step 10: After final submission candidate must take the print out of Registration Slip. However for candidates paying application fee, the provision for printing of Registration Slip will be available only after 2(Two) days. Only original Registration Slip and WBSEDCL‟s copy of CHALLAN (no photocopy) with photo and signature along with self-attested copies of credential/documents shall be accepted and received by WBSEDCL during Computer Proficiency Test. Important: A candidate who visits the website for the first time is considered as a New User. During this process he / she would be assigned his / her Application Number. When the candidate is required to re-visit the web-site to take the print out of the Registration Slip then he / she has to “Sign in” by providing the Application Number or email-id and Date of Birth.

Step 11:On the basis of online details and declaration submitted, the candidates will be allowed provisionally to appear in Written test. An intimation will be sent to the candidates by Email/SMS for downloading Provisional Admit Card for Written test. On receipt of the Email/SMS candidates will have to once again login to www.wbsedcl.in and go to Career@ WBSEDCL and click on “PRINT THE ADMIT CARD” button to get the Admit Card printed

WBSEDCL Recruitment 2017

WBSEDCL Recruitment 2017

Apply Online for 247 Office Executive Posts:

West Bengal State Electricity Distribution Company Limited (WBSEDCL) has published notification for the recruitment of 247 Office Executive vacancies
Total No. of Posts: 247
Name of the Post: Office Executive
1. General: 116 Posts
2. SC: 53 Posts
3. ST: 15 Posts
4. OBC-A: 24 Posts
5. OBC-B: 17 Posts
6. PWD: 09 Posts
7. Ex Serviceman: 13 Posts
Age Limit:

Candidates age limit should be between 18 – 27 years as on 01-01-2017.

Educational Qualification:

Candidates should possess Graduation in any discipline with 50% marks in aggregate from a recognized University or Graduation in any discipline with minimum 50% marks in HS level and “O‟ level course of National Institute of Electronics and Information Technology (NIELIT) formerly DOEACC Society, Govt. of India or One year course in Computer Application from any Institute recognized by West Bengal State Council of Technical Education/ West Bengal State Council of Technical & Vocational Education and Skill Development or One year Diploma course in Modern Office Practice and Management from any Institute recognized by West Bengal State Council of Technical Education/ West Bengal State Council of Technical & Vocational Education and Skill Development or Course of Computer Operation and Programming Assistant (Basic Skill and / or Advance Skill) from Regional Vocational Training Institute, Director General of Training & Employment, Govt. of India or Secretarial Practices (Basic Skill and / or Advance Skill) from Regional Vocational Training Institute, Director General of Training & Employment, Govt. of India or IT enabled services and Computer fundamentals and Programming or Passed Bachelor in Busines Administration(BBA)/Bachelor in Computer Application(BCA) with either minimum 50% marks in Graduation or 50% marks in HS or Passed Bachelor Degree in Science with Honours in Statistics or Honours in Computer Science With either minimum 50% marks in Graduation or 50% marks in HS or ) Passed Bachelor Degree in any discipline with at least one full paper on Computer Science/ Computer Application/ Information Technology at Graduation level with either minimum 50% marks in Graduation or 50% marks in HS or Passed Bachelor Degree in any discipline with MCA with either minimum 50% marks in Graduation or 50% marks in HS.

Selection Process: Candidates will be selected based on written test, computer proficiency test and interview.

Application Fee: Candidates should pay Rs. 300/- should be deposited in any branch of United Bank of India through a triplicate Challan (One copy of Challan will be retained by the bank and two copies of Challan will be handed over to the candidate by the bank). No fee for SC/ ST/ PWD candidates.

How to Apply: Eligible candidates may apply online through the website www.wbsedcl.in from from 26-04-2017 at 11:00 AM to 16-05-2017 by 11:59 PM.

Instructions to Apply Online:
1. Candidates log on the website www.wbsedcl.in
2. Click on Careers & Select the desired post
3. Read all instructions & fill all the details
4. Check once before submit the form
5. Now take a print out of online application for future use

Important Dates:

Starting Date to Apply Online                                         26-04-2017 at 11:00 AM

Last Date to Apply Online & Payment of Fee                16-05-2017 by 11:59 PM. 

Tentative Date of Written Examination                          18-06-2017

For more details like pay scale, reservation, grade pay, pay band & other information click on the link given below…

Click here for Recruitment Advt

Click here for Apply Online

SBI PO COMPUTER AWARENESS 3

SBI PO MAIN 

COMPUTER AWARENESS QUESTIONS

1. A device, which is not connected to CPU, is called as ---

 a) On-line device b) Off-line device c) Device d) None of the above

2. What is the other name for programmed chip? 

a) RAM b) ROM c) LSIC d) None of the above

3. On-line real time systems become popular in___generation 

a) First Generation b) Second Generation c) Third Generation d) Fourth Generation

4. EDVAC stands for 

a) Electronic Discrete Variable Automatic Computer

b) Electronic Discrete Value Automatic Computer

c) Electronic Device Variable Automatic Computer 

d) Electronic Discrete Variable Advanced Computer

5. EDSAC stands for

a) Electronic Delay Storage Advanced Computer 

b) Electronic Data Storage Automatic Computer 

c) Electronic Delay Strong Automatic Computer

d) Electronic Delay Storage Automatic Computer

6. LSIC stands for 
a) Large Scale Inner Circuits
b) Large Scale Integrated Computer
c) Large Scale Integrated Circuits
d) Large Storage Integrated Circuits

7. The task of performing operations like arithmetic and logical operations is called 
a) Processing b) Storing c) Editing d) Sorting

8. The ALU and Control Unit jointly known as
a) RAM b) ROM c) CPU d) None of the above

9. RAM is an example of 
a) Secondary memory b) Primary memory c) Both (a) and (b) d) None of the above

10. Magnetic disk is an example of
 a) Secondary memory b) Primary memory c) Both (a) and (b) d) None of the above

11. A bit is an acronym for
 a) Digit b) Binary digit c) Number d) None of the above

12. Each memory cell has a unique number, assigned to it is called as the ____of the cell
a) Address b) Register  c) Number d) None of the above

13. RAM is also called as 
a) Read/Write Memory b) Long Memory c) Permanent Memory d) None of the above

14. ___Store data or information temporarily and pass it on as directed by the control unit
 a) Address b) Register c) Number d) None of the above

15. The secondary storage memory is also called as 
a) Auxiliary Memory b) Attractive Memory c) Chip Memory d) None of the above


Answers

  1) b 
  2) b
  3) c 
  4) a 
  5) d 
  6) c 
  7) a 
  8) c 
  9) b 
10) a 
11) b 
12) a 
13) a 
14) b 
15) a

SBI PO COMPUTER AWARENESS 2

SBI PO MAIN 

COMPUTER AWARENESS QUESTIONS

1. ___Key combination that lets you toggle between open windows
 a) ALT+SHIFT+TAB b) ALT+CTRL+TAB c) ALT+CTRL d) ALT+TAB

2. When more than one window is open, to switch to the next win-dow___is the key combination 
a) CTRL+F5 b) CTRL+F6 c) CTRL+F7 d) CTRL+F8

3. To select or unselect one word to the right
a) CTRL+SHIFT b) CTRL+SHIFT+Down Arrow c) CTRL+SHIFT+Right Arrow d) None of the above

4. To maximize or restore a selected window 
a) CTRL+F7 b) CTRL+F10 c) CTRL+F8 d) CTRL+F9

5. To Copy a picture of the selected window to the clipboard 
a) ALT+TAB b) ALT+Print Screen c) Both (a) and (b) d) None of the above

6. ___Is the key to close a selected drop-down list; cancel a comm-and and close a dialog box 
a) TAB b) SHIFT c) ESC d) None of the above

7. ___Is the key we use to run the selected command 
a) SHIFT b) TAB c) ENTER d) CTRL

8. ___Is the functional key to display save as box 
a) F5 b) F6 c) F9 d) F12

9. ___Is the combination of keys to switch between the last four places that you have edited
 a) ALT+CTRL+Z b) ALT+CTRL+Y c) ALT+TAB+Z d) ALT+SHIFT+Z

10. To delete one word to the right
 a) CTRL+SHIFT b) CTRL+TAB c) CTRL+DEL d) CTRL+Z

11. ___Is the combination of keys we use to hide rows 
a) CTRL+9 b) CTRL+8 c) CTRL+7 d) CTRL+6

12. To hide the columns___is the functional key
a) CTRL+3 b) CTRL+2 c) CTRL+1  d) CTRL+0

13. ___Is the shortcut key to delete cells, rows or columns 
a) CTRL+ Minus Sign b) CTRL+ Plus Sign c) CTRL+ Star Sign d) CTRL+ Greater than Sign

14. To insert cells, rows or columns -___the keyboard shortcut key 
a) CTRL+ Minus Sign b) CTRL+SHIFT+ Plus Sign c) CTRL+ Star Sign d) CTRL+ Greater than Sign

15. ___Is the keyboard shortcut key to insert auto sum
 a) ALT b) ALT= c) ALT+ d) ALT-

16. ___Is the shortcut key to move to the next worksheet 
a) CTRL+Pagedown b) CTRL+Pageup c) CTRL+Right arrow d) CTRL+Left arrow

17. ___Is the shortcut key to move to the previous worksheet 
a) CTRL+Pagedown b) CTRL+Pageup c) CTRL+Right arrow d) CTRL+Left arrow

18. ___Key we use to select row 
a) SHIFT+TAB b) SHIFT+ Spacebar c) CTRL+ Spacebar d) SHIFT+ Enter

19. ___Key we use to select column 
a) SHIFT+TAB b) SHIFT+ Spacebar c) CTRL+ Spacebar d) SHIFT+ Enter

20. ___Is the key to exit from excel
 a) ALT+F2 b) ALT+F3 c) ALT+F4 d) ALT+F5

Answer
1) a 

2) b 

3) c 

4) b 

5) b 

 6) c 

 7) c

 8) d

 9) a 

10) c

11) a 

12) d 

13) a 

14) b

15) b

16) a

17) b 

18) b 

19) c

20) c

SBI PO MAIN COMPUTER AWARENESS 1

SBI PO MAIN 

COMPUTER AWARENESS QUESTIONS

1. In a network, the computer that stores the files and process the data is named as 
a) Server b) Terminal c) Modem d) All of the above

 2. Viruses are called that because
 a) They are viruses b) They can copy themselves and spread c) Both (a) and (b) d) None of the above

3. Which of the can't spread virus
a) An e-mail with attachment b) A plain text mail c) Downloading files over the web d) None of the above

4. There is a new anti-virus software update available, when it is downloaded to your computer 
a) Everyday b) Only in the night c) When you next switch on your computer d) All of the above

5. Numbers are stored and transmitted inside a computer in 
a) Binary form b) ASCII code form c) Alphabets form d) Numerical form

 6. CPU capacity can be measured in 
a) BPS b) MIPS c) MHz d) MPI

7. MPIS stands for
 a) Million Instructions Per Second b) Million Instructions Per Season c) Monthly Instructions Per Second d) Million Inputs Per Second

8. LAN speeds are measured in
a) BPS b) KBPS c) MBPS d) MIPS

9. Modem speeds are measured in
a) BPS b) KBPS c) MBPS d) MIPS

10. BPS stands for
a) Bits Per Second b) Bits Per Season c) Bytes Per Second d) Bits Per System
Click here for Answers                              Next SBI PO COMPUTER AWARENESS 2

11 Ways TO GET SUCCESS!!!!!

11 Ways TO GET SUCCESS!!!!!

1. PLAN while others are playing.
2. STUDY while others are sleeping.
3. DECIDE while others are delaying.
4. PREPARE while others are daydreaming.
5. BEGIN while others are procrastinating.
6. WORK while others are wishing.
7. SAVE while others are wasting.
8. LISTEN while others are talking.
9. SMILE while others are frowning.
10. COMMEND while others are criticizing.
11. PERSIST while others are quitting.

30% off on Tuition fee for 1 Year

30% off on Tuition fee for 1 Year

Scholarship for Madhyamik candidate.Students who secure 80 percent marks in Madhyamik will get 30% off on tuition Fee.

Contact Me :

RAHUL MUKHERJEE 

call me : 9038455313

EMAIL me: write2rahul91@gmail.com

Five Marks Questions

Five Marks Questions:

1) Write a note on computer maintenance.

Ans: a. Avoid heat dust and noise
b. Periodic updates and enhancements
c. Installing fire walls and anti virus.
d. In house software maintenance
e. Computer periodic checkup.

2) What are the possible threats to a computer system and how to provide security?

Ans:
Threats
a. Privacy
b. Integrity
c. Environmental damage
d. Human threats
e. Software threats
f. Unauthorized access
g. Computer viruses
Security
a. Physical protection of machine and media.
b. Giving passwords and users ID
c. Using Licensed software
d. Use of Cryptography
e. Use of Spike busters and UPS

3) Explain the typical causes of computer failures.

Ans:
a. Break down of components.
b. Excessive dust or humidity
c. Virus
d. Voltage fluctuation
e. Corrosion

4) Write a note on Computer virus.

Ans: 

Viruses are collection of coded instructions which are self replicating. When a virus attaches itself to another file it infects it. They are normally inactive until infected program is run. They are broadly classified into three categories.

a. Boot infectors

b. System infectors

c. Executable program infectors

Boot infectors: Create bad sectors. They remain in the memory until the system is shutdown.
System infectors: It infects the hard disk or bootable floppies which may contain system files.

Executable program infectors: These are dangerous and devastating. They spread to almost any executable program attaching themselves to programming files.

5. Explain the cache memory in detail.

Ans: Cache memory is a small and fast memory between CPU and main memory. It is extremely fast compared to normal memory. Transferring data between main memory and CPU causes delay because RAM is slower than CPU. Cache memory stores copies of data from most frequently used main memory locations. When processor needs to read from or write to a location in main memory, it first checks whether a copy of data is in the cache. If so processor immediately reads or writes to cache. Computers use multilevels of cache such as Level1(smallest)and Level2 cache.CPU resident cache is known as L1 or primary cache (16 to 32 KB) to 512 KB.Cache is also added to mother board also known as L2 cache (512 KB to 1024 KB). Higher end systems can have as much as 2 MB of L2 cache on mother board.

6. Write a note on components of motherboard.

Ans: 

1) Bus : -

a. Address Bus

b. Data Bus

c. Control Bus

2) Expansion slots: They serve the purpose of adding functionality to the computer.

a. ISA : Industrial standard architecture.

b. PCI : Peripheral component interface

c. AGP : Accelerated Graphic port.

3) CACHE Memory: It is a small fast memory that resides between CPU and main memory.

4) CMOS (Complementary Metal Oxide Semiconductor Battery )

5) I-O Ports ( Input –Output Ports ): Serial , Parallel , USB etc.,

7. Explain the different factors affecting the processing speed of CPU.

Ans: 
CPU Speed/Clock speed: Speed of CPU also known as clock speed. The clock speed is the number of instructions executed by the CPU in one second It is measured in megahertz(million instructions per second). The average speed of a new CPU is about 1000MHz to 4000 MHz.(1 to 4 giga hertz).

• Instruction set: The number of instructions decide the efficiency of a CPU. More the instructions , less efficient is the CPU and less the instructions, More efficient is the CPU.

• Word size/Register size: The size of registers determines the amount of data the computer can work with at a time. Normally it is 32 bits. Smaller the size of register, slower will be the computer. . It is also known as Word size. It varies from 16 bits to 128 bits.

• Data bus capacity: Width of a data bus determines the largest number of bits that can be transported at one time.

• Cache Memory size: Cache memory is a high speed memory. Greater the cache, faster a processor runs. Most modern processors can execute multiple instructions per clock cycle which speeds up a program. Some CPU’s have storage for instructions and data built inside the processor chip . This is

called internal cache or L1 cache memory.

• Memory Size: The amount of PRIMARY STORAGE (RAM) determines the size of program that can be kept in primary storage, which is faster than secondary storage.There by the speed of computer increases. The size of RAM varies from 64 MB to 4 GB.

8. Explain the General Structure of CPU.

Ans: 

Program counter: This register stores address of next instruction to be executed.

Memory address register (MAR):
This register specifies address in memory where information can be found. This register is also used to point to a memory locations where information can be stored.

Memory buffer register:
This register acts as an interface between CPU and memory. When CPU issues a Read Memory command, instruction is fetched and placed in MB register.

Instruction register-This stores a copy of current instruction.

Instruction decoder (ID): 
ID is an electronic hardware, which decodes instructions. The instructions are further broken down into a set of micro operations, so that they can be executed directly.General purpose registers: They are used to store data. There are 6 GP registers. These are used for storage of data as needed by the program.

Arithmetic logic unit:
The basic arithmetic operations such as addition,subtraction,multiplication and division are carried out here. These operations need atleast two operands, one which is stored in accumulator and the other in the MBR. After the manipulation of data in ALU, the result is transferred to accumulator.

Accumulator: 
During processing the intermediate data needed for future processing is stored in accumulator. The contents of ACC are used by ALU for operations and later by MBR holds the final result for further action.

One Mark Computer Question and Answer

One Mark Computer Question and Answer

1. Name the components of CPU
Ans. a) ALU b) PC c) Accumulator d) MAR e) IR f) ID g) MDR

2. What is the use of registers in CPU?
Ans. It is used to store intermediate data and instructions.

3. What is the function of MAR?
Ans. It specifies the address of memory location from which data or instruction is to be accessed or to which the data is to be stored.

4. What is the function of MDR / MBR?
Ans. It contains the data to be written into or read from memory location addressed by MAR.

5. What is program counter?
Ans. It keeps track of the memory address of the instruction that is to be executed next.

6. What is the function of IR?
Ans. It contains the instruction that is being executed.

7. What is the purpose of Instruction Decoder?
Ans. It decodes the instructions.

8. What is a data bus?
Ans. It carries a word to or from memory.

9. What is an address bus?
Ans. It carries memory address. The width of address bus equals the number of bits in the MAR.

10. What is the function of control bus?
Ans. It carries signals between the units of the computer.

11. Name different I/O ports.
Ans. Port is a socket on the back of computer. Different types of ports are serial ports, parallel ports and USB ports.

12. What is meant by plug and play cards?
Ans. It enables the user to add devices to computer.

13. Expand SD RAM.
Ans. Synchronous Dynamic Random Access Memory.

14. Expand DDR RAM.
Ans. Double Data Rate Random Access Memory.

Stylus Pen

Stylus Pen

In computing, a stylus (or stylus pen) is a small pen-shaped instrument that is used to input commands to a computer screen, mobile device or graphics tablet. With touchscreen devices, a user places a stylus on the surface of the screen to draw or make selections by tapping the stylus on the screen.

Transmission Media Importance question And Answers

Transmission Media 

Q-1. On what parameters the quality of transmission depends in case of guided transmission media? 

Ans: It is mainly decided by the frequency of transmission and the characteristics of the transmission media.

 Q-2. Why wires are twisted in case of twisted pair of transmission medium?

 Ans: It minimizes electromagnetic interferences between the pairs of wires, which are bundled together, so that the cross talk is minimum.

 Q-3. Give a popular example where co-axial cables are used for broadband signaling. 

Ans: Use of co-axial cable for broadband signaling is cable TV (CATV) application.

 Q-4. What devices are used as source and detector in case of single mode of fiber? 

Ans: LASER is used as source and photodiode is used as detector in case of single mode of fiber.

Q-5. In what way multi-mode and single-mode fibers differ?

 Ans: The core diameter of single-mode fiber is much smaller than that of multi-mode fiber. For example, For multi-mode fiber: Core diameter lies in the range of 50-200μm Cladding diameter lies in the range of 125-400μm Repeater spacing is 2Km. For single-mode fiber: Core diameter lies in the range of 8-12μm Cladding diameter 125μm Repeater spacing is 20Km

Q-6. Why does single-mode fibres are used for large distance communications rather than multi-mode fibres? 

Ans: In a multi-mode fiber, the quality of signal-encoded light deteriorates more rapidly than single-mode fiber, because of interference of many light rays. As a consequence, single-mode fiber allows longer distances without repeater. For multi-mode fiber, the typical maximum length of the cable without a repeater is 2km, whereas for single-mode fiber it is 20km.

 Q-7. What is crosstalk? How is it minimized in case of twisted-pair of wire? 

Ans: (a) Crosstalk refers to the picking up of electromagnetic signals from other adjacent wires by electromagnetic induction. (b) When a pair of wires is twisted together, the electromagnetic signals generated by the two wires cancel each other as these are of opposite polarity. This helps to reduce the susceptibility of interference to the adjacent wires. 

 Q-8. What are the factors responsible for attenuation in case of terrestrial microwave communication? 

Ans: Attenuation due to distance is 10 log (4πd/λ) 2 . Factors responsible for attenuation are given below: i) Distance – Attenuation is more if distance increases. ii) Wavelength – Attenuation is less if wavelength is longer. (i.e high frequency components are attenuated more than the low frequency component) iii) Rainfall – Attenuation is less if there is no rain. 

 Q-9. What parameters decide the spacing of repeaters in case of terrestrial microwave communication? 

Ans: Parameters are the height of the antenna ‘h’ and adjustment factor ‘k’ based on the relation d = 7.14√kh, where d is the distance in Km between two the two antennas. 

 Q-10. Why two separate frequencies are used for uplink and downlink transmission in case of satellite communication? 

Ans: Two separate frequencies are used so that one cannot interfere with the other and full duplex communication is possible. And other reason is that the Power required to transmit a signal is proportional to the frequency of the signal. And more power requirement more would be the weight of the system. As there are constraints on the load that can be carried with the satellite, mainly down linking frequency is lower than the up linking one. 

 Q-11. Why uplink frequencies are higher than downlink frequencies in case of satellite communication? 

Ans: The satellite gets power from solar cell. So, the transmitter is not being of higher power. On the other hand the ground station can have much higher power. As we want less attenuation and better signal-to-noise ratio, lower frequency is more suitable for downlink and higher frequency is commonly used for uplink. 

To insert a function from the Function Library

To insert a function from the Function Library:

In our example below, we'll use a function to calculate the number of business days it took to receive items after they were ordered. In our example, we'll use the dates in columns B and C to calculate the delivery time in column D.

1. Select the cell that will contain the function. In our example, we'll select cell D3.
   
2. Click the Formulas tab on the Ribbon to access the Function Library.
3. From the Function Library group, select the desired function category. In our example, we'll choose Date & Time.
4. Select the desired function from the drop-down menu. In our example, we'll select the NETWORKDAYS function to count the number of business days between the ordered date and received date.
   
5. The Function Arguments dialog box will appear. From here, you'll be able to enter or select the cells that will make up the arguments in the function. In our example, we'll enter B3 in the Start_date: field and C3 in the End_date: field.
6. When you're satisfied with the arguments, click OK.
   
7. The function will be calculated, and the result will appear in the cell. In our example, the result shows that it took four business days to receive the order.
   

• Like formulas, functions can be copied to adjacent cells. Hover the mouse over the cell that contains the function, then click, hold, and drag the fill handle over the cells you want to fill. The function will be copied, and values for those cells will be calculated relative to their rows or columns.
  

The Function Library

The Function Library

While there are hundreds of functions in Excel, the ones you use most frequently will depend on the type of data your workbooks contains. There is no need to learn every single function, but exploring some of the different types of functions will be helpful as you create new projects. You can search for functions by category, such as Financial, Logical, Text, Date & Time, and more from the Function Library on the Formulas tab.

• To access the Function Library, select the Formulas tab on the Ribbon. The Function Library will appear.

Click the buttons in the interactive below to learn more about the different types of functions in Excel.

TYPES OF SCANNER

Types of Scanner

1. Flatbed Scanners
2. Sheet-Fed Scanners
3. Integrated Scanners
4. Drum Scanners
5. Portable Scanners
6. Handheld Scanner

BARASAT KALIKRISHNA GIRLS HIGH SCHOOL || CLASS XI || HALF-YEARLY 2016 COMPUTER QUESTION

BANAMALIPUR PRIYANATH INSTITUTION || CLASS XI || HALF-YEARLY 2016 QUESTION

PAGE 1

PAGE 3

PAGE 4

JULIEN DAY SCHOOL || CLASS-VII || HALF-YEARLY QUESTION ||