Perfect Computer Notes

What is SUM Function? The SUM Function is used to add all numbers in a given range of cells and returns the total as a result. The syntax of the SUM Function is as follows: Syntax 1 of SUM Function in Excel wWorksheet:   SUM(FirstCell : LastCell) where FirstCell is the cell reference of the first cell in cell range and LastCell is the cell reference of the last cell in the given cell range to be added.   For Example: If cells A1,A2,A3,A4 contains 10,20,30,40 respectively then the function =SUM(A1:A4) will give 100. Simple Use of SUM function in MS Example with examples Syntax 2 of SUM Function in Excel Worksheet:   SUM(number1, number2, number3, ..., number N)      For Example: = SUM(10,20,30) will give the result 60.   and  = SUM(2,5) will give 7. Syntax 3 of SUM Function in Excel Worksheets:   SUM(cell1, cell2, cell3, . . ., cell N) Where cell1, cell2, cell3,...cell N are the cell references of the cells containing numbers to be added.  For Example: =SUM(A1

Microsoft Excel is a spreadsheet software developed by Microsoft Corporation of USA. Microsoft Excel is used to input and format data and to apply suitable mathematical and other formulas on the data. Excel can perform large number of calculations on data easily in a table like format. The main file of Microsoft Excel is called an Excel Workbook. By default, each workbook has three Excel Worksheets . A Worksheet is divided into Rows, Columns and cells. Microsoft Excel provides many easy to use features as follows: Important Features Provided by MS Excel different features of Microsoft Excel application software 1.    Auto Fill MS Excel provides easy series generating feature called Auto Fill. With the help of Auto Fill you can fill the adjacent cell range with a series like days of a weak or a number series like 1,2,3,4,...10 or 5,10,15,...50 or 1990, 1991, 1992... or dates etc. 2.    Header and Footers Header and footer feature is used to display same text on t

Q. Define Language processor or Translator. Explain different types of Language processors. Language Processors / Translator         Computer directly understands machine language only. That is why Machine language is called the native language of computer. Machine language is in binary form that is its instructions consists of strings of zeros and ones.         A program written in high-level or assembly language cannot be run on a computer directly. Firstly, it is converted into machine language. So there is a need to translate the source program into object code for a computer to execute it.  Definition of Language Processor  Language processor may be defined as a software that converts source programs into object program. Language processor is also called Language Translator.  Therefore, a language translator software will take a source program(that cannot be understood by computer) as input and then will convert it into object code(that can be understood by computer

What is a Program and Programming Language Program A set of instructions that tell a computer what to do is called program. A computer works according to the given instructions in the program. Computer programs are written in programming languages. A person who develops a program is called programmer. Programming Languages A set of words, symbols and codes used to write programs is called programming language. Different programming languages are available for writing different types of programs . With the help of computer language, a programmer tells a computer what to do.   Explain different Types of Programming Languages. There are two main types of computer programming languages. ·         low-level languages ·         high-level languages. Low Level Languages These languages are near to computer hardware and far from human languages. Computer can understand these languages easily. Following are two low-level languages: •      Machine Language •   

Topic: Explain Advantages of CD and DVD and Differences Between CD and DVD  What is CD? CD stands for Compact Disc. Compact Disk or CD is a popular storage device. It is a portable storage device. It can store about 700 MB (Mega Bytes) of data. Advantages of Compact Disk It can store large amounts of different types of data. It can store information in the form of sound, videos, programs or software, pictures and other graphics, documents and many more formats of data. We purchase games and software stored on CDs. CD can store audio/ video songs and videos, too. It is very inexpensive way of storing large amounts of data permanently. It is used for backing up of important data, that can be recovered in future if any data is lost from our PC's hard disk. Compact Disks are easy to use and easy to carry. Compact Disks are durable and reliable. CDs can store data for many years without losing a single byte. Different Types of Compact CDs are: CD-ROM

Today, while searching on Internet for the Best Free Antivirus of  the year 2013, I decided to do some research work in a different way. There are many reputed Software Repository Websites found on Internet. These websites provide information about new Software with reviews, technical details, Editor Ratings, User ratings, number of downloads and download links. I did research on these sites EDITOR RATINGS for the popular Free Antivirus Software found on Internet. I selected the following popular Software Download Websites: 1. Softpedia.Com Softpedia is an Internet site that indexes information and provides software. The site also covers technology, science, health, and entertainment topics from external and in-house sources and provides software and game reviews. As of 2012 it was the 25th most-visited site by Romanians. It is a "popular destination for software download". 2. Snapfiles.Com  Snapfiles provides facility to Download freeware and shareware programs, f