1 / 8

In-Built Functions-1

In-Built Functions-1. Open Office Calc, Excel and other spreadsheets contain 100s of in-built functions which you can use in formulas or in your spreadsheet calculations. Functions are used in formulas, either alone or in combination with other functions to calculate values for the cell, e.g:

aneko
Download Presentation

In-Built Functions-1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. In-Built Functions-1 Open Office Calc, Excel and other spreadsheets contain 100s of in-built functions which you can use in formulas or in your spreadsheet calculations. Functions are used in formulas, either alone or in combination with other functions to calculate values for the cell, e.g: Simple functions, e.g. =SUM(B2:B16) Complex functions, e.g. charts

  2. In-Built Functions-2 Functions are made up of a function name, e.g. SUM, followed by the function’s argument enclosed in parentheses, e.g: =Round(B2*C2+SUM(D2:G2),0) =IF(B2>C2,B2*3,C2*5) The arguments in most functions are the values in other cells but they can include other types of data, such as numbers, text and even other functions.

  3. OO’s In-Built Functions-3 Database Functions Date and Time Functions FINANCIAL FUNCTIONS* Information Functions LOGICAL FUNCTIONS* Lookup Functions MATHEMATICAL FUNCTIONS* STATISTICAL FUNCTIONS* Text Functions Trigonometric Functions

  4. Inserting A Function-1 Select the cell where you want the function to be inserted, then either: Click on the INSERT FUNCTION BUTTON on the Standard Toolbar, or Select the INSERT/FUNCTION COMMAND on the Main Menu to bring up the Paste Function Dialog box. Finally select the function category and the function you require…

  5. Inserting A Function-2

  6. Mathematical and Statistical Functions HO-12 ROUND, ROUNDUP/DOWN AVERAGE MAX, MIN COUNT

  7. Financial Functions HO-13, 14, 15 – Financial Functions LOAN ANALYSIS AMORTISATION Uses PMT function PMT = PPMT + IPMT Payment = Principal + Interest

  8. Statistical Functions HO-16: Trend and Growth Functions Sales Forecasting Trend = Linear Growth Growth = Exponential Growth

More Related