Learning Computer Skill Blog

STATISTICAL FUNCTION   1. MAX FUNCTION () Summary  The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values TRUE and FALSE, and text values. Purpose  Get the largest value Return value  The largest value in the array. Syntax  =MAX (number1, [number2], ...) Arguments  number1  - Number, reference to numeric value, or range that contains numeric values. number2  - [optional] Number, reference to numeric value, or range that contains numeric values. Usage notes  The MAX function can be used to return the largest value from a set of data. For example, the slowest time in a race, the hightest temperature, or the top sales number. Arguments can be provided as constants, or as cell references or ranges, for example: = MAX ( 5 , 10 ) = MAX ( A1 , A2 , A3 ) - MAX ( A1:A10 ) ...

                                        FORMULA BAR Functions are predefined formulas that perform calculations on specific values,  called arguments. Each function takes specific types of arguments, such as text, numbers, logical values, references etc.   You can enter the arguments, enclosing them in parentheses. i.e ( ) after the function name. Excel includes many functions that can be divided into the following categories :-                                            MATHEMATICAL FUNCTION   1.SUM () 2.ROUND() 3.ROUNDDOWN() 4.ROUNDUP() 5.ABS N() 6.SQRT() 7.TRUNC() 8.SUM IF() 9.ODD() 10.EVEN() 11.POWER()                         ...

                         OPENING OF SPREADSHEET                                                            MS-EXCEL 2010 needs Window 7 as operating system to run on an IBM PC .However, Excel 2010 can also be run on Windows XP operating system, if service pack 3 is installed on Windows XP. To start Excel 2010 in Window 7, do this : Click the START button on the taskbar, highlight ALL PROGRAMS , click Microsoft Office and then click Microsoft Excel 2010. Starting Excel 2010 in Windows 7 To start Excel 2010 in Window XP, do this : Click the  START  button on the taskbar, highlight  ALL PROGRAMS , click  Microsoft Office  and then click  Microsoft Excel 2010.          ...

                                           SPREADSHEET INTRODUCTION  Spreadsheet applications (sometimes referred to simply as spreadsheets) are computer programs that let you create and manipulate spreadsheets electronically . In a spreadsheet application, each value sits in a cell . You can define what type of data is in each cell and how different cell depend on one another. The relationships between cells are called formulas , and the names of the cells are called labels . A table of values are arranged in rows and columns. Each value can have a predefined relationship to the other values. If you change one value, therefore you may need to change other value as well,  or they will change automatically. Once you have defined the cells and the formulas for linking them together, you can enter your data.You can then modify selected value...