S h e e t

 

COUNTA(value1,value2,...)

Counts how many values are in the list of arguments.

COUNTBLANK(range)

Counts the number of blank cells within a range.

DATE(year,month,day)

Returns the serial number of a particular date.

DATEVALUE(date_text)

Converts a date in the form of text to a serial number.

DAY(serial_number)

Converts a serial number to a day of the month.

DDB(cost,salvage,life,period,factor)

Returns the depreciation of an asset for a specified period using

 

the double-declining balance method or some other method

 

you specify.

DEGREES(angle)

Converts radians to degrees.

ERROR.TYPE(error_val)

Returns a number corresponding to an error type.

EXACT(text1,text2)

Checks if two text values are identical.

EXP(number)

Returns e raised to the power of a given number.

FACT(number)

Returns the factorial of a number.

False( )

Returns the logical value FALSE.

FIND(find_text,within_text,start_num)

Finds one text value within another (case-sensitive) one.

FV(rate,nper,pmt,pv,type)

Returns the future value of an investment.

HLOOKUP(lookup_value,table_array,row_index_num,...)

Looks in the top row of an array and returns the value of the

 

indicated cell.

HOUR(serial_number)

Converts a serial number to an hour.

IF(logical_test,value_if_true,value_if_false)

Specifies a logical test to perform.

INDEX(reference,row_num,column_num)

Uses an index to choose a value from a reference.

INDIRECT(reference,A1)

Returns the reference of a text.

INT(number)

Rounds a number down to the nearest integer.

IRR(value,guess)

Returns the internal rate of return for a series of cash flows.

ISBLANK(value)

Returns TRUE if the value is blank.

ISERR(value)

Returns TRUE if the value is any error except #N/A.

ISERROR(value)

Returns TRUE if the value is any error value.

ISLOGICAL(value)

Returns TRUE if the value is a logical value.

ISNA(value)

Returns TRUE if the value is the #N/A error value.

ISNONTEXT(value)

Returns TRUE if the value is non text.

ISNUMBER(value)

Returns TRUE if the value is a number.

ISTEXT(value)

Returns TRUE if the value is a text.

LEFT(text,num_chars)

Returns the leftmost characters from a text value.

LEN(text)

Returns the number of characters in a text string.

LN(number)

Returns the natural logarithm of a number.

LOG10(number)

Returns the base-10 logarithm of a number.

LOOKUP( )

Returns a value either from a one-row or one-column range,

 

or from an array.

LOWER(text)

Converts text to lowercase.

MAX(number1,number2,...)

Returns the maximum value in a list of arguments.

MID(text,start_num,num_chars)

Returns a specific number of characters from a text string.

MIN(number1,number2,...)

Returns the minimum value in a list of arguments.

MINUTE(serial_number)

Converts a serial number to a minute.

Copyright © 2004 Nokia. All Rights Reserved.

46

Page 46
Image 46
Nokia 9500 manual Lookup

9500 specifications

The Nokia 9500 Communicator, launched in 2004, stands as a landmark device in the evolution of mobile technology, blending the features of a smartphone with the functionality of a handheld computer. It was part of Nokia's Communicator series, which was known for its advanced features, and the 9500 was particularly significant due to its innovative design and robust capabilities.

One of the standout features of the Nokia 9500 is its distinctive clamshell design. When closed, it resembles a traditional mobile phone, compact and easy to carry. However, upon opening, the device reveals a full QWERTY keyboard and a large display, offering an exceptional typing experience for those who frequently send emails or create documents on the go. The keyboard is spacious and tactile, making it ideal for productivity tasks.

The 9500 is equipped with the Symbian OS, specifically the Series 80 user interface, which was optimized for the Communicator's unique form factor. Users could multitask efficiently, switching between applications seamlessly, which was a remarkable feature for its time. It supported various productivity applications including calendar, contacts, and word processing, enhancing its appeal to business users.

In terms of connectivity, the Nokia 9500 offers a range of options. It includes support for GPRS, providing users with internet access even while on the move. Wi-Fi capabilities further expanded its utility, allowing for faster data transfer rates and easier access to the internet in hot spots. Bluetooth technology was also included, enabling wireless data sharing with other devices.

The device features a 640x200 pixel display, which was impressive for its time, ensuring that both text and images were clear and easily readable. The Nokia 9500 also came with a camera, which was a novelty for mobile devices in the early 2000s, allowing users to capture images on the go.

Another important aspect of the 9500 is its battery life. It was designed to support extended usage, making it a reliable choice for professionals who needed to stay connected throughout the day. The device also supported expandable memory through a miniSD card slot, providing further flexibility for users to store more data.

In summary, the Nokia 9500 Communicator was a pioneering device that combined the functionalities of a mobile phone and a laptop. With its robust design, keyboard, productivity applications, and connectivity options, it set a foundation for future smartphones, showcasing what mobile computing could achieve long before the era of modern smartphones.