Linggo, Enero 13, 2013

Sabado, Enero 12, 2013

IFF

                                                                       IF FUCTIONS
The If function allows the Spreadsheet to make decisions, based on conditions. 

The If function has the following format: =IF(<Condition> , <True value> , <False value>) 

The Condition is the problem to be evaluated. eg. Amount of wages someone earned to determine their tax bracket. 

The True value is the action to be taken if the given condition is fulfilled. This may be to add a value to something or multiply a value by something etc. 

The False value is the action to be taken if the condition is not fulfilled. 

In any given case, either the False or True actions can be done, as a condition is either True or False, but never both. 

Biyernes, Enero 11, 2013

cell ref.

In Excel, a cell reference identifies the location a cell or group of cells in the spreadsheet. Sometimes referred to as a cell address, a cell reference consists of the column letter and rownumber that intersect at the cell's location. Note that when listing a cell reference, the column letter is always listed first.

SPREAD it

                                         SPREADSHEET FUNCTIONS
The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of a cell.

I EXCEL at every thing



                                             Microsoft Excel

  
Software developed and manufactured by Microsoft Corporation that allows users to organize, format, and calculate data with formulas using a spreadsheet system broken up by rows and columns. Microsoft Excel usually comes bundled with Microsoft Office and is compatible with other applications offered in the suite of products. The first software program similar to Excel was released in 1982 and was called Multiplan.


ms word parts and functions


microsoft

Microsoft Word is a word processor designed by Microsoft. It was first released in 1983 under the name Multi-Tool Word for Xenixsystems.[1][2][3] Subsequent versions were later written for several other platforms including IBM PCs running DOS (1983), the Apple Macintosh (1984), the AT&T Unix PC (1985), Atari ST (1986), SCO UNIXOS/2, and Microsoft Windows (1989). It is a component of theMicrosoft Office software system; it is also sold as a standalone product and included in Microsoft Works Suite. The current versions are Microsoft Office Word 2010 for Windows and Microsoft Office Word 2011 for Mac.