Home

OfficeSuite s60

1. Find My Match entire cell Yes Match case Insensitive e Find choose Options gt Search gt Find and type in the string or numbers you want to locate in the space provided Scroll to the Match entire cell and Yes if would like to receive only whole cells matching the find criteria Scroll down to Match Case and choose Sensitive if you want an exact case sensitive match after the find function If the search returns any matches the first cell that has the find criteria will be selected To continue the search and move next cell that matches the search condition select Find Next from the Edit menu e Find next to continue a search choose Search gt Find Next e Replace to replace text in your document choose Search gt Replace and enter the text or numbers which you wish to replace and the new text Choose Replace MobiSystems OfficeSuite e 35 Managing Worksheets In MobiSystems Spreadsheet you can add new worksheets rename delete and protect existing ones and switch between the different sheets in a currently opened workbook These options are available through the submenus in Options gt Worksheet e Insert To insert a new worksheet in the currently opened workbook just choose Options gt Worksheet gt Insert and enter the name for the new sheet in the provided text box e Change if you wish to switch to another worksheet within the opened workbook choose Options gt Worksheet gt Change e Rename to Rename a wor
2. MONTH serial_number Serial number is the date of the month you are trying to find Dates should be entered by using the DATE function or as results of other formulas or functions For example use DATE 2008 5 23 for the 23rd day of May 2008 Problems can occur if dates are entered as text NOW The NOW function changes only when the worksheet is calculated It 1s not updated continuously SECOND serial_number Serial number is the time that contains the seconds you want to find Times may be entered as text strings within quotation marks for example 6 45 PM as decimal numbers for example 0 78125 which represents 6 45 PM or as results of other formulas or functions for example TIMEVALUE 6 45 PM Time values are a portion of a date value and represented by a decimal number for example 12 00 PM is represented as 0 5 because it is half of a day TIME hour minute second Hour is a number from 0 zero to 32767 representing the hour Any value greater than 23 will be divided by 24 and the remainder will be treated as the hour value For example TIME 27 0 0 TIME 3 0 0 125 or 3 00 AM Minute is a number from 0 to 32767 representing the minute Any value greater than 59 will be converted to hours and minutes For example TIME 0 750 0 TIME 12 30 0 520833 or 12 30 PM Second is a number from 0 to 32767 representing the second Any value greater than 59 will be converted to hours minutes and second
3. correct formula is 5 10 or 5 10 Missing argument For example 5 2 Correcy formulas are 5 2 SUM 5 2 etc Example 5 4 missing left parenthesis Check the formula syntax and correct the error Missing quotations Example ala bala Check the formula syntax and correct the error Example 5 3 The array closing bracket is missing Check the formula syntax Illegal formula argument Example SUM ABCDEF The provided argument is neither reference to existing cell nor predefined name Arrays used as function arguments should have the following syntax fa1 a2 a3 b1 b2 b3 The items in each array row are separated by comma and the different rows are separated by semi column This error message indicates incorrect array definition e 41 Formula error Missing array element Formula error Illegal array element Formula error Missing function closing bracket Formula error Too deep function nesting Formula error Unknown function Formula error Missing single quote Formula error Circular reference Unknown evaluation error Formula error Not enough arguments Unknown formula error Formula error Too much arguments MobiSystems OfficeSuite Incorrect array definition This error indicates that array item has been omitted Example 1 2 4 The third array item is omitted Incorrect array definition Thi
4. Me er 33 TAS A A e tale Cece N 34 TE AEE EAA EEA ETATE E A EA O NE En ert nee ORO A ET 35 WIGHG IN 2 YO ST BO a A aida 36 EEES COMAS tas 36 SS A A A 36 CELL OR IA TINO bt are ts hehe bade Mecho A A e diyen 36 Cell FOnMnal pes Gnd SCHINGS dad 37 AN tes a cll Ba her Grates SAGs ah es she ia di o Sei 38 A A a DN 38 r OAIE OENE SEVA VETETTE AE IEAA r_ ama_er_ _ ee eorpDnr n c__r_r_ _ _ __ EENET A TAE TAE TET 38 FET COLO DM EAE EEE E A E E E E E E E E E E eed 38 ZOOD Dya A A 39 ETA MA VD N N a N 39 PCI Y CCS ares ole seat n E otek tna asses eee ees aaa eae RE 39 ROOL A IA 39 H E a E seat hte as ade gu abies a n n e Nels wach Comte teach ah SoMa Ma ia hay 39 WORKING WITH FUNCTIONS cy 45544 44454554x 4559y y3i xand n GURE z Ak Ea ku du ka kEWE K ba e lea k RANE ka A e TENES EEEa 40 ENSER PING As FUNCTION cia 40 PORMULA ERROR Serera a ds 41 FONCTION DESCRIPTION ta als 43 Ml LOT DIT SOLO NET xay ea Cd cdi 43 Dl DO O ye le K SA A WO AD NNN N A DA ae A DANA AET E AE E A G WW YAD AN W 48 e Vite NNN ree T 0 e0 500K DADA n 50 O o A px 54 DIRECTA A ei 55 IOMAN ON AAA AA AA 27 MobiSystems OfficeSuite e 4 BITOR ANDES Aa 59 PS DE 611 101 CM A O SE EAT ete A AN 60 IN FU CH OM VAMOS tii 60 Lookup and RETN CE A A E A T 6l LENO T r READ N E E A E a 65 MobiSystems OfficeSuite e 5 License Agreement Please read this entire agreement This End User License Agreeme
5. Value refers to the N A value not available error value ISNONTEXT Value refers to any item that is not text Note that this function returns TRUE if value refers to a blank cell ISNUMBER Value refers to a number ISREF Value refers to a reference ISTEXT Value refers to text N function values If value is or refers to N returns A number That number A date in one of the built in date formats The serial number of available in Microsoft Excel that date MobiSystems OfficeSuite e 60 TRUE FALSE An error value such as DIV 0 Anything else Lookup and Reference CHOO SE COLU MN COLU MNS AT Uses index num to return a value from the list of value arguments Use CHOOSE to select one of up to 29 values based on the index number For example if value1 through value7 are the days of the week CHOOSE returns one of the days when a number between and 7 is used as index num Returns the column number of the given reference Returns the number of columns in an array or reference Searches for a value in the top row of an array of values and then returns a value in the same column from a row you specify in the table or array MobiSystems OfficeSuite l 0 The error value 0 CHOOSE index_num valuel value2 Index_num specifies which value argument is selected Index_num must be a number between 1 and 29 or a formula or reference to a cell containing a number between an
6. be saved in both the main memory and on memory cards o RTF the rich text format is supported by almost any desktop text editor The OfficeSuite is the only OfficeSuite for Symbian to support RTF files Spreadsheet formats O XLS this is the native file format of Microsoft Excel XLS documents can be kept on both memory card and the main memory of your PDA This format ensures the compatibility between MobiSystems Spreadsheet and the commonly used Microsoft Office software o E XML The XML files are supported by Microsoft Excel 2003 and XP XML files can be stored in both the main memory and on memory card O CSV the commonly used CSV comma separated format ensures the compatibility of OfficeSuite with third party desktop programs The CSV format is not capable of saving and showing the cells formatting Workbooks in this format can contain only one spreadsheet Changing the Format of Existing Files OfficeSuite allows you to change the format and or the destination of an existing file for easier data processing and exchange To change the file format of an existing file MobiSystems OfficeSuite e 13 1 Open the file 2 Choose Options gt File gt Save As 3 Choose the new destination of the file and the new file format and press Ok You can choose among Excel Workbook XLS XML Spreadsheet XML and Comma Delimited CSV file formats for worksheets and among MobiSystems Docs Format MWD Text Documents TXT Mi
7. files from unauthorized viewing through assigning passwords To assign a password to a file open it and choose Options gt File gt Protect Enter a password in the space provided Choose Ok to confirm Upon closing the password protected file you need to save it so that the encryption is saved Next time you open the file you will be requested to enter your Password To remove the Password open the file and choose Options gt File gt Unprotect and Save the file again to keep the changes MobiSystems OfficeSuite e 15 Password e Close closes the currently opened file Full Screen To use the whole screen of your phone as a text entry work area use the Full Screen option that OfficeSuite provides To switch to Full Screen choose Options gt Full Screen To exit Full Screen choose Options gt Full Screen Alternatively you can use the shortcut key from the keyboard to switch to and to exit Full Screen Search The OfficeSuite allows you to locate words or part of words in a document To search for a word choose Options gt Search gt Find and enter the word that you want to be found in the text box provided If you want small and capital letters to be considered during the search enable the Case sensitive option You can use Options gt Search gt Find next to locate the next entry for the search Alternatively you can use the shortcuts 3 and 6 keys from the keyboard for Find and Find Next respectively MobiSystems Offic
8. from more than one worksheet Each Workbook appears as a separate file in the file explorer where you can manage it create delete and rename workbooks gt OfficeSuite TP ejexcell H4 customer lis E formula xls 3K fah inventory x 1K El my data xls 3K E my data xml 2K Options Back nn a Ml In the File Explorer you can create new workbook through Options gt New gt Sheet You can switch between the different worksheets in the currently opened workbook through Options gt Worksheet gt Change and select a new sheet from the list of available sheets in the workbook In contrast to Docs Spreadsheets does not have View Mode and when a document is opened you can directly begin to edit it Edit Mode Menu The Edit Mode Menu has the following menu items Edit Cell To enter information in a cell or to edit already existing values in a cell select the cell and choose Options gt Edit Cell The contents of the cell will be displayed in the edit filed in the lower left corner of the screen where you can change the information Alternatively you can MobiSystems OfficeSuite e 32 use the 5 way navigation center button to access the data in a cell and edit it After you have entered the new data press the 5 way navigation center button or Edit gt Apply Edited Text to enter the new text in the cell File With the File submenus you can manage the currently opened workbook in the following ways e Save saves the workb
9. ki 7 SYSTEM REO BNI Dl DN VS a A A A a ed 7 INSTALLATION AND UN INSTALLATION 0cccccscecccceccececcececcscscscscescecescscsscscscescscscecesescesescess 7 ostalim O OU COSI onenean ose aA AA a AR aA an n n A A eee eee A 7 A AU AAA a E N E DN a S 8 REGISTRATION E E I E A EE OEE O AE A AS EE OS OSE E AEA E 8 OFFICESUITE FILE EXPLORER 60 00 is 10 BROWSING DIRECTORIES AND FILES e cass 10 USING THE 5 WAY NAVIGATION BUTTON alos 11 PILE EXPLORER MIE NULO NS EN Nota 11 N eae ceases a a ons ett eset anc amet ease ae ne Il ON Il A Os EE SA Bs Em TA ESR PUES Rem PRET BRIERE AT REE PN Se MET BEE RD EEE Il RELET YR N E O yee A N 11 WAD ira Reg castes aie td seiner Shas aloes secon nese Samed sha aa ees see a E 1 av MM RS 1 TRANSFERRING FILE Ses lr tit lis 11 FILEE PORMATS AND FORMAT CONVERTING vari irens n ii is 13 TEXT TFORMATS eea a v O E E E AE 13 SPT CGOSHCCEIOMINGIS 2 a SAS A ds 13 CHANGING THE FORMAT OF EXISTING PILES lt ya 512an en da 13 WORKING WITH TEXT DOCUMENT SS 2 cccscccsccccsccccsccccccccsscccsccccsccccssccsccccsccesesceees 15 MILWIVM ODE A anan 2 o a dala EA EEE 15 VMIEW MODE ME N Sise yA e Saleke N a Yan ne snl ails Wa e a was e eleke Wn e Nard WW na 15 TEAC IVI OGLC AM N DD e N N A E DD N 15 Ci ya ek e A E TT RET Ee A 15 Ful SrO a L v ra AA E ER O AA AN V NA AA AS AWA An A RAA RAA ANN 16 LOE ow eee Ra HN K b O RE e K Se NN TY R Ke NS P O ONE EL NE De ane
10. may not give the correct value Uppercase and lowercase text are equivalent MATCH lookup_value lookup_array match_type Lookup value is the value you use to find the value you e 63 matches a specified value in a specified order Use MATCH instead of one of the LOOKUP functions when you need the position of an item in a range instead of the item itself Returns the row number of a reference Returns the number of rows in a reference or array Returns a vertical range of cells as a horizontal range or vice versa TRANSPOSE must be entered as an array formula in a range that has the same number of rows and columns respectively as an array MobiSystems OfficeSuite want in a table Lookup value is the value you want to match in lookup array For example when you look up someone s number in a telephone book you are using the person s name as the lookup value but the telephone number is the value you want Lookup value can be a value number text or logical value or a cell reference to a number text or logical value Lookup array is a contiguous range of cells containing possible lookup values Lookup array must be an array or an array reference Match_type is the number 1 0 or 1 Match_type specifies how Microsoft Excel matches lookup_ value with values in lookup array If match_type is 1 MATCH finds the largest value that is less than or equal to lookup value Lookup array must be placed
11. number or reference value or a name referring to any of these that you want to test ISNUMBER value Value 1s the value you want tested Value can be a blank empty cell error logical text number or reference value or a name referring to any of these that you want to test ISREF value Value 1s the value you want tested Value can be a blank empty cell error logical text number or reference value or a name referring to any of these that you want to test e 58 ISTEX T see IS Functions see N function values Checks the type of value and returns TRUE or FALSE depending on the outcome Returns TRUE if the value is text Returns TRUE if number is even or FALSE if number is odd If this function is not available and returns the FNAME Error Returns TRUE if number 1s odd or FALSE if number is even If this function is not available and returns the FNAME Error Returns a value converted to a number Returns the error value N A N A is the error value that means no value is available Use NA to mark empty cells By entering N A in cells where you are missing information you can avoid the problem of unintentionally including empty cells in your calculations Error Types If error_val is NULL DIV 0 V ALUE REF NAME NUM returns l 2 3 4 5 6 MobiSystems OfficeSuite ISTEXT value Value 1s the value you want tested Va
12. on your phone USB Cable Connection 1 Connect your phone to your desktop PC and make sure that the Nokia PC Suite software 1s installed and enabled on your PC The Nokia PC Suite 1s free of charge and comes with your mobile phone You can also obtain the software from http www nokia com 2 On the desktop PC start the File Manager that is part of the Nokia PC suite 3 Use the file manager to copy the extracted SIS files to one of the following directories on your mobile phone a Nokia Phone Browser lt phone gt Phone memory Nokia nstalls b Nokia Phone Browser lt phone gt lt memory card gt Nokia nstalls Where lt phone gt is your mobile phone as it appears in the file explorer and respectively lt memory card gt is the memory card that is currently inserted in the phone 4 On your mobile use the applications button to go the Menu form MobiSystems OfficeSuite e 7 5 Select Settings gt Tools gt Manager to start the applications manager 6 Select Diets from the list of applications and select Install from the Options menu 7 Follow the on screen instructions to complete the installation Un installation To delete the OfficeSuite program from your mobile device 1 Go to the Application Manager and select the OfficeSuite 2 With the left soft key select Options gt Remove 3 A message notifying you of the deletion will appear Press Yes to confirm Registration MobiSystems OfficeSuite is a downloadable
13. or text that cannot be translated into numbers are ignored e Ifan argument is an array or reference only numbers in that array or reference are counted Empty cells logical values text or error values in the array or reference are ignored e The NPV investment begins one period before the date of the valuel cash flow and ends with the last cash flow in the list The NPV calculation is based on future cash flows If your first cash flow occurs at the beginning of the first period the first value must be added to the NPV result not included in the values arguments For more information see the examples below e NPV is similar to the PV function present value The primary difference between PV and NPV is that PV allows cash flows to begin either at the end or at the beginning of the period Unlike the variable NPV cash flow values PV cash flows must be constant throughout the investment For information about annuities and financial functions see PV e NPV is also related to the IRR function internal rate of return IRR 1s the rate for which NPV equals zero NPV IRR 0 Logical Returns TRUE if all its arguments are TRUE returns FALSE if one or more argument is FALSE Returns the logical value FALSE Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE Use IF to conduct conditional tests on values and formulas Reverses the value of its argument Us
14. period Nper is the total number of payment periods in an annuity Pmt is the payment made each period it cannot change over the life of the annuity Typically pmt contains principal and interest but no other fees or taxes If pmt is omitted you e 50 must include the pv argument Pv is the present value or the lump sum amount that a series of future payments is worth right now If pv is omitted it is assumed to be 0 zero and you must include the pmt argument Type is the number 0 or 1 and indicates when payments are due If type is omitted 1t is assumed to be 0 IPMT Returns the interest IPMT rate per nper pv fv type payment for a given period for an investment Rate is the interest rate per period based on periodic constant payments and a Per is the period for which you want to find the interest constant interest rate For and must be in the range 1 to nper a more complete description of the arguments in IPMT and for more information about annuity functions Nper is the total number of payment periods in an annuity Pv is the present value or the lump sum amount that a see PV series of future payments is worth right now Fv is the future value or a cash balance you want to attain after the last payment is made If fv is omitted it is assumed to be 0 the future value of a loan for example is 0 Type is the number 0 or 1 and indicates when payments are due If type is omitted 1t is assumed
15. precision of the truncation The default value for num digits is 0 zero Database The database functions have the following arguments o Database is the range of cells that makes up the list or database A database is a list of related data in which rows of related information are records and columns of data are fields The first row of the list contains labels for each column o Field indicates which column is used in the function Field can be given as text with the column label enclosed between double quotation marks such as Age or Yield or as a number that represents the position of the column within the list 1 for the first column 2 for the second column and so on o Criteria is the range of cells that contains the conditions you specify You can use any range for the criteria argument as long as it includes at least one column label and at least one cell below the column label for specifying a condition for the column Averages the values in DAVERAGE database field criteria a column of a list or database that match conditions you specify Counts the cells that DCOUNT database field criteria contain numbers in a column of a list or database that match MobiSystems OfficeSuite e 48 conditions you specify The field argument is optional If field is omitted DCOUNT counts all records in the database that match the criteria DCOUN Counts the nonblank cells in a column of a list TA or database that
16. to be 0 Returns the nominal NOMINAL effect_rate npery annual interest rate given the effective rate and the Effect rate is the effective interest rate number of compounding periods per year Npery is the number of compounding periods per year NPER Returns the number of NPER rate pmt pv fv type periods for an investment based on periodic For a more complete description of the arguments in constant payments and a NPER and for more information about annuity functions see constant interest rate PV Rate is the interest rate per period Pmt is the payment made each period it cannot change over the life of the annuity Typically pmt contains principal and interest but no other fees or taxes Pv is the present value or the lump sum amount that a series of future payments is worth right now Fv is the future value or a cash balance you want to attain after the last payment is made If fv is omitted it is assumed to be 0 the future value of a loan for example is 0 Type is the number 0 or 1 and indicates when payments are due NPV Calculates the net NPV rate value 1 value present value of an MobiSystems OfficeSuite e 51 1 See the Investment by using a remarks below discount rate and a series the table of future payments negative values and income positive values PPMT Returns the payment on the principal for a given period for an investment based on periodic constant payments and a co
17. to pi Returns the inverse hyperbolic cosine of a number Number must be greater than or equal to 1 The inverse hyperbolic cosine 1s the value whose hyperbolic cosine is number so ACOSH COSH number equals number Returns the arcsine or inverse sine of a number The arcsine is the angle whose sine is number The returned angle is given in radians in the range p1 2 to pi 2 Returns the inverse hyperbolic sine of a number The inverse hyperbolic sine 1s the value whose hyperbolic sine is number so ASINH SINH number equals number MobiSystems OfficeSuite ABS number Number is the real number of which you want the absolute value ACOS number Number is the cosine of the angle you want and must be from 1 to 1 ACOSH number Number is any real number equal to or greater than 1 ASIN number Number is the sine of the angle you want and must be from 1 to 1 ASINH number Number is any real number ABS 2 Absolute value of 2 2 ACOS 0 5 Arccosine of 0 5 in radians 2 p1 3 2 094395 ACOSH 1 Inverse hyperbolic cosine of 1 0 ASIN 0 5 Arcsine of 0 5 in radians p1 6 0 5236 ASINH 2 5 Inverse hyperbolic sine of 2 5 1 64723 e 43 ATAN ATAN2 ATANH R COSH COUN TIF DEGRE ES Returns the arctangent or inverse tangent of a number The arctangent is the angle whose tangent 1s number The returned angle is given in radians in t
18. up and down arrows in the 5 navigation keys to select the type of the hyperlink to URL Bookmark or file 4 To add a hyperlink to URL type the URL in the text box provided 5 To add a hyperlink to an existing bookmark in the current document select the particular bookmark form the list of available bookmarks 6 To add a hyperlink to a file choose to file browse the files on your phone and select the particular file Docs a Docs wine lower doc wine lower dar to book none to file Story doc URL www mobi syste to book OIT Hew to fle none MobiSystems OfficeSuite e 24 To remove a hyperlink simply select the hyperlink and choose Options gt Hyperlink gt Remove Insert The OfficeSuite allows you to format your documents by inserting Bullets Numbering Pictures Tables Breaks and Bookmarks Bullets The OfficeSuite has three different styles of bullets Bullet Square and Empty bullet To change the style of existing bullets and numbering or to insert ones with a new style use the advanced bullets and numbering form To open the bullets and numbering preferences choose Insert gt Bullets Numbering A DOCS wine lower dor Bulleted Humbered Hype Break Inset Bookmark Select Cancel To insert bullets with selected style 1 Choose Insert gt Bullets Numbering 2 Inthe next screen use the 5 way navigation key to scroll up and down the bullets sett
19. values in Error val is the error value whose identifying the different Microsoft Excel or number you want to find Although error val can _ __A returns the N A be the actual error value it will usually be a of Information error if no error reference to a cell containing a formula that you kana exists You can use want to test ERROR TYPE in an IF function to test for an error value and return a text string such as a message instead of the error value ISBLA Checks the type of ISBLANK value NK value and returns TRUE or FALSE Value 1s the value you want tested Value can be see IS ranae depending on the a blank empty cell error logical text number or outcome Returns reference value or a name referring to any of these TRUE 1f the value is that you want to test blank ISERR Checks the type of ISERR value see IS value and returns MobiSystems OfficeSuite e 57 Functions ISERR OR see IS Functions ISLOGI CAL see IS Functions ISNA see IS Functions ISNON TEXT see IS Functions ISNUM BER see IS Functions ISREF see IS Functions TRUE or FALSE depending on the outcome Returns TRUE if the value is any error value except N A Checks the type of value and returns TRUE or FALSE depending on the outcome Returns TRUE if the value is any an error value Checks the type of value and returns TRUE or FALSE depending on the outcome Retu
20. with new text New text is the text that will replace characters in old text REPT text number_times Text 1s the text you want to repeat Number times is a positive number specifying the number of times to repeat text RIGHT text num_chars Text 1s the text string containing the characters you want to extract Num chars specifies the number of characters you want RIGHT to extract Num bytes specifies the number of characters you want RIGHTB to extract based on bytes SUBSTITUTE text old_text new_text instance_num Text is the text or the reference to a cell containing text for which you want to substitute characters Old text is the text you want to replace e 67 any text that occurs in a specific location in a text string Returns the text referred to by value If value is or refers to text T returns value If value does not refer to text T returns empty text Y ou do not generally need to use the T function in a formula because Microsoft Excel automatically converts values as necessary This function is provided for compatibility with other spreadsheet programs Removes all spaces from text except for single spaces between words Use TRIM on text that you have received from another application that may have irregular spacing Converts text to uppercase MobiSystems OfficeSuite New text is the text you want to replace old text with Instance num specifies which occurrence
21. DA See 16 NN DD a ies hd cc eae aa alah E ciel cakes eat bed eh tte el yV 17 LOON eee eee Re CE MER REE eR a CT ET a ce MELT eT VEE a ene ee n ener EE A 17 Word eo r r ee eee ee Te ee ee 17 OPIO cc 18 IE LAN o EIEN T ABE TAAA ET A AA E E n a KODA ey A e e Ke am Sino aaa kern aes 18 STOUN MN DD DD e a 19 EDITNE DOCUMENTS een 20 EDIE MODE NIE ii ice 20 Zi AAA A 20 MobiSystems OfficeSuite e 3 D e OO REO OOO mn E ety ee 21 E E O EOI ae eee ee eer ener ee eee ee 21 GOT Osea sd A A 22 EO EEE ee O E E fee heh A E atest eee ka 22 ZO ER A Se ee Ke ek e EE ON e RE NEE ET NCI ten e e in N BIE K N en 24 AAA e e NE e DE e a a e D MM 24 NY DOT ener eee eee A D A AN N bA WO W SOND AR N 24 TDS DD AAE E r r r DD nr r E E E E a ee 29 DUL CTS r E a E eR 23 A E E EEE EA 26 Dl LU AART ERT E s k EA Bad Wenn AE E EA R on Sacer ean EE E A E TEA 26 AAA A N nA WA n 27 Te CCA TS MN e ME KE N io ocio 2Z BONUS A tddi 28 81 EANET A TETA O 28 PUESTO ES RA E E E a RA N N ac AA 29 SPENE ODMONS aya e aE N A SO AE N O 29 Dic honari es Mand COIMENE AAA AAA A OTN 30 DL Oates E EEA rr r r rr r aes 30 KESSU AO e A AEEA E E ARE 31 WORKING WITH WORKSHEETS AND WORKBOORS sssssssssssssssssscccccccssssees 32 EDI MODE MENU aiii 32 TE Sl AA E e AE A AD rr EREz 32 Y ATA ENS E I EN n O e E NO 33 GL a Ka Ke RNC E K OE OT NERC IT a Ke Se DY e E K ek ET eee mr ERT EO RT E
22. New you can create new Folders Documents or Sheets on the phone File allows you to Open Delete Find and Rename a file or worksheet With this option you can also Copy and Move a file to a desired location on the phone Send You can send files and worksheet from the File Explorer to other Smartphones through wireless connections such as Bluetooth and Infrared Register allows you to enter the Registration screen and register the program About allows you to access general information on the product such as the product version and web address and the included Help Manuel Exit exits the program Transferring Files The OfficeSuite allows you to transfer files to the PC and to other devices through the following methods MobiSystems OfficeSuite e 11 e Infrared Beaming Select Connect Infrared on the phone to enable the phone s IR Line up the phone with the PC infrared port and Windows will detect the phone Right click on the files which you wish to send and choose Send to IR recipient The file will be transferred to the Inbox of the phone To send a file from the phone to the PC enable the IR on the phone and select the file in the File Explorer Choose Options gt Send via Infrared and the file will be transferred In the same way you can send receive files to from other Infrared enabled devices e Bluetooth Connection On the phone turn on the Bluetooth from Connect gt Bluetooth gt Bluetoot
23. Preview screen By scrolling down the list with the 5 way navigation key you will be able to access the settings for the Font Any changes made in the form will reflect in the text entered thereafter If text has been selected before the opening of the Font Preferences form it will be reformatted according to the changes F F Be ocs F wine lower doc T wine lower doc Preview Font Preview Font Times New Ro Font Times New Ro Size 12 size 12 style TST EN Style Regular O Italic Underli off O Bold Script off Bold Italic o To choose a Font scroll to Font and press the 5 way navigation center key You will access the list of all available fonts on the phone o To change the font size scroll to Size and enter the desired font size o To change the Font to Italic Bold or Bold Italic choose Style and select the desired option with the 5 way navigation center key o To enable underline scroll to Underline and choose On o To change to Superscript or Subscript choose Script and scroll to the desired script o To have the formatting changed to Strikethrough formatting choose Strike gt Strikethrough or Double Strike This way when you start to enter new text it will be formatted to Strikethrough or Double Strike You can also select already written text and choose Strikethrough or Double Strike to reformat it To remove Strikethrough or Double Strike formatting choose Strike gt off o To change the Font color choose Color and brow
24. User s Guide MobiSystems OfficeSuite For Symbian S60 SmartPhones lMobileSystems Copyright Mobile Systems Inc 2003 2006 All rights reserved This manual and the programs referred to herein are copyrighted works of Mobile Systems Inc The information in this document is a subject to change without notice Mobile Systems Inc accepts no liability for loss or consequential loss from misuse or any defect or failure of the programs howsoever arising 2003 2006 Mobile Systems Inc MobiSystems OfficeSuite and the MobiSystems OfficeSuite logo are trademarks or registered trademarks of Mobile Systems Inc in the U S and or other countries All rights reserved Acrobat and PDF are trademarks of Adobe All other brands and product names may be trademarks or registered trademarks of their respective holders The TrueType support is based on the FreeType Project 1996 2002 All rights reserved MobiSystems OfficeSuite e 2 CONTENTS CONTENTS saraccsacawsccatcsracccsvansecauwacscsacvonuecescsuaceassacssdasvenaccasvousteavesuacess vance L WU 206 EVE VEK VU WENE V HEVRE E KAR bA 3 Bes D N 353905154 DON DD aka a Eonia ca last 6 ICE NSE AND DISTRIBUTION ld le A 6 KRESTRICTI N Sr dll 6 NO WeARRANTIES it ii Sosa 6 SEMA TON OE LAB id ged 6 GETTING TAR TED naa 543 45344454515y34452y y 404510 w k RAE aa ken RAYAN Q we W a k SWE V W sa en ku RAY a yi de an EYE YARE
25. ally disclaims all warranties expressed or implied including but not limited to implied warranties of fitness for any particular purpose and of merchantability Limitation of Liability In no event will Mobile Systems Inc be liable to you for any damages including but not limited to any loss of data lost profits lost savings commercial damage or other incidental or consequential damages arising out of the use or inability to use this program directly or indirectly or for any claim by any other party MobiSystems OfficeSuite e 6 Getting Started System Requirements Any Symbian S60 2 or 3 edition running device Installation and Un installation Installing OfficeSuite 1 Download OfficeSuite zip Windows or sit Mac OS file on your desktop PC 2 Extract the zip or sit archive file to desired folder on your desktop PC The archive file contains a Installation SIS file for the OfficeSuite b User s guide in Acrobat PDF format 3 Bluetooth 4 Enable the Bluetooth transfer on both the desktop PC and SmartPhone and use a Bluetooth connection to install the SIS files on your mobile device 5 The newly transferred SIS file will appear as new messages in the inbox of your phone Open the Inbox and start 1t to install the program on your mobile phone 6 Follow the instructions on the screen to install the software Once the installation is complete the OfficeSuite icon will appear in the default install directory
26. and browse through all available fonts on the phone to set the desired one If on the other hand the font used in the document is available on the phone the document will be opened with it t OCS wine lower dior Default Font Times Hew Roman Text Boundaries off Help The Help option allows you to access the Help Manual for OfficeSuite and the general information of the program including version web and mailing address MobiSystems OfficeSuite e 18 Scrolling View Mode allows you to scroll by lines and by full pages Use the 5 way navigator up and down arrows to scroll one line at a time Use the 5 way navigator left and right arrows to scroll full pages In View Mode you can preview pictures and images scroll through tables and through any hyperlinks available in the document To preview an image scroll to the image so that it is visible on the screen and press the 5 way navigation key The image will be selected Choose Preview with the left soft key and the image will be opened in a separate screen DOES r E focsimpl Mef p wine loyer doc ceneri characteristics Preview Back To scroll within a table move to the table and press the 5 way navigation key The table border will change into green and you will see a Scroll option in the low left corner of the screen Press the left soft key under Scroll and then use the arrow left and arrow right keys to move through the table A locs wine l
27. crosoft Word Documents DOC and RTF for text documents 4 Press Ok to confirm MobiSystems OfficeSuite e 14 Working with Text Documents The OfficeSuite has two main modes which you can use to view and edit your documents View Mode and Edit Mode View Mode Whenever you open a document it 1s opened by default in View Mode This mode facilitates your viewing of a document and allows you to easily scroll the information in files To open an existing document select it in the file list in the file explorer and then choose Options gt File gt Open Alternatively you can press the 5 way navigation center key and the file will open View Mode Menu If a document is not in View Mode you can access the View Mode Menu by choosing Options gt View Mode The View Mode Menu has the following menu items Edit Mode By choosing Options gt Edit Mode you will enter the Edit Mode where you can edit the document you have opened Edit Mode has its own edit menu which 1s explained further down this manual File With the File submenus you can manage the currently opened document in the following ways e Save saves the document without changing it s title location or format e Save As saves the document and allows you to choose a new title location and or file format You can choose among these file formats native DOC RTF TXT and MWD and any desired location on the phone e Protect The OfficeSuite allows you to protect your
28. d 29 Valuel value2 are 1 to 29 value arguments from which CHOOSE selects a value or an action to perform based on index_num The arguments can be numbers cell references defined names formulas functions or text COLUMN reference Reference 1s the cell or range of cells for which you want the column number If reference is omitted it is assumed to be the reference of the cell in which the COLUMN function appears Reference cannot refer to multiple areas COLUMNS array Array 1s an array or array formula or a reference to a range of cells for which you want the number of columns HLOOKUP lookup_value table_array row_index_num ra nge_lookup Lookup value is the value to be found in the first row of the array Lookup value can be a value a reference or a text string Table array is a table of information in which data is looked up Use a reference to a range or a range name Row_index_num is the row number in table array from which the matching value will be returned A row_index_ num of 1 returns the first row value in table array a row index num of 2 returns the second row value in table jjj A EE E E and so on Range lookup is a logical value that e 61 INDEX LOOK UP Returns the value of an element in a table or an array selected by the row and column number indexes The INDEX function has two syntax forms array and reference The array form always returns a value or array of values the re
29. d lowercase text are equivalent Result vector is a range that contains only one row or column It must be the same size as lookup vector LOOKUP lookup_value array Lookup value is a value that LOOKUP searches for in an array Lookup value can be a number text a logical value or a name or reference that refers to a value If LOOKUP can t find the lookup value it uses the largest value in the array that is less than or equal to lookup value If lookup value is smaller than the smallest value in the first row or column depending on the array dimensions LOOKUP returns the N A error value Array is a range of cells that contains text numbers or logical values that you want to compare with lookup value The array form of LOOKUP is very similar to the HLOOKUP and VLOOKUP functions The difference is that HLOOKUP searches for lookup value in the first row VLOOKUP searches in the first column and LOOKUP searches according to the dimensions of array If array covers an area that is wider than it is tall more columns than rows LOOKUP searches for lookup value in the first row If array is square or is taller than it is wide more rows than columns LOOKUP searches in the first column With HLOOKUP and VLOOKUP you can index down or across but LOOKUP always selects the last value in the row or column The values in array must be placed in ascending order 2 1 0 1 2 A Z FALSE TRUE otherwise LOOKUP
30. dded as an argument separated with a comma from the previous one To give cells range as an argument of the function just tap on the first cell from the range and drag it in the desired direction until the whole range is selected If you are sure about the syntax of a function and its arguments you can skip steps 2 6 and type in the function directly in the cell edit box in the cell toolbar For instance you can directly type in SUM A1 A6 6 When you have finished entering the function choose Edit gt Insert Function to execute it MobiSystems OfficeSuite e 40 Formula Errors Below is a table of the error messages that MobiSystems SpreadSheet can display in case there is something wrong with a functions arguments FORMULA ERROR Error evaluating formula Out of memory Error Invalid formula Formula error Missing operand Formula error Missing operator Formula error Illegal token Formula error Missing quote Formula error Missing array closing bracket Formula error Illegal identifier Formula error Inconsistent array MobiSystems OfficeSuite DESCRIPTION Insufficient memory for calculating the formula Please check the available free Space on your Palm device and try to free some space Incorrect formula syntax Check if the formula starts with or Missing operator For instance 5 10 will result in this error because there is not operator mathematical operator The
31. e NOT when you want to make sure a value is not equal to one particular value MobiSystems OfficeSuite AND logicall logical2 Logicall logical2 are 1 to 30 conditions you want to test that can be either TRUE or FALSE The arguments must evaluate to logical values such as TRUE or FALSE or the arguments must be arrays or references that contain logical values FALSE You can also type the word FALSE directly onto the worksheet or into the formula and the program interprets it as the logical value FALSE IF logical_test value_if_true value_if_false Logical test is any value or expression that can be evaluated to TRUE or FALSE This argument can use any comparison calculation operator Value if true is the value that is returned if logical test is TRUE Value 1f true can be another formula Value if false is the value that is returned if logical test is FALSE Value if false can be another formula NOT logical Logical is a value or expression that can be evaluated to e 54 TRUE or FALSE Returns TRUE if any OR logicall logical2 argument is TRUE returns FALSE if all Logicall logical2 are 1 to 30 conditions you want to arguments are FALSE test that can be either TRUE or FALSE The arguments must evaluate to logical values such as TRUE or FALSE or in arrays or references that contain logical values If an array or reference argument contains text or empty cells those value
32. e each month If fv is omitted you must include the pmt argument Type is the number 0 or 1 and indicates when payments are due SLN Returns the straight SLN cost salvage life line depreciation of an asset for one period Cost is the initial cost of the asset Salvage is the value at the end of the depreciation sometimes called the salvage value of the asset Life is the number of periods over which the asset is depreciated sometimes called the useful life of the asset SYD Returns the sum of SYD cost salvage life per years digits depreciation of an a for a specified Cost is the initial cost of the asset period SYD is calculated as follows SY D cost salvage life per 1 2 life life 1 Salvage 1s the value at the end of the depreciation sometimes called the salvage value of the asset Life 1s the number of periods over which the asset 1s depreciated sometimes called the useful life of the asset Per is the period and must use the same units as life 1 Remarks for the NPV function e Valuel value2 must be equally spaced in time and occur at the end of each period MobiSystems OfficeSuite e 53 e NPV uses the order of valuel value2 to interpret the order of cash flows Be sure to enter your payment and income values in the correct sequence e Arguments that are numbers empty cells logical values or text representations of numbers are counted arguments that are error values
33. eSuite single text item The text items can be text strings numbers or single cell references EXACT textl text2 Textl is the first text string Text2 is the second text string FIND find_text within_text start_num Find_text is the text you want to find Within text is the text containing the text you want to find Start num specifies the character at which to start the search The first character in within_text is character number 1 If you omit start_num it is assumed to be 1 LEFT text num_chars Text is the text string that contains the characters you want to extract Num chars specifies the number of characters you want LEFT to extract Num chars must be greater than or equal to zero If num chars is greater than the length of text LEFT returns all of text If num chars is omitted it is assumed to be 1 LEN text Text is the text whose length you want to find Spaces count as characters LOWER text Text is the text you want to convert to lowercase LOWER does not change characters in text that are not letters MID text start_num num_chars Text 1s the text string containing the characters you want to extract Start_num is the position of the first character you want to extract in text The first character in text has start_num 1 and so on Num_chars specifies the number of characters you want MID to return from text e 66 PROPE R REPLA CE REPT RIGHT SUBSTI TUTE Capitalize
34. eSuite e 16 Docs story doc insensitive O sensitive Go to The Go to option redirects you to the top bottom or available bookmarks in the document Alternatively you can use the keyboard shortcuts 1 to go to Top 0 to go to the Bottom and 2 to go to Bookmark Zoom The Zoom feature allows you to zoom in and out of the text increasing or decreasing the text size The supported zoom sizes are 25 50 75 100 and 200 In addition through the Custom option in the zoom pop up menu the program allows you to specify a custom zoom percent ranging from 100 up to 200 To choose a zoom size choose Options gt Zoom Alternatively you can use as shortcuts 4 and 7 keys from the keyboard to zoom out and zoom in respectively Word Count The Word Count option gives you the ability to count the Words Characters with and without Spaces Paragraphs and Sections in the currently opened document MobiSystems OfficeSuite e 17 Words 1314 Charsino spaces 6716 Chars 8007 Paragraphs 54 Sections 1 Peral Cherecterisucs A a Neem be B TE Wine Designation This OK To close the Word Count form choose Ok Options The OfficeSuite allows you to set a default Font to view all documents if you do not have the font which is used in the document installed to the phone Depending on your smartphone model you can have different fonts installed You can set the default font through Options gt Preferences
35. er To view attachments go to the Messaging Application gt Inbox and open the message which contains the attachment Highlight attachment and press the 5 navigation key center You will see the Attachment menu where you can choose to Retrieve Open or Save the attachment Save the file in any folder and open it with the OfficeSuite MobiSystems OfficeSuite e 12 e Memory Card Reader You can copy files from the PC to a memory card reader and insert the memory card to the phone From the phone to the PC save the files to the memory card and open the files on the PC using the PC memory card reader File Formats and Format Converting In addition to the MobiSystems native document formats for text documents the program allows you to work with some external native text and spreadsheet files without the need of any format conversion The file formats that MobiSystems OfficeSuite recognizes and the program is capable to open and modify are Text formats O MWD this is the native file format of MobiSystems Docs MWD documents can be kept on both memory card and the main memory of your PDA In the file explorer the MWD documents appear with MWD extension O DOC Microsoft Word text documents Can be kept in both the main memory and on memory card You can directly access DOC files from memory cards o l TXT the commonly used TXT format ensures the compatibility of OfficeSuite y y with third party desktop programs TXT files can
36. ese options from the Options menu in the File Explorer Browsing Directories and Files The OfficeSuite File Explorer allows you to browse files and directories on both phone and memory card You can open folders and subfolders and work with files stored anywhere on your phone To open a directory or file select the item in the file explorer and use the file explorer menu or the 5 navigaiton center button to open it oy OfficeSuite i en ments docu 2 C excel xa inbox images nokia B others sounds B tmp Options Exit Options Back MobiSystems OfficeSuite e 10 Using the 5 way navigation button The easiest way to browse through or open the available directories on your phone is by using the 5 way navigation key You can use the 5 way navigation key in the following ways Selection Key opens highlighted directory or file Arrow up moves highlight up by one file or directory Down arrow moves highlight down by one file or directory Left Arrow scrolls a level down in the directory tree and opens highlighted directory or file Right Arrow scrolls one level up in the directory tree File Explorer Menu To create a new file open existing ones and send files to other mobile devices or to the PC you can use the File Explorer Menu To access the File Explorer Menu select Options in the File Explorer screen The following options are available in the File Explorer New by choosing Options gt
37. ete with Delete you can delete entire rows and columns Select the row column which you wish to delete and choose Options gt Delete gt Entire Row or Entire Column MobiSystems OfficeSuite e 33 Insert Spreadsheet allows you to insert functions single rows or columns and new worksheets to the currently opened workbook Edit Cell File Edit Column s Row s Workshee Worksheet Select Cancel To insert a function 1 Select the cell where you wish insert the function 2 Choose Options gt Insert gt Function 3 Choose the function you want from Formula Type screen and press Ok Formula Type Select a formula AVERAGEISO All COUNT Iist Database IF test val if true v Information MAX list Logical MIN St To insert rows or columns 1 Select row or a column next to which you want to place the new item 2 Choose Options gt Insert Column Row and the item will be inserted To insert a worksheet 1 Choose Options gt Insert gt Worksheet and the item will be inserted 2 Choose where you wish to insert the sheet before or at the end of the currently opened sheet and choose Ok MobiSystems OfficeSuite e 34 My Monthly Budget Insert Before Sheet Name Family Monthly Bud sa Abe i Mery sheets Insert at the end Search With the Search submenus you search for a word part of a word or a number within a cell and replace it with new data my Dudget sls Family Monthly Budget
38. ference form always returns a reference Use the array form if the first argument to INDEX is an array constant Returns a value either from a one row or one column range or from an array The LOOKUP function has two syntax forms vector and array The vector form of LOOKUP looks in a one row or one column range known as a vector for a MobiSystems OfficeSuite specifies whether you want HLOOKUP to find an exact match or an approximate match If TRUE or omitted an approximate match is returned In other words if an exact match is not found the next largest value that is less than lookup value is returned INDEX array row_num column_num Array is a range of cells or an array constant If array contains only one row or column the corresponding row_num or column_num argument is optional If array has more than one row and more than one column and only row_num or column_num is used INDEX returns an array of the entire row or column in array Row_num selects the row in array from which to return a value If row_num is omitted column num is required Column_num selects the column in array from which to return a value If column num is omitted row_num is required INDEX reference row_num column_num area_num Reference is a reference to one or more cell ranges If you are entering a nonadjacent range for the reference enclose reference in parentheses If each area in reference contains only one row or column t
39. h On Go to the second tab where you will be able to see all Bluetooth devices in the range Search for the PC connection and when it is established right click on the file which you wish to send and select Send to Bluetooth and the name of your phone The file will be transferred to the inbox on the phone To send files from the phone to the PC establish a connection with the PC and when the phone and PC are paired select the file which you wish to send and choose Options gt Send gt via Bluetooth Select the PC to send the file To send files to other Bluetooth devices turn on the Bluetooth of your phone and locate the other Bluetooth device Go to the File Explorer to select the file which you wish to transfer Choose Options gt Send gt via Bluetooth Eb cuctomor lis 4d Hew File b Registe via Infrared About Exit e USB Cable to send files through this method connects the phone to the PC via USB cable and use the Nokia PC Suite to transfer the files to and from the phone e Attachment in Email message to be able to receive a document as an e mail message you need to set up e mail on your phone Please refer to the phone user manual for details on setting up email After setting up the email you can access received messages from the Messaging Application gt Inbox on the phone and open the files directly with the OfficeSuite You can also move the files from the Inbox to any other folder in the OfficeSuite file explor
40. haves like ROUND except that it always rounds a number down Rounds a number up away from 0 zero ROUNDUP behaves like ROUND except that it always rounds a number up Returns the sine of the given angle If your argument is in degrees multiply it by PIO 180 or use the RADIANS function to convert it to radians Returns the hyperbolic sine of a number Returns a positive square root If number is negative SQRT returns an error value Adds all the numbers in a range of cells MobiSystems OfficeSuite ROUND number num_digits Number is the number you want to round Num digits specifies the number of digits to which you want to round number If num digits is greater than 0 zero then number is rounded to the specified number of decimal places If num digits is 0 then number is rounded to the nearest integer If num digits is less than 0 then number is rounded to the left of the decimal point ROUNDDOWN number num_ digits Number is any real number that you want rounded down Num digits is the number of digits to which you want to round number ROUNDUP number num_digi ts Number is any real number that you want rounded up Num digits is the number of digits to which you want to round number SIN number Number is the angle in radians for which you want the sine SINH number Number is any real number SORT number Number is the number for which you want the sq
41. he range pi 2 to pi 2 Returns the arctangent or inverse tangent of the specified x and y coordinates The arctangent is the angle from the x axis to a line containing the origin 0 0 and a point with coordinates x_num y_num The angle is given in radians between pi and pi excluding pi Returns the inverse hyperbolic tangent of a number Number must be between 1 and 1 excluding 1 and 1 The inverse hyperbolic tangent 1s the value whose hyperbolic tangent is number so ATANH TANH number equals number Returns the cosine of the given angle Returns the hyperbolic cosine of a number Counts the number of cells within a range that meet the given criteria Converts radians into degrees MobiSystems OfficeSuite ATAN number Number is the tangent of the angle you want ATAN2 X Y X 1s the x coordinate of the point and Y is the y coordinate of the point ATANH number Number is any real number between and 1 COS number Number is the angle in radians for which you want the cosine COSH number Number is any real number for which you want to find the hyperbolic cosine COUNTIF range criteria Range is the range of cells from which you want to count cells Criteria is the criteria in the form of a number expression or text that defines which cells will be counted DEGREES angle Angle is the angle in radians that you want to convert ATAN 1 Arc
42. he data you want to find The V in VLOOKUP stands for Vertical Text and Data CONC ATENAT MobiSystems OfficeSuite Returns the character specified by a number Use CHAR to translate code page numbers you might get from files on other types of computers into characters Joins several text strings into one text VLOOKUP lookup_value table_array col_index_num ran ge_lookup Lookup value is the value to be found in the first column of the array Lookup value can be a value a reference or a text string Table array is the table of information in which data is looked up Use a reference to a range or a range name such as Database or List If range lookup is TRUE the values in the first column of table array must be placed in ascending order 2 1 0 1 2 A Z FALSE TRUE otherwise VLOOKUP may not give the correct value If range lookup is FALSE table array does not need to be sorted You can put the values in ascending order by choosing the Sort command from the Data menu and selecting Ascending The values in the first column of table array can be text numbers or logical values Col index num is the column number in table_array from which the matching value must be returned A col index num of 1 returns the value in the first column in table array a col index num of 2 returns the value in the second column in table array and so on Range lookup is a logical value that specifies whether
43. he row_num or column_num argument respectively is optional For example for a single row reference use INDEX reference column_ num Row_num is the number of the row in reference from which to return a reference Column_num is the number of the column in reference from which to return a reference Area_num selects a range in reference from which to return the intersection of row_num and column_num The first area selected or entered is numbered 1 the second 1s 2 and so on If area num is omitted INDEX uses area 1 LOOKUP lookup_value lookup_vector result_ve ctor Lookup value is a value that LOOKUP searches for in the first vector Lookup value can be a number text a logical value or a name or reference that refers to a value e 62 MATC value and returns a value from the same position in a second one row or one column range The array form of LOOKUP looks in the first row or column of an array for the specified value and returns a value from the same position in the last row or column of the array Returns the relative position of an item in an array or a reference that MobiSystems OfficeSuite Lookup vector is a range that contains only one row or one column The values in lookup vector can be text numbers or logical values The values in lookup vector must be placed in ascending order 2 1 0 1 2 A Z FALSE TRUE otherwise LOOKUP may not give the correct value Uppercase an
44. in ascending order 2 1 0 1 2 A Z FALSE TRUE If match_type is 0 MATCH finds the first value that is exactly equal to lookup value Lookup array can be in any order If match_type is 1 MATCH finds the smallest value that is greater than or equal to lookup value Lookup array must be placed in descending order TRUE FALSE Z A 2 1 0 1 2 and so on If match type is omitted it is assumed to be 1 ROW reference Reference 1s the cell or range of cells for which you want the row number If reference is omitted it is assumed to be the reference of the cell in which the ROW function appears Reference cannot refer to multiple areas ROWS array Array 1s an array an array formula or a reference to a range of cells for which you want the number of rows TRANSPOSE array Array is an array or range of cells on a worksheet that you want to transpose The transpose of an array 1s created by using the first row of the array as the first column of the new array the second row of the array as the second column of the new array and so on e 64 has columns and rows Use TRANSPOSE to shift the vertical and horizontal orientation of an array on a worksheet Searches for a value in the leftmost column of a table and then returns a value in the same row from a column you specify in the table Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of t
45. ings Choose the List section to choose Bulleted 3 Scroll down to the Style section 4 Select Style and choose the desired style for the Bullets Choose Ok to confirm 5 Ifyou have already used bullets in your document and want to start over a new enumeration and or respectively change the bulleted style choose Indexes gt Restart 6 To continue a bulleted text choose Indexes gt Continue MobiSystems OfficeSuite e 25 DOCS wine lover doc Bulleted Style Square Indexes Continue To change the style of existing bullets 1 Select the bulleted text in the document 2 Open the bullets numbering preference by selection Insert Bullets Numbering 3 Choose Style 4 Select a new style from the list and tap OK 5 The changes will be automatically applied to the selected text Numbering OfficeSuite supports several numbering styles including numeric alpha numeric and Roman styles The numbering settings are accessible through the Options gt Insert Bullets Numbering Numbered text can be inserted or modified in the similar way described in Bullets If you have already used numbering in your document and want to start over a new enumeration and or respectively change the numbering style choose Indexes gt Restart To continue a numbered text choose Indexes gt Continue Picture MobiSystems OfficeSuite allows you to insert pictures and images from your phone or from the phone s memory card You can
46. insert native BMP PNG GIF and JPEG files To insert a picture choose Options gt Insert gt Picture and browse the phone to locate the desired picture Choose Ok to insert To take a closer look at an image use the Image Preview feature by scrolling to the image in View Mode and pressing the 5 way navigation key Choose Preview and the image will be displayed in a new screen MobiSystems OfficeSuite e 26 Table If you need to organize data for better comprehension you can use the Table option To insert a table 1 Choose Insert gt Table 2 A new form will appear where you can specify the number of rows and columns for the table 3 Click OK to confirm and insert the table Columns 2 To insert text into a table s cell simply tap in the cell and begin writing MobiSystems OfficeSuite has the unique feature of allowing images and even other tables to be embedded in an existing table Page Breaks The OfficeSuite offers several different Page Breaks which you can insert to format your pages To access the Page Break list from Insert gt Break A IIIIT III__I_I Break type Page break Text wrapping break section on next pao Section continues Section on even pa MobiSystems OfficeSuite e 27 Bookmarks The bookmark feature allows you to create virtual marks at desired places in your text document so you access these places easier later To add a bookmark 1 Select the text to which you wan
47. ksheet make sure the sheet is active and choose Options gt Worksheet gt Rename Enter the new name in the textbox provided and press Ok to confirm e Delete to Delete a worksheet make sure the sheet is active and choose Options gt Worksheet gt Delete e Protect you can protect a worksheet from unauthorized viewing by a password To do that open the worksheet and choose Options gt Worksheet gt Protect To remove the password choose Options gt Worksheet gt Unprotect Please note that you can protect worksheets only and not an entire workbook Full Screen To use the whole screen of your phone as a text entry work area use the Full Screen option that Spreadsheets provides To switch to Full Screen choose Options gt Full Screen To exit Full Screen choose Options gt Full Screen Alternatively you can use the shortcut key from the keyboard to switch to and to exit Full Screen Page Scroll The OfficeSuite allows you to scroll your spreadsheets one line at a time or by pages To activate the Page Scroll choose Options gt Page Scroll After that use the 5 way navigation key to scroll up and down the sheet Alternatively you can activate the Page Scroll by pressing the key from the keyboard Cell Formatting The Spreadsheet program allows you to assign and modify a cell type as well as specify a common format for the selected type You can also manage the text aligning in cells and MobiSystems OfficeSuite e 36 acce
48. lay the text boundaries such as all available breaks in the document To do that choose Text Boundaries On Off with the arrow left and arrow right keys form the 5 way navigation key Spelling Options MobiSystems OfficeSuite comes with an integrated spell checker and a fast text entry program with free spelling dictionaries in 6 languages English German Spanish French Italian and Dutch This allows the following spelling features Suggestion of correct alternatives for misspelled words Suggestion popup lists on each entered character Underlining of misspelled words Spell checks for imported documents 4 spelling dictionaries for each of the supported languages gt Docs F pe Docs Ri wine lover dac T Wine lover doc Dictionary List size Dutch Ample 2 lines Quick Write List sorting on by Frequency E Show after Spell Check 1 letter on SAYE we Back Save Y z E Back xx gt rr rrErErRrRrwXwrXwa a o aoa a a Ao oA gt J X i wI IA T T TZT To customize the spelling features in OfficeSuite choose Options gt Spelling Options while you are in Edit Mode e QuickWrite when this option is enabled MobiSystems OfficeSuite will suggest words by trying to predict the word you are typing on every character input To disable the word prediction set this field to Off e Show after this option allows you to specify how many letters of the word should be entered before the pop up suggestion
49. list appears MobiSystems OfficeSuite e 29 e List Size to change the number of words shown in the pop up suggestion list open the list with available choices with the 5 way navigation center key and select a length between 2 3 or 4 words e List Sorting this field determines the sorting of the words in the pop up suggestion list You can choose between sorting by word usage frequency or alphabetical order The sorting by frequency significantly increases the typing speed The more you use MobiSystems OfficeSuite the more accurate and relevant the suggestion lists gets e Spell Check when this feature is enabled MobiSystems OfficeSuite will automatically check and underline all misspelled words To disable the misspelled words underlining set the field to Off Dictionaries Management Mobile Systems dictionary databases have been developed to meet the requirements of a wide range of users Their entries have been selected and compiled after thorough analyses of various texts and speech patterns The OfficeSuite comes with dictionaries in 6 different languages English German Italian Spanish French and Dutch The dictionaries are included in the installation sis file for the OfficeSuite program When you install the program the installation allows you to choose the dictionaries which you wish to install from a list To install a dictionary check the dictionary checkbox next to it To remove a dictionary from the list
50. losing the password protected file you need to save it so that the encryption 1s saved Next time you open the file you will be requested to enter your Password To remove the Password open the file and choose Options gt File gt Unprotect and Save the file again to keep the changes e Close closes the file MobiSystems OfficeSuite e 20 Edit F Undo Redo Cut Search Copy Go to Paste Format Select all Select Cancel With the Edit submenus you can manage the text inside a document in the following way e Undo if you wish to undo the latest actions you have done to the document choose Undo and the file will return to its original state e Redo if you wish to redo the action which you have undone choose Redo e Cut saves the contents of the selection in the systems clipboard and the cut selection area 1s deleted The operation is used altogether with Copy and Paste To cut a cell value select the cell and choose Edit gt Cut e Copy the contents of the clipboard is copied in the selected area The copy selection area must be of the same type rows or columns as the data in the clipboard The operation is usually used after Cut as well as in combination with Paste e Paste Copies the contents of the clipboard usually selected with Copy or Cut in the highlighted area of rows or columns The size of the paste selection area should be the same as the contents of the clipboard e Select All selects the entire c
51. lue can be a blank empty cell error logical text number or reference value or a name referring to any of these that you want to test ISEVEN number Number is the value to test If number is not an integer it is truncated ISODD number Number is the value to test If number is not an integer it is truncated If number is nonnumeric ISODD returns the V ALUE error value N value Value is the value you want converted N converts values listed in the following table ERROR TYPE e 59 FN A 7 Anything else FN A IS Functions Each of these functions referred to collectively as the IS functions checks the type of value and returns TRUE or FALSE depending on the outcome For example the ISBLANK function returns the logical value TRUE if value is a reference to an empty cell otherwise it returns FALSE ISBLANK value ISERR value ISERROR value ISLOGICAL value ISNA value ISNONTEXT value ISNUMBER value ISREF value ISTEXT value The IS functions are useful in formulas for testing the outcome of a calculation When combined with the IF function they provide a method for locating errors in formulas see the following examples Function Returns TRUE if ISBLANK Value refers to an empty cell ISERR Value refers to any error value except N A ISERROR Value refers to any error value N A FVALUE REF DIV 0 NUM FNAME or NULL ISLOGICAL Value refers to a logical value ISNA
52. match conditions you specify The field argument is optional If field is omitted DCOUNTA counts all records in the database that match the criteria DGET Extracts a single value from a column of a list or database that matches conditions you specify DMAX Returns the largest number in a column of a list or database that matches conditions you specify Returns the smallest number in a column of a list or database that matches conditions you specify DPROD Multiplies the values UCT in a column of a list or database that match conditions you specify DSTDE Estimates the standard deviation of a population V based on a sample by using the numbers in a column of a list or database that match conditions you specify DSTDE Calculates the standard deviation of a VP population based on the entire population using the numbers in a column of a list or database that match conditions you specify MobiSystems OfficeSuite DCOUNTA database field criteria DGET database field criteria DMAX database field criteria DMIN database field criteria DPRODUCT database field criteria DSTDEV database field criteria DSTDEVP database field criteria e 49 Financial Adds the numbers in a column of a list or database that match conditions you specify Estimates the variance of a population based on a sample by using the numbers in a column of a list or database that match condition
53. mber is the exponent applied to the base e FACT number Number is the nonnegative number you want the factorial of If number is not an integer it 18 truncated INT number Number is the real number you want to round down to an integer LN number Number is the positive real number for which you want the natural logarithm LOG number base Number is the positive real number for which you want the logarithm Base is the base of the logarithm If base is omitted it 18 assumed to be 10 EVEN 1 5 Rounds 1 5 up to the nearest even integer 2 EVEN 3 Rounds 3 up to the nearest even integer 4 FACT S Factorial of 5 or 1 2 3 4 5 120 INT 8 9 Rounds 8 9 down 8 INT 8 9 Rounds 8 9 down LN 86 Natural logarithm of 86 4 454347 LN 2 7182818 Natural logarithm of the value of the constant e 1 LOG 10 Logarithm of 10 1 LOG 8 2 Logarithm of 8 with base 2 3 e 45 Returns the base 10 logarithm of a number Returns the remainder after number is divided by divisor The result has the same sign as divisor The MOD function can be expressed in terms of the INT function MOD n d n a LNT A d Returns number rounded up to the nearest odd integer The function can be used for numeric fields Returns the number 3 14159265358979 the mathematical constant pi Returns the result of a number raised to a power Multiplies all the number
54. ns To freeze a column or row or selection of columns or rows select the object s and choose Options gt Format gt Freeze To unfreeze a row or column choose Options gt Format gt Unfreeze MobiSystems OfficeSuite e 38 Zoom The Zoom option allows you to Zoom in and out of the text increasing or decreasing the text size The supported zoom sizes are 25 50 75 100 and 200 In addition through the Custom option in the zoom pop up menu the program allows you to specify a custom zoom percent ranging from 100 up to 200 Column Width With MobiSystems Spreadsheet you can change the size of width of column To widen or narrow a column select one or more cells from the column and choose Options gt A djust Column Width With the arrow left and arrow right keys widen or narrow the column and press the 5 way navigation center key to confirm the desired width my budget gls Family Monthly Budget A Preferences MobiSystems Spreadsheet allows you to choose different CSV separators enable Automatic calculation of formulas and show and hide Gridlines and Headers in a worksheet To set your desired preferences choose Options gt Preferences and enter the Preferences form Use the 5 way navigation button to scroll down the available fields Register From Options gt Register you can enter the Registration form and enter the Unlock key to register the program to your phone Help The program offers a Help Manual which y
55. nstant interest rate PMT Calculates the payment for a loan based on constant payments and a constant interest rate PV Returns the present value of an investment The present value is the total amount that a series of future payments is worth now For example when you borrow money the loan amount is the present value to the MobiSystems OfficeSuite Rate is the rate of discount over the length of one period Valuel value2 are 1 to 29 arguments representing the payments and income PPMT rate per nper pv fv type Rate is the interest rate per period Per specifies the period and must be in the range 1 to nper Nper is the total number of payment periods in an annuity Pv is the present value the total amount that a series of future payments is worth now Fv is the future value or a cash balance you want to attain after the last payment is made If fv is omitted it is assumed to be 0 zero that is the future value of a loan is 0 Type is the number 0 or 1 and indicates when payments are due PMT rate nper pv fv type For a more complete description of the arguments in PMT see the PV function Rateis the interest rate for the loan Nper is the total number of payments for the loan Pv is the present value or the total amount that a series of future payments 1s worth now also known as the principal Fv is the future value or a cash balance you want to attain after the last paymen
56. nt the Agreement is a legal agreement between you Licensee the end user and Mobile Systems Inc Mobile Systems for the use of the MobiSystems Docs software product Software By using this Software or any part of it you are agreeing to be bound by the terms of this Agreement If you do not agree to the terms of this Agreement do not install this Software License and Distribution The evaluation copy of this Software 1s free of charge for 30 days trial period of time You must pay the license fee and register your copy to continue to use the Software and remove the nag screen after this period The evaluation copy is fully functional except for the nag screen that slows the start up the more times you start the program You are allowed to make as many copies of this evaluation version in UNMODIFIED form as you wish to distribute Restrictions You may not nor permit anyone else to de compile reverse engineer or disassemble modify or create derivative works based on the SOFTWARE or the documentation in whole or in part You may not use the Software for any commercial purpose or public display performance sale or rental You may not use the Software to perform any unauthorized transfer of information e g transfer of files in violation of a copyright or for any illegal purpose No Warranties This software and any related documentation is provided as is without warranty of any kind Mobile Systems Inc specific
57. of dictionaries to be installed uncheck the checkbox next to its name The dictionaries will be located by the program the first time you open a file in Edit Mode Choose Ok with the left soft key to confirm adding the dictionaries to the program After that again while you are in Edit Mode you can choose the dictionary which you wish to use To set the dictionary choose Options gt Spelling Options In the Dictionary field use the arrow left and arrow right keys scroll through the dictionaries After you choose the desired dictionary press Save By Docs wine lover doc T Dictionary Dutch mple O English Ample French Ample German Ample Italian Ample Help You can access the Help for the Office Suite from Options gt Help MobiSystems OfficeSuite e 30 Registration To Register the program choose Options gt Registration and enter the unlock key which you have received after the purchase in the space box provided MobiSystems OfficeSuite e 31 Working with Worksheets and Workbooks The primary document that you use in MobiSystems Spreadsheet to store and work with data is called worksheet or spreadsheet A worksheet consists of cells that are organized into columns and rows A worksheet is always stored in a workbook A workbook 1s a file that contains one or more worksheets that you can use to organize various kinds of related information You can enter edit data and perform calculations based on data
58. of old text you want to replace with new text If you specify instance num only that instance of old text is replaced Otherwise every occurrence of old text in text is changed to new text T value Value is the value you want to test TRIM text Text is the text from which you want spaces removed UPPER text Text is the text you want converted to uppercase Text can be a reference or text string e 68
59. ontents of the document both text and images Search With the Search submenus you can locate and replace a word or part of a word within the document The Search menu has the following submenus MobiSystems OfficeSuite e 21 Replace Wines Case insensitive e Find to enter the words you wish to locate choose Search gt Find and enter the text in the screen Choose Find e Find next to find the next entry in the text choose Search gt Find Next You can also use the Left and Right Soft Keys from the keyboard as short cuts respectively as Find and Find next e Replace to replace text in your document choose Search gt Replace and enter the text which you wish to replace and the new text Choose Replace If you want small and capital letters to be considered during the search enable the Case sensitive option Docs dog wine lover doc refers to a AS alleged quality If it s from within Europe the wording must determine between the different categories of wine Le Table Wine Quality Wine etc Geographical Reference This can be anything from the Replace Cancel Go to Redirects you to the top bottom or available bookmarks in the document Format With the Format submenus you can enter the Font and Paragraph screens to manage the Fonts and Paragraph alignment in the document MobiSystems OfficeSuite e 22 e Font to change your Font Preferences choose Format gt Font and you will enter the Font
60. ook without changing it s title location or format e Save As saves the workbook and allows you to choose a new title location or file format if you wish e Go to the Go to function allows you to directly move to a cell by specifying its number e Recalculate the Recalculate function recalculates all cell values automatically e Close closes the workbook Edit With the Edit submenus you can manage the data inside a workbook in the following way e Undo if you wish to undo the latest actions you have done to the document choose Undo and the file will return to 1ts original state e Redo if you wish to redo the action which you have undone choose Redo e Cut saves the contents of the selection in the systems clipboard and the cut selection area is deleted The operation is used altogether with Copy and Paste To cut a cell value select the cell and choose Edit gt Cut e Copy the contents of the clipboard is copied in the selected area The copy selection area must be of the same type rows or columns as the data in the clipboard The operation is usually used after Cut as well as in combination with Paste e Paste Copies the contents of the clipboard usually selected with Copy or Cut in the highlighted area of rows or columns The size of the paste selection area should be the same as the contents of the clipboard e Select All selects the entire contents of the document both text and images e Del
61. ou can access through Options gt Help MobiSystems OfficeSuite e 39 Working with Functions Functions are predefined formulas that perform calculations by using specific values called arguments given in field order Functions can be used to perform simple or complex calculations Functions can be embedded in worksheet cells Each function begins with an equal sign followed by the function name an opening parenthesis the arguments for the function separated by commas and a closing parenthesis The arguments can be numbers text logical values such as TRUE or FALSE arrays or cell ranges Arguments can also be constants formulas or other functions Nested Functions In certain cases you may need to use a function as one of the arguments of another function For example the following formula uses a nested SUM function and compares the result with the value 30 IF SUM A1 A7 gt 30 SUM B1 B7 C1 When a nested function is used as an argument it must return the same type of value that the argument uses Inserting a function To insert a function 1 Select the cell where you want to place the function 2 Choose Options gt Insert gt Function 3 Scroll down through the function types until you locate the function that you need 4 When you find the desired function select 1t and tap the OK button 5 The function will be inserted in the edit field and now you can provide 1ts arguments Each next selected cell will be a
62. oyer doc at DOCS wine loyer doc blend varying in percentages of Sauvignon Blanc anc Semillon is typical w some 100 Sauvigne Blanc wines produce Back Scroll S Back To follow a hyperlink scroll to the hyperlink so that it is visible on the screen and press the 5 way navigation center key The hyperlink will be highlighted and you can press Go to Link to follow it MobiSystems OfficeSuite e 19 Editing Documents To manage documents the OfficeSuite has a special Edit Mode To enter into Edit Mode open a document and choose Options gt Edit Mode Edit Mode Menu The Edit Mode Menu has the following menu items View Mode By choosing Options gt View Mode you will enter the View Mode for the document The View mode functionality was described earlier in this document File With the File submenus you can manage the currently opened document in the following ways e Save saves the document without changing it s title location or format e Save As saves the document and allows you to choose a new title location or file format if you wish e Check Spelling the OfficeSuite has a built in spell checker which works with the dictionaries which you have installed together with the program e Protect you can use this option to and protect your private documents from unauthorized opening Choose Options gt File gt Protect and enter a password in the space provided Choose Ok to confirm Upon c
63. rns TRUE if the value is a logical value Checks the type of value and returns TRUE or FALSE depending on the outcome Returns TRUE if the value is the N A error value Checks the type of value and returns TRUE or FALSE depending on the outcome Returns TRUE if the value is not text Checks the type of value and returns TRUE or FALSE depending on the outcome Returns TRUE if the value is a number Checks the type of value and returns TRUE or FALSE depending on the outcome Returns TRUE if the value is a reference MobiSystems OfficeSuite Value is the value you want tested Value can be a blank empty cell error logical text number or reference value or a name referring to any of these that you want to test ISERROR value Value is the value you want tested Value can be a blank empty cell error logical text number or reference value or a name referring to any of these that you want to test ISLOGICAL value Value 1s the value you want tested Value can be a blank empty cell error logical text number or reference value or a name referring to any of these that you want to test ISNA value Value 1s the value you want tested Value can be a blank empty cell error logical text number or reference value or a name referring to any of these that you want to test ISNONTEXT value Value 1s the value you want tested Value can be a blank empty cell error logical text
64. s For example TIME 0 0 2000 e 56 po TIME 0 33 22 023148 or 12 33 20 AM Returns the serial TODAY number of the current date The serial number is the date time code used for date and time calculations Returns the day of the WEEKDAY serial_number return_type week corresponding to a date The day is given as Serial number is a sequential number that represents the an integer ranging from 1 date of the day you are trying to find Dates should be entered Sunday to 7 Saturday by using the DATE function or as results of other formulas or by default functions For example use DATE 2008 5 23 for the 23rd day of May 2008 Returns the year YEAR serial_number corresponding to a date The year is returned as an Serial number is the date of the year you want to find integer in the range 1900 Dates should be entered by using the DATE function or as 192 results of other formulas or functions For example use DATE 2008 5 23 for the 23rd day of May 2008 1 Values returned by the YEAR MONTH and DAY functions will be Gregorian values regardless of the display format for the supplied date value For example if the display format of the supplied date was Hijri the returned values for the YEAR MONTH and DAY functions will be values associated with the equivalent Gregorian date Information ERRO Returns a number ERROR TYPE error_val R TYPE corresponding to one see index of Of the error
65. s are ignored Returns the logical TRUE value TRUE You can enter the value TRUE directly into cells and formulas without using this function The TRUE function 1s provided primarily for compatibility with other spreadsheet programs Date and Time Dates are stored as sequential serial numbers so they can be used in calculations By default January 1 1900 is serial number 1 and January 1 2008 is serial number 39448 because it 1s 39 448 days after January 1 1900 Time values are a portion of a date value and represented by a decimal number for example 12 00 PM is represented as 0 5 because it is half of a day Returns the DATE year month day sequential serial number that represents a particular date Year The year argument can be one to four digits Month is a number representing the month of the year Day is a number representing the day of the month If day is greater than the number of days in the month specified day adds that number of days to the first day in the month For example DATE 2008 1 35 returns the serial number representing February 4 2008 Returns the day of a DAY serial_number date represented by a serial number The day is Serial number is the date of the day you are trying to find MobiSystems OfficeSuite e 55 given as an integer ranging from to 31 Returns the hour of a time value The hour is given as an integer ranging from 0 12 00 A M to 23 11 00 P M Ret
66. s error indicates that invalid array item has been provided Arrays can consist of numbers errors e g REF and logical values true false References cannot be used as array items Example 1 2 A1 The last item in the array is a reference to cell A1 Check the function syntax A closing parenthesis is missing Example SUM A1 B2 The function nesting is on more than 7 levels Unknown function Check the function syntax and name Example ALABALA 5 This error message indicated that an opening or closing apostrophe is missing Example Sheet 1 A1 the apostrophe between 1 and is omitted This error indicates a circular expression that cannot be calculated Example A1 B1 and B1 A1 Evaluation error Check the syntax of the formula and recalculate the formula Invalid formula syntax Not enough arguments were provided for the given formula Check the formula syntax and provide the necessary arguments Invalid formula syntax Too much function arguments are provided Check the formula syntax and provide the necessary argumenis e 42 Function Descriptions Math and Trigonometry ACOS ACOSH ASIN ASINH Returns the absolute value of a number The absolute value of a number is the number without its sign Returns the arccosine or inverse cosine of a number The arccosine 1s the angle whose cosine is number The returned angle is given in radians in the range 0 zero
67. s given as arguments and returns the product Converts degrees to radians Returns an evenly distributed random number greater than or equal to 0 and less than 1 A new random number is returned every time the worksheet is calculated MobiSystems OfficeSuite LOG10 number Number is the positive real number for which you want the base 10 logarithm MOD number divisor Number is the number for which you want to find the remainder Divisor is the number by which you want to divide number ODD number Number is the value to round POWER number power Number is the base number It can be any real number Power 1s the exponent to which the base number is raised PRODUCT numberl number2 ea Number number2 etc are 1 to 30 numbers that you want to multiply RADIANS angle Angle is an angle in degrees that you want to convert LOG10 10 Base 10 logarithm of 10 1 LOG10 1E5 Base 10 logarithm of 1E5 5 MOD 3 2 Remainder of 3 2 1 MOD 3 2 Remainder of 3 2 The sign is the same as divisor 1 ODD 1 5 Rounds 1 5 up to the nearest odd integer 3 PI 2 Pi 2 1 570796327 POWER 5 2 5 squared 25 PRODUCT A2 A4 Multiplies the numbers contained in cells A2 A3 and A4 RADIANS 270 270 degrees as radians 4 712389 or 3n 2 radians e 46 Rounds a number to a specified number of digits Rounds a number down toward zero ROUNDDOWN be
68. s the first letter in a text string and any other letters in text that follow any character other than a letter Converts all other letters to lowercase letters REPLACE replaces part of a text string based on the number of characters you specify with a different text string Repeats text a given number of times Use REPT to fill a cell with a number of instances of a text string If number_times is 0 zero REPT returns empty text If number times is not an integer 1t 1s truncated RIGHT returns the last character or characters in a text string based on the number of characters you specify Num chars must be greater than or equal to zero If num chars is greater than the length of text RIGHT returns all of text If num chars is omitted it is assumed to be 1 Substitutes new text for old text in a text string Use SUBSTITUTE when you want to replace specific text in a text string use REPLACE when you want to replace MobiSystems OfficeSuite PROPER text Text is text enclosed in quotation marks a formula that returns text or a reference to a cell containing the text you want to partially capitalize REPLACE old_text start_num num_chars new_text Old text is text in which you want to replace some characters Start num is the position of the character in old text that you want to replace with new text Num chars is the number of characters in old text that you want REPLACE to replace
69. s you specify Calculates the variance of a population based on the entire population by using the numbers in a column of a list or database that match conditions you specify Returns the depreciation of an asset for a specified period using the double declining balance method or some other method you specify Returns the effective annual interest rate given the nominal annual interest rate and the number of compounding periods per year Returns the future value of an investment based on periodic constant payments and a constant interest rate MobiSystems OfficeSuite DSUM database field criteria DVAR database field criteria DVARP database field criteria DDB cost salvage life period factor Cost 1s the initial cost of the asset Salvage 1s the value at the end of the depreciation Life is the number of periods over which the asset is being depreciated the useful life of the asset Period is the period for which you want to calculate the depreciation Period must use the same units as life Factor is the rate at which the balance declines If factor 1s omitted it is assumed to be 2 the double declining balance method EFFECT nominal_rate npery Nominal rate is the nominal interest rate Npery is the number of compounding periods per year EFFECT is calculated as follows EFFECT POWER 1 Nominal_rate Npery Npery 1 FV rate nper pmt pv type Rate is the interest rate per
70. se through the different color with the left and right arrows from the 5 navigation key o To change the background color of the text select the text and choose Format gt Font gt Highlight You can browse through the different colors with the left and right arrows from the 5 navigation key Alternatively use the 5 navigation center key to open the form of available colors and browse through it e Paragraph to change the alignment of a paragraph select the paragraph and choose Format gt Paragraph Use the arrow left and arrow right keys to scroll through the four options Left Center Right and Justify Choose Ok to confirm the new alignment MobiSystems OfficeSuite e 23 Zoom Just like in View Mode you can change the Zoom of the document to 25 50 75 100 200 or customize zoom to your preference Word Count This option gives you a count of the Words Characters with and without spaces Paragraphs and Sections in the currently opened document Hyperlink MobiSystems OfficeSuite allows you to create hyperlinks to URLs local bookmarks in the current document and other files In case the hyperlink points to a URL MobiSystems OfficeSuite will use the default web browser on your handled device if any to open the Internet site to which the link refers to To add a hyperlink 1 Select the text to which you want to assign the link 2 Choose Options gt Hyperlink gt A dd hyperlink 3 In the next form use the
71. shareware product available for limited free evaluation period or registration at our home site www mobi systems com A license key for the software will be sent to the e mail address specified during your order shortly The license key is a numeric combination of 2x5 symbols for example 32454 11562 To switch to the full unlimited version of MobiSystems OfficeSuite 1 Start the software from the applications launcher The following form will appear F OfficeSuite HI MobileSystems version 2 00 2 days lett in trial period For registration visit MIWA mobi systems com Conwrinht mm 2nnA 2 04 Options Exit 2 Select Options and then Register from the popup menu that will appear 3 Type in your license key in the provided space MobiSystems OfficeSuite 8 i Mobile Systems version 2 00 2 days left in trial period 4 Tap on OK to confirm or Cancel to abort the entry MobiSystems OfficeSuite OfficeSuite File Explorer To start OfficeSuite just go to the application menu on your SmartPhone and select the La icon below OfficeSuite Whenever you start the program the OfficeSuite File Explorer will open Through the file explorer you can browse all directories and folders available on your phone The explorer also allows you to create new folders documents and sheets rename documents change files locations open delete find send documents and change file formats You can access th
72. ss advanced font types styles and color settings All these options are accessible through Options gt Format Cell Format Types and Settings The cell properties and settings vary for the different cell types To assign a particular type to a cell or range of cells eo e eeeeeooeoeoeoooeoeoeoeeeeeeeeeeoeooeeeeeeeceoeeeeeoeoooeooeoeoeoococoeoeoeeeeeoeoeeeeeooeoeoeeooeoeoeooe9eo9o0eo0eo0e0e000eo9e0099e99eew Format type Number Currency Date Time 1 Select the cell or the range of cells in the worksheet 2 Choose Options gt Format gt Number 3 The Format Type screen will open where you can choose the desired format for the cell or range of cells 4 The following cell formats are available a Number for cells of type Number you can specify the number of decimal places to be shown whether 1000 separators should be used and the format in which negative numbers should be shown b General you can enter data in any formatting Currency for the currency type you can specify the number of decimal places the currency symbol position of the currency symbol and the format of the negative values d Date MobiSystems Spreadsheet allows you to select date format among a list of 16 different formats e Time you can select the desired time format among a list of five different formats f Percentage you can specify the number of decimal places to be shown for the percentage type g Te
73. t is made If fv is omitted it is assumed to be 0 zero that is the future value of a loan 1s 0 Type is the number 0 zero or and indicates when payments are due PV rate nper pmt fv type Rate is the interest rate per period For example if you obtain an automobile loan at a 10 percent annual interest rate and make monthly payments your interest rate per month is 10 12 or 0 83 You would enter 10 12 or 0 83 or 0 0083 into the formula as the rate Nper is the total number of payment periods in an annuity e 52 lender For example if you get a four year car loan and make monthly payments your loan has 4 12 or 48 periods You would enter 48 into the formula for nper Pmt is the payment made each period and cannot change over the life of the annuity Typically pmt includes principal and interest but no other fees or taxes For example the monthly payments on a 10 000 four year car loan at 12 percent are 263 33 You would enter 263 33 into the formula as the pmt If pmt is omitted you must include the fv argument Fv is the future value or a cash balance you want to attain after the last payment is made If fv is omitted it is assumed to be O the future value of a loan for example 1s 0 For example if you want to save 50 000 to pay for a special project in 18 years then 50 000 is the future value You could then make a conservative guess at an interest rate and determine how much you must sav
74. t to assign a book mark 2 Choose Insert gt Bookmark gt Options gt New and type in a name for the bookmark in the box provided 3 Choose Done and the bookmark will be set 4 To go to a bookmarked place 5 Choose Options gt Go to gt Bookmark 6 Choose the desired Bookmark by scrolling with the 5 way navigation key and choose Done 7 The program will return to the chosen bookmark in the document To delete a bookmark 1 Choose Insert gt Bookmark gt Options gt Delete You can sort the list of existing bookmarks by Name alphabetically and by Location To do that choose Insert gt Bookmark gt Options gt Sort by Name or Insert gt Bookmark gt Options gt Sort by Location Hew 1 Lo to Delete Sort by Name Sort by Location Select Cancel Options MobiSystems OfficeSuite allows you to set a default Font which you wish to use in the documents and enable spell checker and quick text entry on the phone To do that choose Options gt Preferences Spelling Options MobiSystems OfficeSuite e 28 Preferences To enter the Preference form choose Options gt Preferences In the Preferences screen you can set the default font which you wish to use to view documents The default font is used to display the text in your documents when there 1s no other font installed to the phone To browse through the available fonts on the phone use the arrow left and arrow right keys from the 5 way navigation key You can also choose to disp
75. tangent of 1 in radians p1 4 0 785398 ATAN2 1 1 Arctangent of the point 1 1 in radians p1 4 0 785398 ATANH 0 761594 16 Inverse hyperbolic tangent of 0 76159416 1 approximately COS 60 PI 180 Cosine of 60 degrees 0 5 COSH 4 Hyperbolic cosine of 4 27 30823 COUNTIF B2 BS gt 55 Number of cells with a value greater than 55 in the second column above 2 DEGREES PI Degrees of pi radians 180 e 44 Returns number rounded up to the nearest even integer You can use this function for processing items that come in twos For example a packing crate accepts rows of one or two items The crate is full when the number of items rounded up to the nearest two matches the crate s capacity The function can be used only for numeric fields Returns e constant raised to the power of number The constant e equals 2 71828182845904 the base of the natural logarithm EXP is the inverse of LN the natural logarithm of number Returns the factorial of a number The factorial of a number is equal to 1 2 3 number Rounds a number down to the nearest integer Returns the natural logarithm of a number Natural logarithms are based on the constant e 2 71828182845904 LN is the inverse of the EXP function Returns the logarithm of a number to the base you specify MobiSystems OfficeSuite EVEN number Number is the value to round EXP number Nu
76. uare root SUM numberl numberz2 Number number etc are 1 to 30 arguments for which you want the total value or sum ROUND 2 15 1 Rounds 2 15 to one decimal place 2 2 ROUNDDOWN 3 2 0 Rounds 3 2 down to zero decimal places 3 ROUNDUP 3 2 0 Rounds 3 2 up to zero decimal places 4 SIN 30 PI 180 Sine of 30 degrees 0 5 SINH 1 Hyperbolic sine of 1 1 175201194 SQRT 16 Square root of 16 4 SUM A2 A4 Adds the first three numbers in the column above e 47 Adds the cells SUMIF range criteria sum_ra specified by a given nge criteria Range is the range of cells you want evaluated Criteria is the criteria in the form of a number expression or text that defines which cells will be added For example criteria can be expressed as 32 32 e2 apples Sum range are the actual cells to sum Returns the tangent of TAN number TAN 45 PI 180 the given angle Tangent of 45 Number is the angle in radians degrees 1 for which you want the tangent Returns the hyperbolic TAN number TANH 2 tangent of a number Hyperbolic tangent Number is the angle in radians _ 2 0 96403 for which you want the tangent Truncates a number to TRUNC number num_digits TRUNC 8 9 an integer by removing Number is the number you Integer part of 8 9 the fractional part of the want to truncate 8 number WE SN Num digits is a number specifying the
77. urns the minutes of a time value The minute is given as an integer ranging from 0 to 59 Returns the month of a date represented by a serial number The month is given as an integer ranging from 1 January to 12 December Returns the serial number of the current date and time Returns the seconds of a time value The second is given as an integer in the range 0 zero to 59 Returns the decimal number for a particular time The decimal number returned by TIME is a value ranging from 0 zero to 0 99999999 representing the times from 0 00 00 12 00 00 AM to 23 59 59 11 59 59 P M MobiSystems OfficeSuite Dates should be entered by using the DATE function or as results of other formulas or functions For example use DATE 2008 5 23 for the 23rd day of May 2008 HOUR serial_number Serial number is the time that contains the hour you want to find Times may be entered as text strings within quotation marks for example 6 45 PM as decimal numbers for example 0 78125 which represents 6 45 PM or as results of other formulas or functions for example TIMEVALUE 6 45 PM MINUTE serial_number Serial number is the time that contains the minute you want to find Times may be entered as text strings within quotation marks for example 6 45 PM as decimal numbers for example 0 78125 which represents 6 45 PM or as results of other formulas or functions for example TIMEVALUE 6 45 PM
78. xt MobiSystems OfficeSuite e 37 Alignment The different Alignment options are accessible through Options gt Format gt Alignment You can choose among four styles General Left Center and Right To align one cell or a range of cells select them and choose the desired alignment option Fonts The font settings font type size style and color are directly accessible through Options gt Format gt F ont The font form also allows you to change the background color of a cell and use of the strike through font style To open the fonts settings form 1 Select the cell or the range of cells in the worksheet 2 Choose Options gt Format gt Font and enter the Font Preview form 3 Use the 5 way navigation key to scroll down the list of available options 4 Use the arrow left and arrow right keys to scroll through the different Fonts Styles and colors 5 Choose the desired Font and font settings and choose OK Hide This operation can be applied only to whole columns or rows or alternatively multiple columns or rows To hide a column or row select the column select 1t and choose Options gt Format gt Hide To hide a range of columns or rows select them and choose Options gt Format gt Hide To unhide a column or row select a column or row adjacent to 1t and choose Options gt Format gt Unhide Freeze The freeze function allows you to freeze selected row or column so it is constantly visible while you scroll the other colum
79. you want VLOOKUP to find an exact match or an approximate match If TRUE or omitted an approximate match 1s returned In other words if an exact match 1s not found the next largest value that is less than lookup value is returned CHAR number Number is a number between 1 and 255 specifying which character you want The character is from the character set used by your handheld CONCATENATE textl text2 Textl text2 are 1 to 30 text items to be joined into a e 65 string Compares two text strings and returns TRUE if they are exactly the same FALSE otherwise EXACT is case sensitive but ignores formatting differences Use EXACT to test text being entered into a document FIND finds one text string find text within another text string within text and returns the number of the starting position of find_text from the first character of within text You can also use SEARCH to find one text string within another but unlike SEARCH FIND is case sensitive and doesn t allow wildcard characters LEFT returns the first character or characters in a text string based on the number of characters you specify LEN returns the number of characters in a text string Converts all uppercase letters in a text string to lowercase MID returns a specific number of characters from a text string starting at the position you specify based on the number of characters you specify MobiSystems Offic

OfficeSuite s60

Contents

Download Pdf Manuals

Related Search

Related Contents