Perfect Computer Notes

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...

What is MAX Function? Learn Practical Use of MAX Function and MIN Function in Excel Worksheets The MAX function is used to get the maximum number from different given numbers in Excel Worksheet. Syntax of MAX Function in Excel MAX(number1,number2,number3,...numberN) For example the function MAX(5,100,35) will return 100, since 100 is largest number of all 5, 100 and 35. Syntax of MAX Function using Cell References MAX(CellRef1:CellRef2) Where CellRef1 is the cell reference of the first cell and CellRef2 is the cell reference of the last cell in the given cell range in Excel Worksheet. What is MIN Function? The MIN function is used to get the minimum number from different given numbers in Excel Worksheet. Syntax of MIN Function in Excel MIN(number1,number2,number3,...numberN) For example the function MIN(5,100,35) will return 5, since 5 is the smallest number of all 5, 100 and 35. Syntax of MIN Function using Cell References MIN(CellRef1:CellRef2) Where Cel...

What is the Use of Average Function in Excel?  The Average Function of Excel is used to get the average of the numbers in Excel Worksheet. Syntax of Average Function in Excel    Average(number1, number2, number3, ... number N)   For Example Average(10,15,20) will return 15. Because, Average is calculated by adding all the numbers and then dividing the total by count of the numbers. In above example: Average = (10+15+20) / 3 Which evaluates to 45 / 3 that is 15. Syntax of Average Function in Excel Using Cell references  Average(cellRef1:CellRef2)  where cellRef1 is the cell reference of the first cell and cellRef2 is the cell reference of the last cell in Average function to calculate the required average, in Excel worksheet. Consider the above figure for example: the cells A2, B2, C2, D2 and E2 contains the numbers 5, 15, 30, 40, 50 respectively. How To Implement Average Function in Excel  First of all place the cursor in an emp...

Microsoft Excel is very useful in Business and Commerce. Following is a list of the uses of Microsoft Excel in Business and Commerce: 1. Creating Computerized Worksheets Microsoft Excel is a computer software with electronic worksheets. You can easily input, edit, format your business data in computerized worksheets provided by MS Excel. You can manipulate business data easily and efficiently. 2. Recording Business Data Microsoft Excel can be used in business and commerce for recording the daily transaction records of your business. It provides the facility to store and maintain large amounts of records easily and quickly. 3. Use of Excel in Accounts Department a) Accounting System Microsoft Excel can be used to manage the accounting system of your business organization.It records daily transactions of the organization. b) Prepare Accounting Documents Microsoft Excel can be used to prepare balance sheet, trial balance, ledger and other accounting sheets. 4. Maintai...

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 conta...

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 u...

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 con...