Perfect Computer Notes

Following are the main uses of Communication Technologies: 1. Video Conferencing Video Conferenccing combines the computer communication capabilities with video technologies to conduct an online meeting between two or more distant participants. The participants of a Video Conferencing are normally at different geographical locations within a building like a university campus or within a city at different branch offices of an organizaion in a city. If the communication technology is supported with high speed internet, the participants may in different cities or even in different countries of the world. Uses of Video Conferencing Online Meetings Online Job Interviews Technical Support Distance Learning Requirements for Video Conferencing It requires: A P-IV computer Microphone Speakers Video Cameras Communication Devices Communication Software High Speed Broad Band Internet  2.   Voice Mail Voice Mail works as an answering machine. The caller may l

What is Memory Management? One of the main functions of Operating systems is Memory Management. Memory Management may be defined as the process of managing the optimal use of main memory that is RAM (Random Access Memory). RAM is much faster than hard disk. So RAM is used to store data and instructions temporarily while they are being executed by CPU ( Central Processing Unit or PROCESSOR ). CPU can get data and instructions from RAM much faster that from hard disk. As we know CPU is a very very fast device. It may execute billions of instructions per second. CPU will have to wait for data and instruction from hard disk because getting data from hard disk is very slow. That is why RAM is used. So data and instructions needed for execution are brought into main memory that is RAM first. Now RAM provides data and instructions to CPU rapidly. What is Memory Management and virtual memory management Operating System allocates the required memory are in main memory to program

Why To Use Left Function in Microsoft Excel? The Left function is used to get first N characters from the given text string or the text contained in a cell. Syntax of LEFT Function in Excel LEFT(Text, Number_of_characters) For example, the function LEFT("Normal",3) will return Nor. Syntax of LEFT function with Cell Reference LEFT(CellReference, Number_of_characters) For example, let the cell A2 contains the text Humanity , the function LEFT(A2,5) will return Human . Similarly if Cll A12 contains "England" then Left(A12,5) will give "Engla" that is first five characters of contents of cell A12 from left side. How To Implement LEFT Function in Excel Uses of Excel Functions Left Right in Excel Worksheet    First of all place the cursor in an empty cell next to cell A2, to enter the function. Type = Type the function name LEFT Type the left parenthesis ( Type A2 from keyboard. Type , (that is Comma) Type 5 so that the first 5