Learning Computer Skill Blog

MS-POWERPOINT MS-POWERPOINT - GETTING START STEP-1 GO TO →START BUTTON→CLICK IT STEP-2 : CLICK ON →ALL PROGRAMS→GO TO MICROSOFT OFFICE STEP 3 .: CLICK ON MICROSOFT OFFICE →CHOOSE MS-POWERPOINT FROM THE LIST                      NOW YOU START TO DRAW YOUR PRESENTATION POWERPOINT WINDOW EXPLORING  WINDOWS   RIBBON  BACKSTAGE VIEW  

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

                                   EXCEL PART -3 In this blog I share you the following topics: Printing a  Spreadsheet  Addressing of Cell  Manipulation of Cell   Printing a  Spreadsheet  The simplest way to print any opened worksheet is to choose Print option from the Backstage view , click Print Preview. In Excel you can print partial or entire worksheet & workbooks one at a time or several at once . Follow Steps: Open the Worksheet that you want to print. Click the File Tab and than choose Print Command or Alternatively Press CTRL+SHIFT+F12 Key .  The Backstage View is Close by Pressing ESC Key .        Option                                      Function  Ignore Print Area  ...