Nokia 9300i - page 51

TIME(hour,minute, second) Returns the serial number of a particular time.

TIMEVALUE(time,text) Converts a time in the form of text to a serial number.

TODAY( ) Returns a serial number of the current date.

TRIM(text) Removes spaces from text.

TRUE( ) Returns the logical value TRUE.

TRUNC(number, num_digits) Truncates a number to an integer.

TYPE(field) Returns a number which depends on the content of the

selected field.

UPPER(text) Converts text to uppercase.

VALUE(text) Converts a text argument to a number.

VAR(number1,number2,...) Estimates variance based on a sample.

VARP(number1,number2,...) Calculates variance based on the entire population.

VLOOKUP(lookup_value,table_array,col_index_num,...) Searches for a value in the leftmost column of a table and

returns a value.

YEAR(serial_number) Converts a serial number to a year.

Sheet

Contents

Main Page Contents For your safety..............................................................................6 9. Sheet.........................................................................................47 1. Getting started.........................................................................8 2. Cover phone............................................................................16 10. Presentations.......................................................................52 11. Calendar.................................................................................54 12. File manager........................................................................57 13. Control panel........................................................................59 14. Media applications.............................................................72 19. Personalizing your device................................................90 20. Shortcuts...............................................................................92 21. Data transmission..............................................................98 Battery information..................................................................99 Index...........................................................................................104 For your safety About your device NETWORK SERVICES Shared memory Enhancements, batteries, and chargers 1. Getting started Installing the SIM card, battery, and memory card Charging the battery Switching the device on and off Radios Antenna First start-up Access codes Keys and connectors Communicator interface Scrolling and making selections Common actions in several applications Cover phone Display indicators Keypad lock (Keyguard) Volume control Memory cards Instructions in your device Using the CD-ROM Nokia support and contact information Stickers in the sales package Transferring data from other devices 2. Cover phone Making a call Answering a call Options during a call Writing text Traditional text input Predictive text input Accessing the menu functions Messages Call register Contacts Shortcuts to the contacts list Searching for, adding, and deleting contacts Profiles Settings Page 3. Desk Managing groups Creating new groups 4. Telephone Making a call Answering a call Speed dialing Making a conference call Viewing dialed, received, and missed calls Sending DTMF tones Setting the offline profile Diverting calls Call barring Call, network, and phone line settings Call settings Network settings Advanced settings Voice mailbox settings Log 5. Messaging Messaging center Writing and reading messages Managing messages Avoiding low memory E-mail Working online and offline Writing and sending e-mail Sending options Retrieving e-mail Reading and replying to e-mail E-mail attachments Changing e-mail replying and viewing preferences E-mail account settings Page Text messages Sending options for a text message Replying to text messages Text message settings Modifying message center settings Managing messages on the SIM card Picture messages Multimedia messages Creating and sending multimedia messages Receiving multimedia messages Multimedia message account settings Fax Setting sending options for a fax Saving a received fax Editing fax settings Receiving faxes from a remote fax box Special message types Receiving operator logos Receiving ringing tones Receiving configuration messages Receiving e-mail notifications Cell broadcast 6. Web Browsing the Web Saving files Downloading files Cookies Browser settings Keyboard shortcuts for browsing 7. Contacts Managing contact cards Editing contact cards Creating and editing contact card templates My contact card Sending contact cards Sending a contact card Creating and editing contact groups Managing contacts saved in the SIM card Copying and moving contacts to different databases Contact card settings Page 8. Documents Working with documents Formatting documents Inserting and editing objects Viewing tables Using templates 9. Sheet Workbooks Working with worksheets Working with cells Creating and modifying chart sheets List of functions Page Page Page 10. Presentations Viewing presentations Viewing slide shows Showing slide shows with a data projector Creating presentations Inserting tables Working with different views Outline view Notes view Slide master view 11. Calendar Creating calendar entries Calendar icons Managing calendar entries Calendar settings Calendar views Month view Week view Day view Calendar files 12. File manager Managing files and folders Memory card security Page 13. Control panel General Date and time Regional settings Device language Data management Application manager Backup Memory Messaging tools Telephone Profile settings Data call and fax call diverting (network service) Data call and fax call barring (network service) Messaging Service message Connections Wireless LAN Cable setup RealPlayer settings Restore default IAP Security Device security Certificate manager Extras About product Location privacy Location request log HP printer selection Internet setup Setting up an Internet access point Configuring advanced Internet access point settings Page Setting up an Internet access point for a wireless LAN Page Configuring Internet connection settings Selecting an Internet access point 14. Media applications Images Viewing images Editing images Managing image files Voice recorder Opening the voice recorder Recording a phone call or voice memo Playing a voice recording Sending a voice recording Music player Listening to music Managing music tracks Sending music RealPlayer Playing media clips Adjusting media volume Sending media clips 15. Calculator Making calculations Using the scientific calculator Saving numbers to memory Setting the number format in Calculator 16. Clock Using world clock Using Alarm clock Alarms and reminders Cities and countries Page 17. Data and software management Data mover Backup Data transfer Sync Nokia PC Suite Installing applications and software Installing Symbian software Installing Java applications Java Java MIDP Java PP 18. Connectivity Wireless LAN Setting up an ad hoc network Cable connection IP passthrough Bluetooth settings Sending data with Bluetooth Receiving data with Bluetooth Pairing with a device SIM access profile Infrared Modem Printing Setting printing options Defining page setup Problems with printing Managing mobile printing settings Remote configuration (network service) Creating a new configuration server profile Data connections Wireless local area network (wireless LAN) Packet data (general packet radio service, GPRS) High-speed data calls (high-speed circuit switched data, HSCSD) GSM data calls Connection manager 19. Personalizing your device Changing the front cover Cover selection keys Page 20. Shortcuts General shortcuts Application-specific shortcuts Page Page Page Page 21. Data transmission Noise Roaming Electrostatic discharge Dead spots and dropouts Battery information Nokia battery authentication guidelines Authenticate hologram Page Care and maintenance Additional safety information Operating environment Medical devices Pacemakers Hearing aids Emergency calls CERTIFICATION INFORMATION(SAR) THIS MOBILE DEVICE MEETS GUIDELINES FOR EXPOSURE TO RADIO WAVES. Index A B C D G GPRS H HSCSD I R S T V W WLAN Y